Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> On Mon, 2010-08-30 at 19:40 -0400, Tom Lane wrote:
>> That's really *not* supposed to happen, assuming that both machines have
>> IEEE float arithmetic and competently written float I/O code.
> On my machine I see:
> => select float4in(float4out((1::numeric + 1e-7::numeric)::float4)) =
> (1::numeric + 1e-7::numeric)::float4;
You need extra_float_digits cranked up. Which pg_dump knows about.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2010-08-31 00:21:23|
|Subject: Re: Exclude constraint problem |
|Previous:||From: Jeff Davis||Date: 2010-08-31 00:00:53|
|Subject: Re: Exclude constraint problem|