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

Title

CI (CFBot)

Needs rebase! Needs rebase since 2 hours. Failing since 2 hours.
Additional links previous successfully applied patch (outdated):

Stats (from CFBot)

Unknown

Tags

SQL Commands

Created

2026-09-16 15:17:34

Last modified

2026-09-16 15:17:34 (2 hours ago)

Latest email

2026-09-16 15:15:41 (2 hours ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

Authors

Hannu Krosing (hannukrosing)

Reviewers

Become reviewer

Committer

Links

Emails

ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...): First at 2026-08-01 13:08:48 by Hannu Krosing <hannuk at google.com>
Latest at 2026-09-16 15:15:41 by Hannu Krosing <hannuk at google.com>
Latest attachment (0001-Refactor-set-operation-group-clauses-to-decouple-fro.patch) at 2026-09-16 15:15:41 from Hannu Krosing <hannuk at google.com>
Attachment (0001-Refactor-set-operation-group-clauses-to-decouple-fro.patch) at 2026-09-16 15:15:41 from Hannu Krosing <hannuk at google.com> (Patch: No)
Attachment (xxx000-distinct-on-clause.md) at 2026-08-01 13:08:48 from Hannu Krosing <hannuk at google.com> (Patch: No)

History

When	Who	What
2026-09-16 15:39:32	CFbot	Patch needs rebase
2026-09-16 15:17:34	Hannu Krosing (hannukrosing)	Attached mail thread CAMT0RQR_QqLqKdLgh3zYk7yA7oH9RJBVF+kZJ607wjJD9WKH9Q@mail.gmail.com
2026-09-16 15:17:34	Hannu Krosing (hannukrosing)	Created patch record