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