Re: Cursor rowcount

<typea@l-i-e.com> writes:
> I'm not finding any way in the docs of asking a cursor how many rows total
> are in the result set, even if I do "move 1000000 in foo", knowing a
> priori that 1000000 is far more than could be returned.

regression=# begin;
BEGIN
regression=# declare c cursor for select * from int8_tbl;
DECLARE CURSOR
regression=# move all in c;
MOVE 5                              <-----------------------
regression=# end;
COMMIT

            regards, tom lane