Skip site navigation (1) Skip section navigation (2)

Re: Exclude constraint problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Alex Zepeda <zipzippy(at)sonic(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Exclude constraint problem
Date: 2010-08-31 00:06:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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 LaneDate: 2010-08-31 00:21:23
Subject: Re: Exclude constraint problem
Previous:From: Jeff DavisDate: 2010-08-31 00:00:53
Subject: Re: Exclude constraint problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group