On 11/09/2026 03:21, Tom Lane wrote:
Isaac Morland <[email protected]> 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
