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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
