Request a Demo
Home   >   mailing lists

Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)
Date
Msg-id CAMT0RQRjvzGYNgUBzmRaRuX64m-VM2n6Stm3ANmzigoSb_Wf1w@mail.gmail.com
Whole thread
In response to Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)  (Hannu Krosing <hannuk@google.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Tristan Partin"
Date:
Subject: Stop asserting that Unicode normalization consumes its whole input
Next
From: Jacob Champion
Date:
Subject: Re: Regression tests failures due to concurrent grants