Re: Unexpected result using floor() function

From: "Frank Millman" <frank(at)chagford(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unexpected result using floor() function
Date: 2016-03-14 18:03:35
Message-ID: 1083091068AD4C5FA89166F0470FDD70@FrankLaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-03-14 18:31:20 Re: Suppress decimal point like digits in to_char?
Previous Message Elein 2016-03-14 18:00:27 Re: enum bug