Re: Newbie question about casting literals - oracle/postgres - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Newbie question about casting literals - oracle/postgres
Date
Msg-id 20041027180943.GD5394@dcc.uchile.cl
Whole thread Raw
In response to Newbie question about casting literals - oracle/postgres  ("Naeem Bari" <naeem.bari@agilissystems.com>)
List pgsql-general
On Tue, Oct 26, 2004 at 08:24:56PM -0500, Naeem Bari wrote:

> The only way this works in postgres is by casting 'GREEN' to text using
> 'GREEN'::text
>
> The problem is then this does not work with oracle.

So use a standards-conformant cast, like

cast('GREEN' as text)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Those who use electric razors are infidels destined to burn in hell while
we drink from rivers of beer, download free vids and mingle with naked
well shaved babes." (http://slashdot.org/comments.pl?sid=44793&cid=4647152)


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Array values and foreign keys
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Reasoning behind process instead of thread based