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

Title

CI (CFBot)

Needs rebase! Needs rebase since 55 minutes. Failing since 55 minutes.
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 (1 hour ago)

Latest email

2026-09-16 15:15:41 (1 hour 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