Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Methods for stepping through results?

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Matthew Hagerty <matthew(at)venux(dot)net>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] Methods for stepping through results?
Date: 1999-02-16 20:13:33
Message-ID: Pine.LNX.4.04.9902162012290.29227-100000@maidast.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


In response to

pgsql-interfaces by date

Next:From: Vince DiCieroDate: 1999-02-17 00:58:45
Subject: RE: [INTERFACES] Methods for stepping through results?
Previous:From: System ManagerDate: 1999-02-16 18:15:29
Subject: unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group