Re: Cursor rowcount

From: <typea(at)l-i-e(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Cursor rowcount
Date: 2003-01-14 01:05:50
Message-ID: 50156.216.80.95.13.1042506350.squirrel@www.l-i-e.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> <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

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...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-01-14 04:19:40 Re: Cursor rowcount
Previous Message Josh Berkus 2003-01-13 22:32:47 Re: Multiple databases