Re: Floating point error - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Floating point error
Date
Msg-id A737B7A37273E048B164557ADEF4A58B057B9B71@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: Floating point error  (Tom Duffey <tduffey@trillitech.com>)
Responses Re: [HACKERS] Floating point error  (Maciek Sakrejda <m.sakrejda@gmail.com>)
List pgsql-general
Tom Duffey wrote (on -general):
> To bring closure to this thread, my whole problem was caused by not knowing about the
> extra_float_digits setting. We have a script that uses COPY to transfer a subset of rows from a very
> large production table to a test table. The script was not setting extra_float_digits so the values
> did not match even though they appeared to match when running queries in psql. Definitely another
> gotcha for floating point values and it might be a good idea to mention this setting on the "Numeric
> Types" page of the docs.

True; how about this patch.

Yours,
Laurenz Albe

Attachment

pgsql-general by date:

Previous
From: Chris Hanks
Date:
Subject: Re: Poor performance when using a window function in a view
Next
From: Marc Mamin
Date:
Subject: query syntax to combine 2 set returning functions ?