FP precision

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: FP precision
Date: 2013-06-19 20:22:32
Message-ID: 1371673352.89471.YahooMailNeo@web162902.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

test=# select '1000000'::real + '5'::real;
 ?column?
----------
    1e+06
(1 row)

test=# select '1000000'::real + '6'::real;
  ?column?  
-------------
 1.00001e+06
(1 row)

test=# select '0.1'::real + 0.0;
     ?column?     
-------------------
 0.100000001490116
(1 row)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2013-06-19 20:27:39 Re: Change authentication error message (patch)
Previous Message Andrew Dunstan 2013-06-19 20:22:22 Re: [PATCH] Remove useless USE_PGXS support in contrib