Postgres Pro
Downloads
Home   >   mailing lists

Re: DECLARE doesn't set/reset sqlca after DECLARE cursor - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: DECLARE doesn't set/reset sqlca after DECLARE cursor
Date
Msg-id 20090813113319.GA5505@feivel.credativ.lan
Whole thread Raw
In response to DECLARE doesn't set/reset sqlca after DECLARE cursor  (Boszormenyi Zoltan <zb@cybertec.at>)
Responses Re: DECLARE doesn't set/reset sqlca after DECLARE cursor  (Boszormenyi Zoltan <zb@cybertec.at>)
List pgsql-hackers
Tree view 
On Wed, Aug 12, 2009 at 07:13:44PM +0200, Boszormenyi Zoltan wrote:
> a customer of us complained a behavioural difference
> ...
> The attached patch implements this. The only downside
> is that now DECLARE CURSOR cannot appear outside
> of a function, a change in test/preproc/variable.pgc reflects

DECLARE by definition is a declarative command and as such should be able to
live outside a function.

Michael

-- 
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ: 179140304, AIM/Yahoo/Skype: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: FDW-based dblink
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: surprising trigger/foreign key interaction