Horton

Re: Proposal: QUALIFY clause

Matheus Alcantara <matheusssilv97@gmail.com>

View thread
From: "Matheus Alcantara" <matheusssilv97@gmail.com>
To: "Vik Fearing" <vik@postgresfriends.org>, "Pg Hackers" <pgsql-hackers@postgresql.org>
Cc: "Peter Eisentraut" <peter@eisentraut.org>
Date: 2025-07-21T21:29:05Z
Lists: pgsql-hackers

Attachments

On Mon Jul 21, 2025 at 5:23 PM -03, Vik Fearing wrote:
>
> On 21/07/2025 14:47, Matheus Alcantara wrote:
>> Hi all,
>>
>> I'm sending a proof-of-concept patch to add support for the QUALIFY
>> clause in Postgres. This feature allows filtering rows after window
>> functions are computed, using a syntax similar to the WHERE or HAVING
>> clauses.
>
>
> I took a very brief look at this, and I think your grammar is wrong.  
> The QUALIFY clause should go after the WINDOW clause, just like 
> FROM/WHERE and GROUP BY/HAVING.
>
>
> That is what I am proposing to the standards committee, and I already 
> have some buy-in for that.
>
Thank you for the brief review and for the comments!

I'm not sure if I fully understand but please see the new attached
version.

Thanks,

--
Matheus Alcantara