Implement ANY_VALUE aggregate
authorPeter Eisentraut
Wed, 22 Feb 2023 08:32:12 +0000 (09:32 +0100)
committerPeter Eisentraut
Wed, 22 Feb 2023 08:33:07 +0000 (09:33 +0100)
commit2ddab010c2777c6a965cea82dc1b809ddc33ecc1
treea880541c896359d98ce2aac07f6a0d54e7ecb4d2
parent7e5ddf7e4d1ee36233371661c5e96007c8d7c665
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 
Reviewed-by: Peter Eisentraut
Reviewed-by: David Rowley
Discussion: https://www.postgresql.org/message-id/flat/5cff866c-10a8-d2df-32cb-e9072e6b04a2@postgresfriends.org
doc/src/sgml/func.sgml
src/backend/catalog/sql_features.txt
src/backend/utils/adt/misc.c
src/include/catalog/catversion.h
src/include/catalog/pg_aggregate.dat
src/include/catalog/pg_proc.dat
src/test/regress/expected/aggregates.out
src/test/regress/sql/aggregates.sql