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

From Tom Lane
Subject Re: ON EMPTY clause for aggregate and window functions
Date
Msg-id 645015.1789660502@sss.pgh.pa.us
Whole thread
In response to Re: ON EMPTY clause for aggregate and window functions  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: ON EMPTY clause for aggregate and window functions
List pgsql-hackers
Vik Fearing <vik@postgresfriends.org> writes:
> On 17/09/2026 15:31, Tom Lane wrote:
>> I'd be totally fine with rejecting this as a frammish we do
>> not care to support.

> I am not the most unbiased person, but I would like us to implement it.
> If for nothing else, then for helping people convert from database 
> implementations that do have it.

It's not zero cost.  Robert already mentioned the
development/maintenance effort involved, and it also bloats the Bison
grammar rules, creating some incremental penalty on parsing speed.
Admittedly these costs aren't large, but neither is the benefit
of supporting it.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: issues with eager aggregation
Next
From: Palak Chaturvedi
Date:
Subject: Re: Changing shared_buffers without restart