Postgres Pro
Downloads
Home   >   mailing lists

Introduce MIN/MAX aggregate functions to pg_lsn - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Introduce MIN/MAX aggregate functions to pg_lsn
Date
Msg-id CAFcNs+oc8ZoHhowA4rR1GGCgG8QNgK_TOwPRVYQo5rYy8_PXzA@mail.gmail.com
Whole thread Raw
Responses Re: Introduce MIN/MAX aggregate functions to pg_lsn
Re: Introduce MIN/MAX aggregate functions to pg_lsn
List pgsql-hackers
Tree view
Hi all,

Before we introduce pg_lsn datatype the LSN was expressed as a TEXT type, so a simple query using MIN/MAX functions works as expected. Query like:

SELECT min(restart_lsn) FROM pg_replication_slots;
SELECT min(sent_lsn) FROM pg_stat_replication ;

So attached patch aims to introduce MIN/MAX aggregate functions to pg_lsn datatype.

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: propagating replica identity to partitions
Next
From: Robbie Harwood
Date:
Subject: Re: [PATCH v20] GSSAPI encryption support