Re: Number of rows in a cursor ? - Mailing list pgsql-sql

On Aug 24, 2005, at 6:31 AM, Bo Lorentsen wrote:

> How sad, then I have to repeat the query, first for counting and  
> last for data fetch :-(

No, you can use the MOVE command and read how many rows you moved  
with something like

MOVE LAST IN mycursor;

http://www.postgresql.org/docs/8.0/interactive/sql-move.html



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL