Обсуждение: number of rows in a cursor

Поиск
Список
Период
Сортировка

number of rows in a cursor

От
"FERREIRA William (COFRAMI)"
Дата:

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

От
Michael Fuhr
Дата:
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/