Postgres Pro
Downloads
Home   >   mailing lists

Unexpected result using floor() function - Mailing list pgsql-general

From Frank Millman
Subject Unexpected result using floor() function
Date
Msg-id 2A49534B02644348A76354FC0A95A2AB@FrankLaptop
Whole thread Raw
Responses Re: Unexpected result using floor() function  (Pujol Mathieu <mathieu.pujol@realfusio.com>)
Re: Unexpected result using floor() function  (Vick Khera <vivek@khera.org>)
Re: Unexpected result using floor() function  ("Frank Millman" <frank@chagford.com>)
List pgsql-general
Tree view
Hi all
 
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
 
Frank Millman
 

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Suppress decimal point like digits in to_char?
Next
From: Pujol Mathieu
Date:
Subject: Re: Unexpected result using floor() function