Commit82b13db

committed

Doc: document the tie-breaking behavior of the round() function.

Back-patch to v13; the table layout in older branches is unfriendlyto adding such details.Laurenz AlbeDiscussion:https://postgr.es/m/161881920775.685.12293798764864559341@wrigleys.postgresql.org

1 parent4c4eaf3 commit82b13dbCopy full SHA for 82b13db

File tree

-2

lines changed

-2

lines changed

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1568,7 +1568,10 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>`
`1568`	`1568`	`<returnvalue>double precision</returnvalue>`
`1569`	`1569`	`</para>`
`1570`	`1570`	`<para>`
`1571`		`- Rounds to nearest integer`
	`1571`	`+ Rounds to nearest integer. For <type>numeric</type>, ties are`
	`1572`	`+ broken by rounding away from zero. For <type>double precision</type>,`
	`1573`	`+ the tie-breaking behavior is platform dependent, but`
	`1574`	`+ <quote>round to nearest even</quote> is the most common rule.`
`1572`	`1575`	`</para>`
`1573`	`1576`	`<para>`
`1574`	`1577`	`<literal>round(42.4)</literal>`
`@@ -1583,7 +1586,7 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>`
`1583`	`1586`	`</para>`
`1584`	`1587`	`<para>`
`1585`	`1588`	`Rounds <parameter>v</parameter> to <parameter>s</parameter> decimal`
`1586`		`- places`
	`1589`	`+ places. Ties are broken by rounding away from zero.`
`1587`	`1590`	`</para>`
`1588`	`1591`	`<para>`
`1589`	`1592`	`<literal>round(42.4382, 2)</literal>`

Comments

(0)