Re: [INTERFACES] Methods for stepping through results?

On Tue, 16 Feb 1999, Tom Lane wrote:

> Matthew Hagerty <matthew@venux.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@retep.org.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