ON EMPTY clause for aggregate and window functions

Edit
ID 6943
Title ON EMPTY clause for aggregate and window functions
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 1, First patch: +1431−9, All patches: +1431−9
Tags SQL Commands
Created 2026-06-26 09:14:43
Last modified 2026-10-01 00:00:09 (22 hours ago)
Latest email 2026-09-28 17:53:18 (3 days ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version 20
Authors Jeevan Chalke (jeevan.chalke)
Reviewers Become reviewer
Committer Peter Eisentraut (petere)
Links
Emails
ON EMPTY clause for aggregate and window functions
First at 2026-06-26 09:11:33 by Jeevan Chalke <jeevan.chalke at enterprisedb.com>
Latest at 2026-09-28 17:53:18 by Vik Fearing <vik at postgresfriends.org>
Latest attachment (nocfbot-wip-Minimal-ON-EMPTY-sum-product-only-rewritten-to.patch) at 2026-09-24 13:17:37 from Jeevan Chalke <jeevan.chalke at enterprisedb.com>
    Attachment (nocfbot-wip-Minimal-ON-EMPTY-sum-product-only-rewritten-to.patch) at 2026-09-24 13:17:37 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (v3-0001-Add-support-for-ON-EMPTY-clause-in-aggregate-and-.patch) at 2026-09-24 13:13:03 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (v2-0001-Add-support-for-ON-EMPTY-clause-in-aggregate-and-.patch) at 2026-09-12 13:18:23 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (v1-0001-Add-support-for-ON-EMPTY-clause-in-aggregate-and-.patch) at 2026-06-26 09:11:33 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
History
When Who What
2026-10-01 00:00:09 CFbot Moved from CF PG20-2 to CF PG20-3
2026-08-28 05:40:39 Peter Eisentraut (petere) Added petere as committer
2026-08-01 05:17:24 Jeevan Chalke (jeevan.chalke) Moved from CF PG20-1 to CF PG20-2
2026-06-26 09:14:43 Jeevan Chalke (jeevan.chalke) Attached mail thread CAM2+6=VS=fSKxfimW6Th9iu_xjbxOEAKg4eYwaa=SMg3X8pHaQ@mail.gmail.com
2026-06-26 09:14:43 Jeevan Chalke (jeevan.chalke) Created patch record
Edit