Commit00037d8

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 parenta71cfc5 commit00037d8Copy full SHA for 00037d8

File tree

-2

lines changed

-2

lines changed

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1617,7 +1617,10 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>`
`1617`	`1617`	`<returnvalue>double precision</returnvalue>`
`1618`	`1618`	`</para>`
`1619`	`1619`	`<para>`
`1620`		`- Rounds to nearest integer`
	`1620`	`+ Rounds to nearest integer. For <type>numeric</type>, ties are`
	`1621`	`+ broken by rounding away from zero. For <type>double precision</type>,`
	`1622`	`+ the tie-breaking behavior is platform dependent, but`
	`1623`	`+ <quote>round to nearest even</quote> is the most common rule.`
`1621`	`1624`	`</para>`
`1622`	`1625`	`<para>`
`1623`	`1626`	`<literal>round(42.4)</literal>`
`@@ -1632,7 +1635,7 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>`
`1632`	`1635`	`</para>`
`1633`	`1636`	`<para>`
`1634`	`1637`	`Rounds <parameter>v</parameter> to <parameter>s</parameter> decimal`
`1635`		`- places`
	`1638`	`+ places. Ties are broken by rounding away from zero.`
`1636`	`1639`	`</para>`
`1637`	`1640`	`<para>`
`1638`	`1641`	`<literal>round(42.4382, 2)</literal>`

Comments

(0)