Re: ecpg weird behavior

----- Original Message -----
From: "Michael Meskes" <meskes(at)postgresql(dot)org>
To: "Thomas Lockhart" <thomas(at)fourpalms(dot)org>
Cc: "Michael Meskes" <meskes(at)postgresql(dot)org>; "Nicolas Bazin"
<nbazin(at)ingenico(dot)com(dot)au>; <pgsql-interfaces(at)postgresql(dot)org>
Sent: Wednesday, March 20, 2002 6:16 AM
Subject: Re: [INTERFACES] ecpg weird behavior

> On Fri, Mar 15, 2002 at 09:11:34AM -0800, Thomas Lockhart wrote:
> > btw, I was working for the first time with ecpg and was very impressed.
>
> Thanks.
>
> > A company porting from Oracle ran into very few issues. Their existing
> > code *did* have an Oracle extension to use a cursor to select multiple
> > rows into variables declared as arrays. Have you run into this syntax or
> > thought about what it would take to implement it?
>
> Do you mean like this:
>
> exec sql begin declare section;
> int amount[6];
> char name[6][8];
> exec sql end declare section;
> ...
> exec sql select * into :name, :amount from "Test";
no what would work is
exec sql select * into :var1[i].name :var1[i].amount from "Test";

>
> This example btw is taken from test1.pgc under ecpg/test and thus is
> fully supported.
>
> Michael
> --
> Michael Meskes
> Michael(at)Fam-Meskes(dot)De
> Go SF 49ers! Go Rhein Fire!
> Use Debian GNU/Linux! Use PostgreSQL!
>