Re: Floating point error - Mailing list pgsql-general

From James Cloos
Subject Re: Floating point error
Date
Msg-id m34ngt75xf.fsf@carbon.jhcloos.org
Whole thread Raw
In response to Re: Floating point error  (Tom Duffey <tduffey@trillitech.com>)
List pgsql-general
>>>>> "TD" == Tom Duffey <tduffey@trillitech.com> writes:

TD> We have a script thatb uses COPY to transfer a subset of rows
TD> from a very large production table to a test table. The script
TD> was not setting extra_float_digits so the values did not match
TD> even though they appeared to match when running queries in psql.

Incidently, this is a prime example of where the hexidecimal format
for floats would benefit pg, as it makes the text format for floats
just as suitable for round-tripping as the binary format.

-JimC
--
James Cloos <cloos@jhcloos.com>         OpenPGP: 1024D/ED7DAEA6

pgsql-general by date:

Previous
From: Chris Hanks
Date:
Subject: Re: Poor performance when using a window function in a view
Next
From: JD Wong
Date:
Subject: Re: broke postgres, how to fix??