Using COALESCE nside function

From: Robert Fitzpatrick <lists(at)webtent(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Using COALESCE nside function
Date: 2007-07-23 17:58:22
Message-ID: 1185213502.16660.22.camel@columbus.webtent.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-07-23 18:48:14 Re: two phase commit
Previous Message Tom Lane 2007-07-23 17:44:03 Re: [HACKERS] 8.2.4 signal 11 with large transaction