Re: ON EMPTY clause for aggregate and window functions - Mailing list pgsql-hackers

On Thu, Sep 24, 2026 at 9:18 AM Jeevan Chalke <jeevan.chalke@enterprisedb.com> wrote:

It only accepts ON EMPTY on 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