On Sat, 2022-12-03 at 08:54 +0000, PG Doc comments form wrote:
> Explanation of the manual's ROUND function
> round ( numeric ) → numeric
> round ( double precision ) → double precision
> Rounds to nearest integer. For numeric, ties are broken by rounding away
> from zero. For double precision, the tie-breaking behavior is platform
> dependent, but “round to nearest even” is the most common rule.
> round(42.4) → 42
>
> Operation of the ROUND function
> postgres=# SELECT round(CAST(42.5 AS numeric));
> round
> -------
> 43
> (1 row)
>
> I am thinking that the value of the ROUND function with NUMERIC as an
> argument is rounded off, not rounded away from zero.
It is rounded away from zero, since 43 is farther away from 0 than 42.5.
This may be a language problem.
Yours,
Laurenz Albe
