From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: The age() of a column? |
Date: | 2018-11-29 04:05:44 |
Message-ID: | 406.1543464344@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ron <ronljohnsonjr(at)gmail(dot)com> writes:
> What does it mean, and where is it documented?
age(xid) returns the difference between the given xid and the current xid.
It's not terribly well documented, but psql's \df gives some info:
regression=# \df+ age
Schema | Name | Result data type | Argument data types | Type | Volatility | Parallel | Owner | Security | Access privileges | Language | Source code | Description
...
pg_catalog | age | integer | xid | func | stable | restricted | postgres | invoker | | internal | xid_age | age of a transaction ID, in transactions before current transaction
The only reference I could find in the SGML docs is in the maintenance
chapter.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Where is Where | 2018-11-29 04:11:33 | Re: tsvector 256 limit and matching text with common words |
Previous Message | Ron | 2018-11-29 03:32:48 | The age() of a column? |