Obtaining nTuples from a cursor

From: Michael Dunn <michael(at)2cactus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Obtaining nTuples from a cursor
Date: 2001-01-31 20:33:50
Message-ID: 3A7876AE.4020709@2cactus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2001-01-31 20:51:48 Creating indeces on existing tables...
Previous Message Laurel Williams 2001-01-31 20:21:32 GIS-type databases using PostgreSQL