Re: number of records returned by cursors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zac <zaccheob(at)inwind(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: number of records returned by cursors
Date: 2005-06-27 14:29:59
Message-ID: 6329.1119882599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zac <zaccheob(at)inwind(dot)it> writes:
> does anyone know if there is a way (in plpgsql) to obtain the number of
> records returned by a cursor without fetching them all?

No. The system itself does not know that until you've fully executed
the query ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2005-06-27 14:32:43 Re: Finding points within 50 miles
Previous Message Roman Neuhauser 2005-06-27 13:55:54 Re: Postfix/Maildrop and too many connections issues