diff options
| author | Tom Lane | 2020-06-26 17:54:01 +0000 |
|---|---|---|
| committer | Tom Lane | 2020-06-26 17:54:01 +0000 |
| commit | 098868b57687ef9c5e3cd9dff469594c6a1c6d10 (patch) | |
| tree | 2315282566e65172cda783c8208f6d7b98a17f4b | |
| parent | 08671057e025b48136d4eed5477f287ffce217b0 (diff) | |
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 aa235f139e3..de1e8fed3ac 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -8395,11 +8395,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> |