Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative
Date
Msg-id CAKFQuwZ3SrJ1Xrmxw7-J=S1cJ39oXjJYGKbmDZ-NCxQQK5FeZA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative  (Navrotskiy Artem <bozaro@yandex.ru>)
List pgsql-general
Tree view
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 by date:

Previous
From: Navrotskiy Artem
Date:
Subject: [GENERAL] Window functions can't be used as LIMIT/FETCH FIRST alternative
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Partitioned Data and Locking