>>>>> "Jeff" == Jeff Anton <antonpg...@hesiod.org> writes:
Jeff> Postgresql seems to be using the first interpretation and Jeff> reporting fewer digits. I've noticed this with pg_dump. That a Jeff> dump and restore of floating point values does not produce the Jeff> same floating point values. To me, that is inexcusable. Using Jeff> the -Fc format, real values are preserved. I have a large Jeff> database of security prices. I want accuracy above all. -Fc doesn't do anything different with floats than text dumps do. pg_dump (in all modes) uses the extra_float_digits setting to try and get a value that restores exactly. There have been issues with this in the past (the limit of extra_float_digits had to be raised from 2 to 3, iirc), but if it's happening now then that should probably be considered a bug. -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers