Horton

Implement ANY_VALUE aggregate

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 2ddab010c2777c6a965cea82dc1b809ddc33ecc1
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2023-02-22T08:33:07Z
Releases: 16.0 
Implement ANY_VALUE aggregate

SQL:2023 defines an ANY_VALUE aggregate whose purpose is to emit an
implementation-dependent (i.e. non-deterministic) value from the
aggregated rows.

Author: Vik Fearing <vik@postgresfriends.org>
Reviewed-by: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Reviewed-by: David Rowley <dgrowleyml@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/5cff866c-10a8-d2df-32cb-e9072e6b04a2@postgresfriends.org

Files

PathChange+/−
doc/src/sgml/func.sgml modified +14 −0
src/backend/catalog/sql_features.txt modified +1 −0
src/backend/utils/adt/misc.c modified +9 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_aggregate.dat modified +4 −0
src/include/catalog/pg_proc.dat modified +8 −0
src/test/regress/expected/aggregates.out modified +30 −0
src/test/regress/sql/aggregates.sql modified +7 −0

Documentation touched

Discussion