Q: CURSOR tuples count

From: "Vazsonyi Peter[ke]" <neko(at)kornel(dot)szif(dot)hu>
To: hackers(at)postgreSQL(dot)org
Subject: Q: CURSOR tuples count
Date: 1999-01-04 16:01:48
Message-ID: Pine.A32.4.05.9901041643220.16028-100000@kornel.szif.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vazsonyi Peter[ke] 1999-01-04 16:06:15 Q: Log, via triggers
Previous Message Bruce Momjian 1999-01-04 15:59:53 Re: [HACKERS] NAN code