Postgres Pro
Downloads
Home   >   mailing lists

Find out the number of rows returned by refcursor? - Mailing list pgsql-general

From Karen Hill
Subject Find out the number of rows returned by refcursor?
Date
Msg-id 1160501590.789155.57060@e3g2000cwe.googlegroups.com
Whole thread Raw
List pgsql-general
Tree view 
What is the best way to find out the total number of rows returned by
an refcursor?  This would allow the client user to know the total
amount of rows as they are using FETCH FORWARD/BACKWARD.

For example let's say that an refcursor has 300 rows.  The user fetches
20 at a time.  I would like the user to know that there are 300
possible rows.


regards,
karen

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [PERFORM] Postgre 8.0 Installation - Issues
Next
From: "Alex Turner"
Date:
Subject: Re: Size of tuples