Re: Unexpected result using floor() function

Pujol Mathieu <mathieu.pujol@xxxxxxxxxxxxx> · Mon, 14 Mar 2016 15:21:12 +0100



    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.pujol@xxxxxxxxxxxxx - http://www.realfusio.com