diff options
author | Fujii Masao <fujii@postgresql.org> | 2020-06-30 23:55:07 +0900 |
---|---|---|
committer | Fujii Masao <fujii@postgresql.org> | 2020-06-30 23:55:07 +0900 |
commit | 9bae7e4cde7c9786ee61dac4a3e032b346350a88 (patch) | |
tree | 11fc6cfc0c7589b2857a68080ebcf0cd54f064b1 /doc/src | |
parent | 324435eb14e4f41cd430f96c9b13ad9b160e45e4 (diff) | |
download | postgresql-9bae7e4cde7c9786ee61dac4a3e032b346350a88.tar.gz postgresql-9bae7e4cde7c9786ee61dac4a3e032b346350a88.zip |
Add +(pg_lsn,numeric) and -(pg_lsn,numeric) operators.
By using these operators, the number of bytes can be added into and
subtracted from LSN.
Bump catalog version.
Author: Fujii Masao
Reviewed-by: Kyotaro Horiguchi, Michael Paquier, Asif Rehman
Discussion: https://postgr.es/m/ed9f7f74-e996-67f8-554a-52ebd3779b3b@oss.nttdata.com
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/datatype.sgml | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 49fb19ff919..7027758d28d 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -4801,7 +4801,13 @@ SELECT * FROM pg_attribute standard comparison operators, like <literal>=</literal> and <literal>></literal>. Two LSNs can be subtracted using the <literal>-</literal> operator; the result is the number of bytes separating - those write-ahead log locations. + those write-ahead log locations. Also the number of bytes can be + added into and subtracted from LSN using the + <literal>+(pg_lsn,numeric)</literal> and + <literal>-(pg_lsn,numeric)</literal> operators, respectively. Note that + the calculated LSN should be in the range of <type>pg_lsn</type> type, + i.e., between <literal>0/0</literal> and + <literal>FFFFFFFF/FFFFFFFF</literal>. </para> </sect1> |