Commit098868b

committed

Doc: explain that "timestamp - timestamp" applies justify_hours().

Back-patch to v13; before that, there's not really space for thiskind of detail.Discussion:https://postgr.es/m/c1696f68-fa8d-7759-6a9c-eb293ab1bbc9@gmx.net

1 parent0867105 commit098868bCopy full SHA for 098868b

File tree

-3

lines changed

-3

lines changed

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -8395,11 +8395,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`8395`	`8395`	`<returnvalue>interval</returnvalue>`
`8396`	`8396`	`</para>`
`8397`	`8397`	`<para>`
`8398`		`- Subtract timestamps`
	`8398`	`+ Subtract timestamps (converting 24-hour intervals into days,`
	`8399`	`+ similarly to <function>justify_hours()</function>)`
`8399`	`8400`	`</para>`
`8400`	`8401`	`<para>`
`8401`		`- <literal>timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'</literal>`
`8402`		`- <returnvalue>1 day 15:00:00</returnvalue>`
	`8402`	`+ <literal>timestamp '2001-09-29 03:00' - timestamp '2001-07-27 12:00'</literal>`
	`8403`	`+ <returnvalue>63 days 15:00:00</returnvalue>`
`8403`	`8404`	`</para></entry>`
`8404`	`8405`	`</row>`
`8405`	`8406`

Comments

(0)