Add min and max aggregates for composite types (records).
Tom Lane <tgl@sss.pgh.pa.us>
Add min and max aggregates for composite types (records). Like min/max for arrays, these are just thin wrappers around the existing btree comparison function for records. Aleksander Alekseev Discussion: https://postgr.es/m/CAO=iB8L4WYSNxCJ8GURRjQsrXEQ2-zn3FiCsh2LMqvWq2WcONg@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +2 −2 |
| src/backend/utils/adt/rowtypes.c | modified | +18 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_aggregate.dat | modified | +6 −0 |
| src/include/catalog/pg_proc.dat | modified | +13 −1 |
| src/test/regress/expected/aggregates.out | modified | +25 −0 |
| src/test/regress/sql/aggregates.sql | modified | +6 −0 |
Documentation touched
Discussion
- MIN/MAX functions for a record 12 messages · 2024-03-22 → 2024-07-11