Obtaining nTuples from a cursor - Mailing list pgsql-general

From Michael Dunn
Subject Obtaining nTuples from a cursor
Date
Msg-id 3A79A349.6080404@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 I
also need to obtain the total number of records in the cursor without
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: Alberto Otero García
Date:
Subject: Full text search question (select...match...against).
Next
From: Bruce Momjian
Date:
Subject: Re: Order of Rules