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) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org