From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: kalma@polsl.gliwice.pl
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Cursors and move
Date: Wed, 28 Jul 1999 20:45:42 -0400
Message-ID: <379FA436.631803B3@home.com> (raw)
References: <19990728211246.A1996@polsl.gliwice.pl>
Marcin Kadziolka wrote:
>
> Hi All!
>
> First of all, I'm not sure if it is on-topic here. If not, show a correct
> place to me, please.
>
> I've got some problems with cursors and move command.
> I write a program using libpq and I have something like this:
>
> BEGIN
> DECLARE cur CURSOR FOR SELECT num FROM zlec
> FETCH FORWARD 2 IN cur
> MOVE BACKWARD ALL IN cur
> FETCH FORWARD 2 IN cur
>
> In the last FETCH command PQresultStatus(res) returns PGRES_TUPLES_OK, but
> PQntuples(res) returns 0.
> Is it a correct behaviour of the move command? Or I missed something?
>
The cursors have never really worked right. Especially the move seems
wrong, once you go off the edge, you're screwed.
Dave Hartwig was close to a fix for this at one point, but he gave up.
Byron
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, kalma@polsl.gliwice.pl
Subject: Re: [INTERFACES] Cursors and move
In-Reply-To: <379FA436.631803B3@home.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