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

From David Rowley
Subject Re: Window Function "Run Conditions"
Date
Msg-id CAApHDvq29swVhJZAgLfVsrXHU-sFbEDePaCzWfauv5UvWu13KA@mail.gmail.com
Whole thread Raw
In response to Re: Window Function "Run Conditions"  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: Window Function "Run Conditions"  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
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
isto 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.

David



pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: New Object Access Type hooks
Next
From: Tom Lane
Date:
Subject: Re: New Object Access Type hooks