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.
-- Vik Fearing
