Commiteca08f5

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 parent81d46ea commiteca08f5Copy full SHA for eca08f5

File tree

-3

lines changed

-3

lines changed

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -8412,11 +8412,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`8412`	`8412`	`<returnvalue>interval</returnvalue>`
`8413`	`8413`	`</para>`
`8414`	`8414`	`<para>`
`8415`		`- Subtract timestamps`
	`8415`	`+ Subtract timestamps (converting 24-hour intervals into days,`
	`8416`	`+ similarly to <function>justify_hours()</function>)`
`8416`	`8417`	`</para>`
`8417`	`8418`	`<para>`
`8418`		`- <literal>timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'</literal>`
`8419`		`- <returnvalue>1 day 15:00:00</returnvalue>`
	`8419`	`+ <literal>timestamp '2001-09-29 03:00' - timestamp '2001-07-27 12:00'</literal>`
	`8420`	`+ <returnvalue>63 days 15:00:00</returnvalue>`
`8420`	`8421`	`</para></entry>`
`8421`	`8422`	`</row>`
`8422`	`8423`

Comments

(0)