diff options
| -rw-r--r-- | doc/src/sgml/func.sgml | 58 |
1 files changed, 30 insertions, 28 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 2cd93163b75..13e1642192a 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -27012,6 +27012,34 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id')); <row> <entry role="func_table_entry"><para role="func_signature"> <indexterm> + <primary>age</primary> + </indexterm> + <function>age</function> ( <type>xid</type> ) + <returnvalue>integer</returnvalue> + </para> + <para> + Returns the number of transactions between the supplied + transaction id and the current transaction counter. + </para></entry> + </row> + + <row> + <entry role="func_table_entry"><para role="func_signature"> + <indexterm> + <primary>mxid_age</primary> + </indexterm> + <function>mxid_age</function> ( <type>xid</type> ) + <returnvalue>integer</returnvalue> + </para> + <para> + Returns the number of multixacts IDs between the supplied + multixact ID and the current multixacts counter. + </para></entry> + </row> + + <row> + <entry role="func_table_entry"><para role="func_signature"> + <indexterm> <primary>pg_current_xact_id</primary> </indexterm> <function>pg_current_xact_id</function> () @@ -27153,7 +27181,8 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id')); <para> The internal transaction ID type <type>xid</type> is 32 bits wide and wraps around every 4 billion transactions. However, - the functions shown in <xref linkend="functions-pg-snapshot"/> use a + the functions shown in <xref linkend="functions-pg-snapshot"/>, except + <function>age</function> and <function>mxid_age</function>, use a 64-bit type <type>xid8</type> that does not wrap around during the life of an installation and can be converted to <type>xid</type> by casting if required; see <xref linkend="transaction-id"/> for details. @@ -27235,33 +27264,6 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id')); </thead> <tbody> - <row> - <entry role="func_table_entry"><para role="func_signature"> - <indexterm> - <primary>age</primary> - </indexterm> - <function>age</function> ( <type>xid</type> ) - <returnvalue>integer</returnvalue> - </para> - <para> - Returns the number of transactions between the supplied - transaction id and the current transaction counter. - </para></entry> - </row> - - <row> - <entry role="func_table_entry"><para role="func_signature"> - <indexterm> - <primary>mxid_age</primary> - </indexterm> - <function>mxid_age</function> ( <type>xid</type> ) - <returnvalue>integer</returnvalue> - </para> - <para> - Returns the number of multixacts IDs between the supplied - multixact ID and the current multixacts counter. - </para></entry> - </row> <row> <entry role="func_table_entry"><para role="func_signature"> |