Re: Using COALESCE nside function

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