Cursors and move

From: Marcin Kadziolka <kalma(at)polsl(dot)gliwice(dot)pl>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Cursors and move
Date: 1999-07-28 19:12:46
Message-ID: 19990728211246.A1996@polsl.gliwice.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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?

--
Na razie | Zapraszam na: http://www.polsl.gliwice.pl/~kalma
Marcin |

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 1999-07-29 00:45:42 Re: [INTERFACES] Cursors and move
Previous Message Andrei N.Sobchuck 1999-07-28 15:25:24