Re: Number of rows in a cursor ? - Mailing list pgsql-sql

From Russell Simpkins
Subject Re: Number of rows in a cursor ?
Date
Msg-id BAY103-DAV72BF461390EA073012267B5A80@phx.gbl
Whole thread Raw
In response to Re: Number of rows in a cursor ?  (<neil.saunders@accenture.com>)
Responses Re: Number of rows in a cursor ?  (Bo Lorentsen <bl@netgroup.dk>)
List pgsql-sql
> neil.saunders@accenture.com wrote:
>
>>You cannot count the number of rows in a cursor, unfortunately. I recently 
>>ran in to this problem.
>>
> How sad, then I have to repeat the query, first for counting and last for 
> data fetch :-(
>
> /BL
>

If you need a count, why not just execute one of the methods to get a count. 
i.e.e select count(id) ... 


pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Next
From: "Russell Simpkins"
Date:
Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported