Re: Cursor rowcount

Поиск
Список
Период
Сортировка
От
Тема Re: Cursor rowcount
Дата
Msg-id 50156.216.80.95.13.1042506350.squirrel@www.l-i-e.com
обсуждение исходный текст
Ответ на Re: Cursor rowcount  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Cursor rowcount  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

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




В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Cursor rowcount
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cursor rowcount