> On May 15, 2023, at 08:41, Fabrice Chapuis <fabrice636861(at)gmail(dot)com> wrote:
> What is the xid type and how can I cast integer value to make pg_xact_commit_timestamp to work?
The xid type is... xid. You'll need to cast as a string instead of an integer:
xof=# select pg_xact_commit_timestamp('53013547'::xid);
pg_xact_commit_timestamp
-------------------------------
2023-03-31 09:12:07.673883-07
(1 row)