Postgres Pro
Downloads
Home   >   mailing lists

Thread: number of rows in a cursor

number of rows in a cursor

From
"FERREIRA William (COFRAMI)"
Date:

hi

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

thanks in advance

        Will

Re: number of rows in a cursor

From
Michael Fuhr
Date:
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/