diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2021-04-22 14:47:26 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2021-04-22 14:47:26 -0400 |
| commit | 00037d8d004031d80d276da543262004ed6bff48 (patch) | |
| tree | 4d69c35f21875c57818f50150d40e58acdd4aa3b /doc/src | |
| parent | a71cfc56bf6013e3ea1d673acaf73fe7ebbd6bf3 (diff) | |
Doc: document the tie-breaking behavior of the round() function.
Back-patch to v13; the table layout in older branches is unfriendly
to adding such details.
Laurenz Albe
Discussion: https://postgr.es/m/161881920775.685.12293798764864559341@wrigleys.postgresql.org
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index e3f833d231f..60ac5ef6585 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1617,7 +1617,10 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue> <returnvalue>double precision</returnvalue> </para> <para> - Rounds to nearest integer + Rounds to nearest integer. For <type>numeric</type>, ties are + broken by rounding away from zero. For <type>double precision</type>, + the tie-breaking behavior is platform dependent, but + <quote>round to nearest even</quote> is the most common rule. </para> <para> <literal>round(42.4)</literal> @@ -1632,7 +1635,7 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue> </para> <para> Rounds <parameter>v</parameter> to <parameter>s</parameter> decimal - places + places. Ties are broken by rounding away from zero. </para> <para> <literal>round(42.4382, 2)</literal> |