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

Stephan Szabo <sszabo@megazone23.bigpanda.com> 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