Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and psql disagree on numerical precision (powerpc) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_dump and psql disagree on numerical precision (powerpc)
Date
Msg-id 22424.1068827107@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and psql disagree on numerical precision (powerpc)  (Christof Petig <christof@petig-baender.de>)
Responses Re: pg_dump and psql disagree on numerical precision (powerpc)  (Christof Petig <christof@petig-baender.de>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Christof Petig
Date:
Subject: Re: pg_dump and psql disagree on numerical precision (powerpc)
Next
From: Christof Petig
Date:
Subject: Re: pg_dump and psql disagree on numerical precision (powerpc)