Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AC8DA477192 for ; Mon, 13 Jan 2003 17:23:18 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 07E764770D4 for ; Mon, 13 Jan 2003 17:22:10 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0DMMA5u006430; Mon, 13 Jan 2003 17:22:10 -0500 (EST) To: typea@l-i-e.com Cc: pgsql-performance@postgresql.org Subject: Re: Cursor rowcount In-reply-to: <49456.216.80.95.13.1042493599.squirrel@www.l-i-e.com> References: <49456.216.80.95.13.1042493599.squirrel@www.l-i-e.com> Comments: In-reply-to message dated "Mon, 13 Jan 2003 13:33:19 -0800" Date: Mon, 13 Jan 2003 17:22:10 -0500 Message-ID: <6429.1042496530@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/78 X-Sequence-Number: 725 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