Re: FETCH FIRST clause WITH TIES option

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: FETCH FIRST clause WITH TIES option
Дата
Msg-id CA+TgmoaCO14q0cVkZpntRh+0wQArO6mF14uF6hZ_QcdnfHDR6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FETCH FIRST clause WITH TIES option  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: FETCH FIRST clause WITH TIES option
Список pgsql-hackers
On Mon, Oct 29, 2018 at 12:48 PM Andrew Gierth
<andrew@tao11.riddles.org.uk> wrote:
> Then FETCH FIRST N WITH TIES becomes "stop when the expression
>   rank() over (order by ...) <= N
> is no longer true" (where the ... is the existing top level order by)

Wouldn't that be wicked expensive compared to something hard-coded
that does the same thing?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pg_promote not marked as parallel-restricted in pg_proc.dat
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: ToDo: show size of partitioned table