Re: BUG #1577: round(dp) function does not round to nearest integer properly

"Roman Schayuk" <rschayuk@rogers.com> writes:
> gap=> select round(42.5);
>  round
> -------
>     42
> (1 row)
> Result has to be 43

No, the above is perfectly correct and in fact required by the IEEE
standard for floating-point arithmetic (because round-to-nearest-even
is the default rounding mode).

If anything needs to be changed here, it's the behavior of round(numeric).

            regards, tom lane