Re: Proposed new libpq API
Chris <chrisb@nimrod.itg.telstra.com.au>
From: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
To: The Hermit Hacker <scrappy@hub.org>
Cc: Chris Bitmead <chris@bitmead.com>, "pgsql-hackers@postgreSQL.org" <pgsql-hackers@postgresql.org>, pgsql-hackers-oo@postgresql.org
Date: 2000-07-05T23:42:00Z
Lists: pgsql-hackers
The Hermit Hacker wrote: > One last comment .. when you say 'random access', are you saying that I > can't do a 'PQexec()' to get the results for a SELECT, use a for loop to > go through those results, and then start from i=0 to go through that loop > again without having to do a new SELECT on it? Random access means that the whole query result is in memory. If you choose to use PQflush then you will no longer be able to go back to 0 and re-iterate. If you don't use PQflush then you can do what you do now which is go back and iterate through. If you use PQflush it means that you don't need to do that.