Re: [BUGS] round(50.5) = 50

2004-03-05 Thread Philipp Matthias Hahn
Peter Eisentraut wrote: Philipp Matthias Hahn wrote: # SELECT round(5.5::float4),round(50.5::float4); round | round ---+--- 6 |50 (1 row) I think this is a bug, since I would expect 6 and 51. The default rounding mode for floating point (determined by your C library, mostly) it

[BUGS] round(50.5) = 50

2004-02-28 Thread Philipp Matthias Hahn
Hello! # SELECT round(5.5::float4),round(50.5::float4); round | round ---+--- 6 |50 (1 row) I think this is a bug, since I would expect 6 and 51. Doing the same without the float4-cast, it works correct. This bug bites me while passing parameters to a plpgsql function. This ha