Thread: Obtaining nTuples from a cursor

Obtaining nTuples from a cursor

From
Michael Dunn
Date:
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