On Jul 23, 2007, at 12:58 , Robert Fitzpatrick wrote:
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?
I don't know if there's a way to handle this using COALESCE, but
could you do it using something like
SELECT INTO cursor_pos -- rest of query
IF NOT FOUND THEN cursor_pos := 0; END IF;
Note I haven't used cursors before, and I'm assuming you're using PL/
pgSQL.
Michael Glaesemann
grzm seespotcode net
