From: | "Continuing Technical Education" <CTE(at)Dal(dot)Ca> |
---|---|
To: | "George Henry C(dot) Daswani" <gdaswani(at)esri(dot)com> |
Cc: | "Pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Problem with coalesce.. |
Date: | 2000-11-01 15:01:22 |
Message-ID: | 00a001c04414$997fd420$5911be86@cte.Dal.Ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Try:
SELECT COALESCE(CURVALUE,1) FROM TABLEKEYS WHERE TABLENAME = 'BUYER';
----- Original Message -----
From: George Henry C. Daswani
To: pgsql-sql(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Sent: Tuesday, October 31, 2000 5:52 PM
Subject: [SQL] Problem with coalesce..
Hello,
Was wondering if such a call is unsupported, or a bug?
7.0.2 (postgresql, linux redhat 7.0)
SELECT COALESCE ((SELECT NULL,1)
returns a 1, correct..
however..
SELECT COALESCE ((SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'),1)
returns a "UNKNOWN expression type 501"
SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'; returns a '0'
Thanks..
George
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver_Hall | 2000-11-01 15:33:01 | Re: Case insensitive LIKE queries |
Previous Message | Lamar Owen | 2000-11-01 14:44:53 | Re: postgres on redhat 7.0 |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-11-01 16:50:06 | Re: Problem with coalesce.. |
Previous Message | Sergei O . Naumov | 2000-11-01 14:02:12 | Help! Storing trees in Postgres |