Obtaining nTuples from a cursor

Поиск
Список
Период
Сортировка
От Michael Dunn
Тема Obtaining nTuples from a cursor
Дата
Msg-id 3A79A349.6080404@2cactus.com
обсуждение исходный текст
Список pgsql-general
I would like to know if there is a way to return nTuples for a cursor
without having to FETCH ALL from the cursor.  I am sorting over 500k
records and growing.. and return 1k at time from the cursor.  But, It I
also need to obtain the total number of records in the cursor without
having to either do a SELECT count(*) of the same query or returning ALL
from the cursor.  It is entirely innefficient...

Regards, Michael


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

Предыдущее
От: Alberto Otero García
Дата:
Сообщение: Full text search question (select...match...against).
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Order of Rules