Postgres Pro
Downloads
Home   >   mailing lists

Using COALESCE nside function - Mailing list pgsql-general

From Robert Fitzpatrick
Subject Using COALESCE nside function
Date
Msg-id 1185213502.16660.22.camel@columbus.webtent.org
Whole thread Raw
Responses Re: Using COALESCE nside function  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Using COALESCE nside function  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] 8.2.4 signal 11 with large transaction
Next
From: Andrew Sullivan
Date:
Subject: Re: two phase commit