Jochen Westland [invigo] writes:
> In my version
> select round(2.5); returns 2;
> select round(2.5000001) returns 3;
>
> refering to my math professor thats wrong, at least in germany.
> select round(2.5); should return 3
The convention that .5 values should be rounded up is just that, a
convention. On systems with IEEE 754 floating point, the default is
normally to round to the nearest even number.
--
Peter Eisentraut peter_e(at)gmx(dot)net