Q: CURSOR tuples count

Vazsonyi Peter[ke] <neko@kornel.szif.hu>

From: "Vazsonyi Peter[ke]" <neko@kornel.szif.hu>
To: hackers@postgreSQL.org
Date: 1999-01-04T16:01:48Z
Lists: pgsql-hackers
Hello!

I want to make a filtered selection on a table. This can return with many
tuples. The download of the query results may take a few  minutes. I'd like
to show the progress status. How can i do this?
If i run this in two query (first i count the number of lines, than the real
query), than the backend calculates the query two times.
If i use cursor, i can not get the line count before i fetch the whole table.

--
 So long and thanx for all the fish.
 NeKo@(kva.hu|kornel.szif.hu)