Re: [INTERFACES] Methods for stepping through results?

On Tue, 16 Feb 1999, Tom Lane wrote:

> Matthew Hagerty <matthew(at)venux(dot)net> writes:
> > Is there any way to do the following:
> > 1. Return a query in groups of x (i.e. 10 or 20) and progressively return
> > result groups of x. Just think of search engine navigation.
>
> DECLARE CURSOR ... FETCH ...
>
> There has been some talk of providing a facility for this inside libpq,
> where it could be used for handling the results of an ordinary SELECT.
> But it doesn't seem real high priority, given that you can use a cursor.

Part of the JDBC2 spec has the option of this sort of handling of
select's.

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf