Re: Quota query with decent performance?

Поиск
Список
Период
Сортировка
От Chester Kustarz
Тема Re: Quota query with decent performance?
Дата
Msg-id Pine.BSO.4.44.0311111832190.19584-100000@detroit.arbor.net
обсуждение исходный текст
Ответ на Quota query with decent performance?  (Troels Arvin <troels@arvin.dk>)
Список pgsql-sql
maybe:

select *
from person
where age <=
(select age from person order by age limit 1 offset 2);

7.20 msec

assuming it does what you want.

On Tue, 11 Nov 2003, Troels Arvin wrote:
> An example of a quota query could be to get the top-3 youngest people from
> a collection of people. The complicated part is that such a query might
> return more than 3 rows in some tie situations.



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Quota query with decent performance?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Quota query with decent performance?