Re: Proposed new libpq API - Mailing list pgsql-hackers

From Chris Bitmead
Subject Re: Proposed new libpq API
Date
Msg-id 3963C7C8.B7DC382@nimrod.itg.telecom.com.au
Whole thread Raw
In response to Re: Proposed new libpq API  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [HACKERS-OO] Re: Proposed new libpq API  (The Hermit Hacker <scrappy@hub.org>)
List 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.


pgsql-hackers by date:

Previous
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Re: [GENERAL] Revised Copyright: is this morepalatable?
Next
From: Chris Bitmead
Date:
Subject: Re: Article on MySQL vs. Postgres