Horton
Menu

Re: pg_dump and psql disagree on numerical precision (powerpc)

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christof Petig <christof@petig-baender.de>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Date: 2003-11-14T16:25:07Z
Lists: pgsql-bugs 
Christof Petig <christof@petig-baender.de> writes:
> Commenting out "set extra_float_digits=2" in pg_dump.c gives me the old 
> behaviour. Is it only me wishing for a command line parameter for 
> pg_dump to set desired precision?

It seems to me that you should be using type NUMERIC if you think there
is a difference between 0.3 and 0.29999999999999999.

			regards, tom lane