Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)

From: Hannu Krosing <hannuk(at)google(dot)com>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Dilip Kumar <dilipkumarb(at)google(dot)com>
Subject: Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)
Date: 2026-09-16 20:40:42
Message-ID: CAMT0RQSt7k_=6Wxm4Q=6XP1GJsMsfe+c-+-c1rp89PKMZHFN=Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rebased

Attachment Content-Type Size
v2-0001-Refactor-set-operation-group-clauses-to-decouple-fro.patch application/x-patch 9.7 KB
v2-0004-Support-dynamic-pruning-in-recursive-UNION-DISTINCT-.patch application/x-patch 17.7 KB
v2-0003-Support-UNION-DISTINCT-ON-for-non-recursive-set-oper.patch application/x-patch 21.0 KB
v2-0002-Support-inline-ORDER-BY-in-DISTINCT-ON-for-SELECT-an.patch application/x-patch 28.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Corey Huinker 2026-09-16 20:45:26 Re: [PG19][PATCH] Make postgres_fdw statistics import atomic
Previous Message Fabrizio Mello 2026-09-16 20:13:21 Re: Fix failing assert in deferred constraint trigger