Re: round() function wrong?

Peter Eisentraut kirjutas R, 24.10.2003 kell 22:16:
> 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.

Also, which way is up ?

hannu=# select round(0.5);
round
-------
1
(1 row)

hannu=# select round(-0.5);
round
-------
-1
(1 row)

> On systems with IEEE 754 floating point, the default is
> normally to round to the nearest even number.