Quick Links

Re: Number of rows in a cursor ?

From:	Bo Lorentsen <bl(at)netgroup(dot)dk>
To:	neil(dot)saunders(at)accenture(dot)com
Cc:	pgsql-sql(at)postgresql(dot)org
Subject:	Re: Number of rows in a cursor ?
Date:	2005-08-24 10:31:12
Message-ID:	430C4C70.2010005@netgroup.dk
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

neil(dot)saunders(at)accenture(dot)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

In response to

Re: Number of rows in a cursor ? at 2005-08-24 10:00:54 from neil.saunders

Responses

Re: Number of rows in a cursor ? at 2005-08-24 11:36:29 from Russell Simpkins
Re: Number of rows in a cursor ? at 2005-08-24 12:08:22 from John DeSoi

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Dinesh Pandey	2005-08-24 11:15:06	SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Previous Message	Bo Lorentsen	2005-08-24 10:27:11	Re: Number of rows in a cursor ?