Find out the number of rows returned by refcursor?

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Find out the number of rows returned by refcursor?
Date: 2006-10-10 17:33:10
Message-ID: 1160501590.789155.57060@e3g2000cwe.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Turner 2006-10-10 17:49:20 Re: Size of tuples
Previous Message woonhak kang 2006-10-10 17:23:28 Problem with executing PostgreSQL on Embedded Linux