<typea(at)l-i-e(dot)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