On 10/09/2026 17:11, Jeevan Chalke wrote:
Hello Vik,
On Thu, Sep 10, 2026 at 8:22 PM Vik Fearing <[email protected]>
wrote:
and it should accept the syntax
PRODUCT(col, 1 ON EMPTY)
for when there are no non-nulls in the input.
This will be required by the next edition of the SQL standard. The
exact
value "1" is required by the standard, but I think we should allow
any
a_expr there.
Regarding the |ON EMPTY| clause, I have actually already proposed a
patch for that here:
https://www.postgresql.org/message-id/CAM2+6=VS=fSKxfimW6Th9iu_xjbxOEAKg4eYwaa=smg3x8p...@mail.gmail.com
<https://www.postgresql.org/message-id/CAM2+6=VS=fSKxfimW6Th9iu_xjbxOEAKg4eYwaa=smg3x8p...@mail.gmail.com>
It is designed to be applicable to any aggregate function. Note that
in its current form, the patch accepts any arbitrary expression
(constant) for the return value, rather than restricting it to a
hard-coded literal.
I would really appreciate it if you could take a look at those changes
and share your reviews, feedback, or suggestions on that thread.
I will definitely take a look at it.
I can't keep up with this mailing list, so thank you for the pointer.
--
Vik Fearing
