Re: Cursor rowcount - Mailing list pgsql-performance

From Tom Lane
Subject Re: Cursor rowcount
Date
Msg-id 6429.1042496530@sss.pgh.pa.us
Whole thread Raw
In response to Cursor rowcount  (<typea@l-i-e.com>)
Responses Re: Cursor rowcount
List pgsql-performance
<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

pgsql-performance by date:

Previous
From:
Date:
Subject: Cursor rowcount
Next
From:
Date:
Subject: Re: Cursor rowcount