Re: Way to use count() and LIMIT?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Way to use count() and LIMIT?
Дата
Msg-id 1164.1008782005@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Way to use count() and LIMIT?  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-general
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Still, it seems that there should be a way to grab the information,
> especially if you have an "ORDER BY" clause in your query - after
> all, that means at some point, postgres knows how many records
> matched before it ORDERS and LIMITS them.

Not necessarily; it could be using an indexscan to do the ordering.

            regards, tom lane

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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Way to use count() and LIMIT?
Следующее
От: "Ian Harding"
Дата:
Сообщение: Can't use subselect in check constraint