From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | robert(at)webtent(dot)com |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Using COALESCE nside function |
Date: | 2007-07-23 18:59:22 |
Message-ID: | A1A78543-11E7-4226-87D1-9393B982C0D0@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ben | 2007-07-23 18:59:39 | Re: two phase commit |
Previous Message | Chris Browne | 2007-07-23 18:52:13 | Re: Delete/update with limit |