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

Zhihong Yu <zyu@yugabyte.com>

From: Zhihong Yu <zyu@yugabyte.com>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Vik Fearing <vik@postgresfriends.org>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>, Erwin Brandstetter <brsaweda@gmail.com>
Date: 2022-10-18T02:40:07Z
Lists: pgsql-hackers
On Mon, Oct 17, 2022 at 5:05 PM David Rowley <dgrowleyml@gmail.com> wrote:

> Thanks for having a look at this.
>
> On Fri, 14 Oct 2022 at 10:52, Zhihong Yu <zyu@yugabyte.com> wrote:
> > +       req->frameOptions = (FRAMEOPTION_ROWS |
> > +                            FRAMEOPTION_START_UNBOUNDED_PRECEDING |
> > +                            FRAMEOPTION_END_CURRENT_ROW);
> >
> > The bit combination appears multiple times in the patch.
> > Maybe define the combination as a constant in supportnodes.h and
> reference it in the code.
>
> I don't believe supportnodes.h has any business having any code that's
> related to actual implementations of the support request type.  If we
> were to have such a definition then I think it would belong in
> windowfuncs.c.  I'd rather see each implementation of the support
> request spell out exactly what they mean, which is what the patch does
> already.
>
> David
>
Hi,
I am fine with keeping the code where it is now.

Cheers

Commits

  1. Allow window functions to adjust their frameOptions