Lists: | pgsql-bugs |
---|
From: | "Stefan Hoffmann" <hoffst(at)maxinf(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4603: float4 error |
Date: | 2009-01-07 15:15:21 |
Message-ID: | 200901071515.n07FFLmD048041@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4603
Logged by: Stefan Hoffmann
Email address: hoffst(at)maxinf(dot)de
PostgreSQL version: 7.4
Operating system: ubuntu linux server
Description: float4 error
Details:
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 ?
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Stefan Hoffmann" <hoffst(at)maxinf(dot)de> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4603: float4 error |
Date: | 2009-01-07 15:24:39 |
Message-ID: | 26423.1231341879@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Stefan Hoffmann" <hoffst(at)maxinf(dot)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