Postgres Pro
Downloads
Home   >   mailing lists

Re: Floating point error - Mailing list pgsql-general

From John R Pierce
Subject Re: Floating point error
Date
Msg-id 512ACA5B.6040506@hogranch.com
Whole thread Raw
In response to Floating point error  (Tom Duffey <tduffey@trillitech.com>)
Responses Re: Floating point error  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
On 2/24/2013 6:13 PM, Tom Duffey wrote:
> - The Java app on production shows "10.3884573" while the test app shows "10.3885"

'real' is single precision, which is only about 6 digits of decimal
accuracy.   if your java variables were double precision, you probably
should have used double in postgres too.

0.1 decimal is a repeating fraction in binary.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Tom Duffey
Date:
Subject: Floating point error
Next
From: John R Pierce
Date:
Subject: Re: Floating point error