Re: ANY_VALUE aggregate

Vik Fearing <vik@postgresfriends.org>

From: Vik Fearing <vik@postgresfriends.org>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2022-12-05T20:18:57Z

Lists: pgsql-hackers

Attachments

0001-Implement-ANY_VALUE-aggregate.v02.patch (text/x-patch) patch v2-0001

On 12/5/22 15:57, Vik Fearing wrote:
> The SQL:2023 Standard defines a new aggregate named ANY_VALUE.  It 
> returns an implementation-dependent (i.e. non-deterministic) value from 
> the rows in its group.
> 
> PFA an implementation of this aggregate.

Here is v2 of this patch.  I had forgotten to update sql_features.txt.
-- 
Vik Fearing

Commits

Implement ANY_VALUE aggregate
- 2ddab010c277 16.0 landed
Generalize ri_RootToPartitionMap to use for non-partition children
- fb958b5da86d 16.0 cited