Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D89D2475E9D for ; Mon, 13 Jan 2003 20:05:44 -0500 (EST) Received: from o2.hostbaby.com (o2.hostbaby.com [208.187.29.121]) by postgresql.org (Postfix) with SMTP id 0C11D475D3B for ; Mon, 13 Jan 2003 20:05:44 -0500 (EST) Received: (qmail 23419 invoked from network); 14 Jan 2003 01:05:50 -0000 Received: from unknown (HELO l-i-e.com) (127.0.0.1) by localhost with SMTP; 14 Jan 2003 01:05:50 -0000 Received: from 216.80.95.13 (Hostbaby Webmail authenticated user typea@l-i-e.com) by www.l-i-e.com with HTTP; Mon, 13 Jan 2003 17:05:50 -0800 (PST) Message-ID: <50156.216.80.95.13.1042506350.squirrel@www.l-i-e.com> Date: Mon, 13 Jan 2003 17:05:50 -0800 (PST) Subject: Re: Cursor rowcount From: To: In-Reply-To: <6429.1042496530@sss.pgh.pa.us> References: <49456.216.80.95.13.1042493599.squirrel@www.l-i-e.com> <6429.1042496530@sss.pgh.pa.us> X-Priority: 3 Importance: Normal X-Mailer: Hostbaby Webmail MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/79 X-Sequence-Number: 726 > 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 Yes, but as noted in my longer version, that number does not seem to "come through" the PHP API. I've tried calling just about every function I can in the PHP API in a test script, and none of them give me that number. At least, none that I can find...