Re: DECLARE doesn't set/reset sqlca after DECLARE cursor

On Thu, Aug 13, 2009 at 05:55:53PM +0200, Boszormenyi Zoltan wrote:
> Okay, so it's a declarative command. But if we're in a function,
> we should still emit a call to ecpg_init, to be able to follow

No, either it is declarative or it is not, but I don't see a reason for
different behaviour depending on where the command is located.

> the Informix behaviour. We can limit it it compat mode, though.

So let's first figure out exactly how Informix handles things. Zoltan, do you
have access to esql the Informix precompiler? If so, please run two simple
tests, one with just a DECLARE statement and one with a DECLARE statement in a
function and post the results please.

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(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!