Obtaining nTuples from a cursor - Mailing list pgsql-general

From Michael Dunn
Subject Obtaining nTuples from a cursor
Date
Msg-id 3A7876AE.4020709@2cactus.com
Whole thread Raw
List pgsql-general
I would like to know if there is a way to return nTuples for a cursor
without having to FETCH ALL from the cursor.  I am sorting over 500k
records and growing.. and return 1k at time from the cursor.  But, It
would be nice to obtain the number of records in the cursor with having
to either do a SELECT count(*) of the same query or returning ALL from
the cursor.  It is entirely innefficient...

Regards, Michael


pgsql-general by date:

Previous
From: "cwz"
Date:
Subject: Re: How do I list all tables?
Next
From: ""
Date:
Subject: Re: Help me please!! -newbie-