Re: ON EMPTY clause for aggregate and window functions

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
Subject: Re: ON EMPTY clause for aggregate and window functions
Date: 2026-09-17 15:47:17
Message-ID: e9454ec0-6b35-49d6-aac3-7c5f1deeb309@postgresfriends.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 17/09/2026 15:31, Tom Lane wrote:
> Yes, this choice of syntax sucks pretty badly.

I agree. The next edition isn't out yet, if we would like to suggest
something better.

> 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.

--

Vik Fearing

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2026-09-17 15:55:01 Re: issues with eager aggregation
Previous Message Tom Lane 2026-09-17 15:41:07 Re: ERROR: too late to create a new PlaceHolderInfo