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)