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 ()
"T
hi,
I think it works for me. what version of postgres do you have? maybe
you just need to upgrade : )
test=# select cust_id, 'TEST' as test, cust_address from customers;
cust_id | test | cust_address
+--+--
11 | TEST | 200 Maple Lane
100
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. Since my
software has to support both databases, I am left in a bit of a bind. Any ideas on how to make postgres
accept ‘GREEN’
as text without
