Re: [GENERAL] Unexpected result using floor() function

[Frank Millman]

> I am running PostgreSQL 9.4.4 on Fedora 22.
>
> SELECT floor(4.725 * 100 + 0.5) returns 473, which is what I expected.
> 
> SELECT floor(4.725 * power(10, 2) + 0.5) returns 472, which I find surprising.
> 
> Please can someone explain the anomaly.

Thanks for all the responses.

Plenty of workarounds. I can carry on now :-)

Frank