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

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Erwin Brandstetter <brsaweda(at)gmail(dot)com>
Subject: Re: Allow WindowFuncs prosupport function to use more optimal WindowClause options
Date: 2022-10-20 20:02:47
Message-ID: CAApHDvrkd75-Bjcz8crze-KzsPEVzpZn6DepzOkq-VGx33X30g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 13 Oct 2022 at 13:34, David Rowley <dgrowleyml(at)gmail(dot)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

Attachment Content-Type Size
v3_optimize_row_numbers_frameoptions_when_possible.patch text/plain 14.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2022-10-20 20:05:04 Re: has_privs_of_role vs. is_member_of_role, redux
Previous Message Jeff Davis 2022-10-20 19:57:43 Re: has_privs_of_role vs. is_member_of_role, redux