"Roman Schayuk" <rschayuk(at)rogers(dot)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