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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
