Re: Allow WindowFuncs prosupport function to use more optimal WindowClause options

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es

From: David Rowley <dgrowleyml@gmail.com>

To: Vik Fearing <vik@postgresfriends.org>

Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>, Erwin Brandstetter <brsaweda@gmail.com>

Date: 2022-10-20T20:02:47Z

Lists: pgsql-hackers

Attachments

v3_optimize_row_numbers_frameoptions_when_possible.patch (text/plain) patch v3

On Thu, 13 Oct 2022 at 13:34, David Rowley <dgrowleyml@gmail.com> wrote:
> So it looks like the same can be done for rank() and dense_rank() too.
> I've added support for those in the attached.

The attached adds support for percent_rank(), cume_dist() and ntile().

David

Commits

Allow window functions to adjust their frameOptions
- ed1a88ddaccf 16.0 landed