number of rows in a cursor

Started by FERREIRA William (COFRAMI)about 21 years ago2 messagesgeneral
Jump to latest
#1FERREIRA William (COFRAMI)
william.ferreira@airbus.com

hi

is it possible to know the number of rows into a cursor ? does any function
exists ?

thanks in advance

Will

#2Michael Fuhr
mike@fuhr.org
In reply to: FERREIRA William (COFRAMI) (#1)
Re: number of rows in a cursor

On Mon, Mar 07, 2005 at 05:06:19PM +0100, FERREIRA William (COFRAMI) wrote:

is it possible to know the number of rows into a cursor ? does any function
exists ?

Not without scanning the result. See previous discussion:

http://archives.postgresql.org/pgsql-general/2005-01/msg01264.php
http://archives.postgresql.org/pgsql-general/2005-01/msg01312.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/