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 to round toward the closest even number. If you
are at all concerned abou that, you probably shouldn't be using
floating point, but rather numeric.