Re: Obtaining a total number of records in a cursor (Count) - Mailing list pgsql-general

From Tom Lane
Subject Re: Obtaining a total number of records in a cursor (Count)
Date
Msg-id 262.986359064@sss.pgh.pa.us
Whole thread Raw
In response to Obtaining a total number of records in a cursor (Count)  (Michael Dunn <michael@2cactus.com>)
List pgsql-general
Michael Dunn <michael@2cactus.com> writes:
> is there a command, temporary table, or session in memory that I can
> obtain a total count of records for that cursor?

Not short of reading out the tuples ... in general there is no way to
predict the number of tuples that a query will return, except by
computing them.

            regards, tom lane

pgsql-general by date:

Previous
From: rjtalbo@attglobal.net
Date:
Subject: Caldera eDesktop 2.4 vs eServer 2.3
Next
From: Steven Vajdic
Date:
Subject: Is this a bug in 7.0.2?