From: coyotitos_house@juno.com
To: pgsql-interfaces@postgresql.org
Subject: ECPG FETCH [number|ALL] IN cursor_name... with host variable
Date: Sun, 21 Nov 1999 00:25:11 -0500
Message-ID: <19991121.002513.-4143103.0.Coyotitos_house@juno.com> (raw)
The ECPG FETCH statement is very different from Pro*C & ESQL/C. It's hard
to know how to make normal features work.
I'm trying to tell FETCH to load host arrays with a run-time determined
number of rows:
int count = 10;
int age[10];
char name[10][30];
EXEC SQL FETCH :count IN the_cursor INTO :age, :name;
FETCH statements WILL allow a constant number in place of ":count". So,
replacing ":count" with "10" fetches the first ten rows from the cursor.
The keyword "ALL" also works. So, the backend functionality is there.
I'm using the RPM files for Postgres 6.5.3 and ECPG 2.6.0. I don't think
I have the source code.
Can anyone tell me whether I can just modify the parser to make this
feature possible? I understand yacc, and this can't be hard.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-interfaces@postgresql.org
Cc: coyotitos_house@juno.com
Subject: Re: ECPG FETCH [number|ALL] IN cursor_name... with host variable
In-Reply-To: <19991121.002513.-4143103.0.Coyotitos_house@juno.com>
References: <19991121.002513.-4143103.0.Coyotitos_house@juno.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox