On 28/09/2026 19:36, Robert Haas wrote:
On Thu, Sep 24, 2026 at 9:18 AM Jeevan Chalke
<[email protected]> wrote:
It only accepts ON EMPTYon sum()and product(), the two aggregates the
standard actually defines this for. At parse time, once we know the
call is sum() or product(), it is just rewritten to
COALESCE(sum(expr), default). Nothing else changes:
I can't get excited about supporting this syntax for just 2 aggregates
and nothing else.
Certainly not. Either we make it generic like we always do, or we drop
it entirely.
--
Vik Fearing
