Try:
SELECT COALESCE(CURVALUE,1) FROM TABLEKEYS WHERE
TABLENAME = 'BUYER';
- Original Message -
From:
George Henry C.
Daswani
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 31, 2000 5:52
PM
Subject: [SQL] Problem with
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 t
