diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2020-06-26 13:54:01 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2020-06-26 13:54:01 -0400 |
| commit | eca08f58d05f45c4cae02bca5e1556ba58732fc4 (patch) | |
| tree | 091819fc0c583a1b3b7b97de6c17f70ca7b6219a | |
| parent | 81d46ea12cef2391a4cae63c1f3951401e3dd883 (diff) | |
| download | postgresql-eca08f58d05f45c4cae02bca5e1556ba58732fc4.tar.gz postgresql-eca08f58d05f45c4cae02bca5e1556ba58732fc4.zip | |
Doc: explain that "timestamp - timestamp" applies justify_hours().
Back-patch to v13; before that, there's not really space for this
kind of detail.
Discussion: https://postgr.es/m/c1696f68-fa8d-7759-6a9c-eb293ab1bbc9@gmx.net
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index b7c450ea29d..7119f0b2ca5 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -8412,11 +8412,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); <returnvalue>interval</returnvalue> </para> <para> - Subtract timestamps + Subtract timestamps (converting 24-hour intervals into days, + similarly to <function>justify_hours()</function>) </para> <para> - <literal>timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'</literal> - <returnvalue>1 day 15:00:00</returnvalue> + <literal>timestamp '2001-09-29 03:00' - timestamp '2001-07-27 12:00'</literal> + <returnvalue>63 days 15:00:00</returnvalue> </para></entry> </row> |