Single row fetch from backend

From: Theo Kramer <theo(at)flame(dot)co(dot)za>
To: hackers(at)postgresql(dot)org
Subject: Single row fetch from backend
Date: 1999-08-13 04:11:48
Message-ID: 37B39B04.D28BF0EE@flame.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

Does postgres support the notion of single row fetch without having to use
cursors with libpq.

What I want to do is something like

myResult = PQexec(myConnection, "select * from mytable where field >= ''")

for (int i = 0; i < PQntuples(myResult); i++) {
PQfetchRow(myResult);
}

Ie. rows are retrieved from the backend only on request. I can then control
when I want to stop retreiving rows.

--------
Regards
Theo

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Ivar Helbekkmo 1999-08-13 06:22:56 Re: [HACKERS] Re: We won!
Previous Message Tom Lane 1999-08-13 01:28:24 Re: [HACKERS] Aborted Transaction During Vacuum