Re: Unexpected result using floor() function

From: Pujol Mathieu <mathieu(dot)pujol(at)realfusio(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unexpected result using floor() function
Date: 2016-03-14 14:21:12
Message-ID: 56E6C8D8.1040604@realfusio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
I reproduce your bug using "PostgreSQL 9.3.6, compiled by Visual C++
build 1600, 64-bit" on Windows 8
I also notice that SELECT floor(4.725 * power(10, 2)::numeric + 0.5)
work as expected

Mathieu

Le 14/03/2016 15:11, Frank Millman a écrit :
> 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

--
Mathieu PUJOL
Ingénieur Réalité Virtuelle
Tel : 05.81.33.13.36
REAL FUSIO - 3D Computer Graphics
9, rue Paul Mesple - 31100 TOULOUSE - FRANCE
mathieu(dot)pujol(at)realfusio(dot)com - http://www.realfusio.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2016-03-14 14:28:03 Re: Unexpected result using floor() function
Previous Message Frank Millman 2016-03-14 14:11:01 Unexpected result using floor() function