Horton

Add min() and max() aggregates for pg_lsn

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 313f87a17155a6dbd27a3ce687cf59bd171fe75e
Author: Michael Paquier <michael@paquier.xyz>
Date: 2019-07-05T03:21:11Z
Releases: 13.0 
Add min() and max() aggregates for pg_lsn

This is useful for monitoring, when it comes for example to calculations
of WAL retention with replication slots and delays with a set of
standbys.

Bump catalog version.

Author: Fabrízio de Royes Mello
Reviewed-by: Surafel Temesgen
Discussion: https://postgr.es/m/CAFcNs+oc8ZoHhowA4rR1GGCgG8QNgK_TOwPRVYQo5rYy8_PXzA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +2 −2
src/backend/utils/adt/pg_lsn.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 +12 −0
src/test/regress/expected/pg_lsn.out modified +7 −0
src/test/regress/sql/pg_lsn.sql modified +4 −0

Documentation touched

Discussion