Re: retrieving parts of a resultset

From: Christoffer Gurell <orbit(at)0x63(dot)nu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: retrieving parts of a resultset
Date: 2004-02-08 12:32:21
Message-ID: 20040208123220.GA32689@h55p111.delphi.afb.lu.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 06, 2004 at 02:31:38PM -0300, Franco Bruno Borghesi wrote:
> I think you should use a cursor; you declare it, and then you fetch the
> rows as you need them.

thanks this works really nice.. just one more question .. how do i check the
number of rows in a cursor? or do i have to do a select count(*) on the query
i use to create the cursor?

/ Christoffer Gurell

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2004-02-08 14:02:01 Repost: postmaster growing to consume all memory
Previous Message David Garamond 2004-02-08 11:42:55 Partial index in other DB