Re: shouldn't postgres know the numer of rows in a (sorted) result-set before returning the first row?

Поиск
Список
Период
Сортировка
От Thies C. Arntzen
Тема Re: shouldn't postgres know the numer of rows in a (sorted) result-set before returning the first row?
Дата
Msg-id C535BABE-F300-472A-B735-2238AF708A7C@thieso.net
обсуждение исходный текст
Ответ на Re: shouldn't postgres know the numer of rows in a (sorted)  (Richard Huxton <dev@archonet.com>)
Ответы Re: shouldn't postgres know the numer of rows in a (sorted)  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Дерево обсуждения

Am 16.11.2005 um 14:07 schrieb Richard Huxton:

You don't say what applicaton language you are using, but most offer a pg_num_rows() interface which tells you how many results are in the recordset you have fetched.


my query uses LIMIT and OFFSET - so pg_num_rows will return what i specify in LIMIT (or less). that's not the count i was asking for.

re, thies

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

Предыдущее
От: Alexander Presber
Дата:
Сообщение: Re: Tsearch2: casting text to tsquery
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: shouldn't postgres know the numer of rows in a (sorted)