Re: Rounding of floating point in text dumps? - Mailing list pgsql-general

From Tom Lane
Subject Re: Rounding of floating point in text dumps?
Date
Msg-id 338.1222469746@sss.pgh.pa.us
Whole thread Raw
In response to Rounding of floating point in text dumps?  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
Chris Browne <cbbrowne@acm.org> writes:
> In the interests of personal laziness ;-), I'll throw the question to
> this list: how may we expect the imprecisions of FP affect text-based
> database dumps, if at all?

If the platform's float I/O routines conform fully to spec, you can
expect FP values to reload exactly.  We dump them with a couple of
"extra" digits of precision to make this possible.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Rounding of floating point in text dumps?
Next
From: Ralph Smith
Date:
Subject: Re: Using a User-Def function in a query