Re: [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative
Дата
Msg-id CAKFQuwZ3SrJ1Xrmxw7-J=S1cJ39oXjJYGKbmDZ-NCxQQK5FeZA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative  (Navrotskiy Artem <bozaro@yandex.ru>)
Список pgsql-general
Дерево обсуждения
On Sat, May 20, 2017 at 2:50 AM, Navrotskiy Artem <bozaro@yandex.ru> wrote:
This is especially unpleasant for expressions using RANK and DENSE_RANK, which can not simply be rewritten using LIMIT.

​They cannot anyway, at least not DENSE_RANK with ties.​

Others will have to speak to the dynamics involved with the overall current behavior.

David J.

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

Предыдущее
От: Navrotskiy Artem
Дата:
Сообщение: [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Partitioned Data and Locking