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