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:
float.patch
Description: float.patch
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
