Re: BUG #4603: float4 error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4603: float4 error
Date
Msg-id 26423.1231341879@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4603: float4 error  ("Stefan Hoffmann" <hoffst@maxinf.de>)
List pgsql-bugs
"Stefan Hoffmann" <hoffst@maxinf.de> writes:
> some specific values such as 20048223 or -25771373 can't be stored in float4
> . they are replaced by 20048224 and
> -25771372 when inserted or updated in float4 .
> is this a problem of 7.4 or caused by "inexact" float4 ?

The latter.  On most machines float4 is only good for about six
significant digits, and you're expecting eight ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Stefan Hoffmann"
Date:
Subject: BUG #4603: float4 error
Next
From: "Brans van der Heijden"
Date:
Subject: BUG #4604: Instalation error: Failed to run initdb: 255!