[GENERAL] Using COALESCE nside function

[Robert Fitzpatrick]

Is it possible to use COALESCE function inside a function as a cursor
variable?

test cursor (myvar varchar) for
          (coalesce(SELECT...<snip>,0));

I get a syntax error when trying this...ERROR:  syntax error at or near
"COALESCE"...is there a way to do this?

-- 
Robert


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster