From eca08f58d05f45c4cae02bca5e1556ba58732fc4 Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Fri, 26 Jun 2020 13:54:01 -0400
Subject: 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
---
doc/src/sgml/func.sgml | 7 ++++---
1 file 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}');
interval
- Subtract timestamps
+ Subtract timestamps (converting 24-hour intervals into days,
+ similarly to justify_hours())
- timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'
- 1 day 15:00:00
+ timestamp '2001-09-29 03:00' - timestamp '2001-07-27 12:00'
+ 63 days 15:00:00
--
cgit v1.2.3