Re: Proposal: QUALIFY clause

From: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Vik Fearing <vik(at)postgresfriends(dot)org>, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Richard Guo <guofenglinux(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Proposal: QUALIFY clause
Date: 2026-09-24 13:06:02
Message-ID: 2dcccd4b-c998-4d0e-8c13-52952d25d4a3@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 14/07/26 15:23, Matheus Alcantara wrote:
>
> [ ... ]
>
>> So there are two patches attached:
>>
>> - v2-0001-Add-QUALIFY-clause.patch: the query-rewrite approach, complete (window and
>> non-window QUALIFY), with docs and tests.
>>
>> - v2-0001-Add-QUALIFY-clause.patch.nocfbot: the planner-based approach,
>> window-functions only. Note that there is some test cases failing due
>> to WIP state.
>>
>
> CFBot was not happy with v2 due to some compiler warnings. Attaching v3
> with fixes, not major changes compared with v2.
>
v3 needs a rebase. Attaching v4 rebased, no changes compared with v3.

--
Matheus Alcantara
EDB: https://www.enterprisedb.com

Attachment Content-Type Size
v4-0001-Add-QUALIFY-clause.patch text/plain 85.7 KB
v4-0001-Add-QUALIFY-clause.patch.nocfbot text/plain 86.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2026-09-24 13:07:49 Re: [PATCH] Two remaining shmem attachment issues in single-user mode
Previous Message Egor Ivkov 2026-09-24 13:05:22 Re: [PATCH] pg_combinebackup: make the OID range check in parse_oid() effective