Obtaining nTuples from a cursor

From: Michael Dunn <michael(at)2cactus(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Obtaining nTuples from a cursor
Date: 2001-02-01 17:56:25
Message-ID: 3A79A349.6080404@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 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

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-02-01 17:59:05 Re: Order of Rules
Previous Message Alberto Otero García 2001-02-01 17:15:46 Full text search question (select...match...against).