| From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com> |
| Cc: | Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Add PRODUCT() aggregate function |
| Date: | 2026-09-11 12:21:15 |
| Message-ID: | 9000e672-c973-4d35-91ce-22d1c90c3d0a@postgresfriends.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 11/09/2026 03:21, Tom Lane wrote:
> Isaac Morland <isaac(dot)morland(at)gmail(dot)com> writes:
>> Out of curiosity, was there any thought given to the idea that it should be
>> an attribute of the aggregate itself?
> SUM over no rows has been defined to return NULL for decades. They
> can't just up and change that. They could have instead defined a
> new aggregate (SUM0, maybe) but chose not to.
I was arguing for SUM(expr, 0) but it wasn't deemed to be sufficiently
"English."
--
Vik Fearing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vik Fearing | 2026-09-11 12:22:58 | Re: Add PRODUCT() aggregate function |
| Previous Message | Vik Fearing | 2026-09-11 12:17:12 | Re: Add PRODUCT() aggregate function |