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-18 17:01:01
Message-ID: CAMT0RQRjvzGYNgUBzmRaRuX64m-VM2n6Stm3ANmzigoSb_Wf1w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At first glance it looks very much like what DuckDB does with USING
KEY syntax they have described here
https://www.cidrdb.org/cidr2023/papers/p14-hirn.pdf

I learned about DuckDB USING KEY just 2 days ago from
https://lnkd.in/p/ebCwa9Wk

-----
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2026-09-18 17:05:21 Re: Regression tests failures due to concurrent grants
Previous Message Tristan Partin 2026-09-18 17:00:32 Stop asserting that Unicode normalization consumes its whole input