Re: [HACKERS] libpq: why we need to fetch all rows?

>
> On Sun, Jun 29, 1997 at 01:44:36PM -0400, Bruce Momjian wrote:
>
> > Because it is not standard SQL.  No database I know of returns multiple
> > rows with out a 'declare' statement and a cursor.

Actually, standard SQL requires a cursor so you can name the cursor to
fetch from, but PostgreSQL requires it to be in a transaction, which is
not standard.

>
>   Not so good... But then, why not to modify backend and libpq
>   in a way, which will allow to fetch rows one-by-one?

OK, can you run a test?  If you start a transaction, declare a cursor,
and do a fetch over and over again, does it return one line at a time
from the server.  I think it does.

Now, it will not return from the first fetch until the query has
finished executing, but I don't think it will send all the results to
the client, only one at a time.

- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------