Re: [SQL] Re: [GENERAL] Problem with coalesce..

[Tom Lane]

Stephan Szabo <[EMAIL PROTECTED]> writes:
> There are still some contexts in which subqueries in expressions are
> wierd. The example below appears to work in current sources however.

>> SELECT COALESCE ((SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'),1)
>> returns a "UNKNOWN expression type 501"

AFAICT it works in 7.0.* as well.  Are you sure this was 7.0.2, and
not 6.5.something?

                        regards, tom lane