Postgres Pro
Downloads
Home   >   mailing lists

Re: Window Function "Run Conditions" - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Window Function "Run Conditions"
Date
Msg-id CAKFQuwYwoqT06QGr5kEpCbCfKG9LZ1bDKuuwOVwxrU1aOi4LUA@mail.gmail.com
Whole thread Raw
In response to Re: Window Function "Run Conditions"  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view
On Tue, Mar 22, 2022 at 3:39 PM David Rowley <dgrowleyml@gmail.com> wrote:
On Thu, 17 Mar 2022 at 17:04, Corey Huinker <corey.huinker@gmail.com> wrote:
> It seems like this effort would aid in implementing what some other databases implement via the QUALIFY clause, which is to window functions what HAVING is to aggregate functions.
> example: https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#qualify_clause

Isn't that just syntactic sugar?  You could get the same from adding a
subquery where a WHERE clause to filter rows evaluated after the
window clause.


I'd like some of that syntactic sugar please.  It goes nicely with my HAVING syntactic coffee.

David J.

pgsql-hackers by date:

Previous
From: Japin Li
Date:
Subject: Re: Support logical replication of DDLs
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: [PATCH] Accept IP addresses in server certificate SANs