Single row fetch from backend - Mailing list pgsql-hackers

From Theo Kramer
Subject Single row fetch from backend
Date
Msg-id 37B39B04.D28BF0EE@flame.co.za
Whole thread Raw
Responses Re: [HACKERS] Single row fetch from backend
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Aborted Transaction During Vacuum
Next
From: Tom Ivar Helbekkmo
Date:
Subject: Re: [HACKERS] Re: We won!