projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7e5ddf7) | patch
Implement ANY_VALUE aggregate
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 22 Feb 2023 08:32:12 +0000 (09:32 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 22 Feb 2023 08:33:07 +0000 (09:33 +0100)
commit2ddab010c2777c6a965cea82dc1b809ddc33ecc1
treea880541c896359d98ce2aac07f6a0d54e7ecb4d2tree
parent7e5ddf7e4d1ee36233371661c5e96007c8d7c665commit | diff
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
doc/src/sgml/func.sgml diff | blob | blame | history
src/backend/catalog/sql_features.txt diff | blob | blame | history
src/backend/utils/adt/misc.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_aggregate.dat diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/test/regress/expected/aggregates.out diff | blob | blame | history
src/test/regress/sql/aggregates.sql diff | blob | blame | history
Robert Haas's development tree.