>>>>> "TD" == Tom Duffey <tduffey@xxxxxxxxxxxxxx> 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@xxxxxxxxxxx> OpenPGP: 1024D/ED7DAEA6 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general