Skip site navigation (1) Skip section navigation (2)

Re: ecpg weird behavior

From: "Nicolas Bazin" <nbazin(at)ingenico(dot)com(dot)au>
To: "Michael Meskes" <meskes(at)postgresql(dot)org>
Cc: "Thomas Lockhart" <thomas(at)fourpalms(dot)org>,"Michael Meskes" <meskes(at)postgresql(dot)org>,<pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: ecpg weird behavior
Date: 2002-03-20 00:15:14
Message-ID: 002b01c1cfa4$4e7e49d0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
----- Original Message -----
From: "Michael Meskes" <meskes(at)postgresql(dot)org>
To: "Nicolas Bazin" <nbazin(at)ingenico(dot)com(dot)au>
Cc: "Thomas Lockhart" <thomas(at)fourpalms(dot)org>; "Michael Meskes"
<meskes(at)postgresql(dot)org>; <pgsql-interfaces(at)postgresql(dot)org>
Sent: Wednesday, March 20, 2002 6:18 AM
Subject: Re: [INTERFACES] ecpg weird behavior

> On Mon, Mar 18, 2002 at 10:41:41AM +1100, Nicolas Bazin wrote:
> > Yes I also have this issue. From what I read in the ecpg doc, indexed
> > variables are not supported by ecpg and trying to compile the code
> Yes, there's an open TODO for that.
> > proved it is not supported. The way I work arround it is to declare a
> > variable of the same type, copy the array element into this variable,
> > perform the FECTH or SELECT and then copy the variable back into the
> > element. I guess the preprocessor could also generate the code.
> It should be even easier. I think the parser could handle that directly.
> > Another issue I had that ecpg does not support prepared statements. But
> > didn't have that many prepared statements so I just rewrote the code.
> ECPG just simulates a prepare statement, but that should not qualify as
> "not support". So what didn't work?

EXEC SQL PREPARE statement FROM :requete;
EXEC SQL DECLARE curs_cartlstnoire CURSOR FOR statement;
didn't get preprocessed.

> Michael
> --
> Michael Meskes
> Michael(at)Fam-Meskes(dot)De
> Go SF 49ers! Go Rhein Fire!
> Use Debian GNU/Linux! Use PostgreSQL!

In response to


pgsql-interfaces by date

Next:From: Hal DavisonDate: 2002-03-20 00:39:27
Subject: Re: ecpg weird behavior
Previous:From: Nicolas BazinDate: 2002-03-19 23:56:39
Subject: Re: ecpg weird behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group