More on float infinities

From: Tim Allen <tim(at)proximity(dot)com(dot)au>
To: pgsql-general(at)hub(dot)org
Subject: More on float infinities
Date: 2000-08-14 04:53:12
Message-ID: Pine.LNX.4.10.10008141446470.13762-100000@bee.proximity.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've found the problem with inserting pseudo-infinite values into database
tables, and can now insert the infinity-ish values OK. The problem was
actually that pg_dump was losing precision when it dumped out the old
values. The numbers were being rounded up at the 13th or so decimal place,
causing an overflow.

So my question is now different: why does pg_dump lose precision, and can
I somehow persuade it not to?

And, btw, it'd be nice to have some assurance that support for these
extreme case values really is supported officially, and isn't a bug that
will be "fixed" in some future version :-).

Tim

--
-----------------------------------------------
Tim Allen tim(at)proximity(dot)com(dot)au
Proximity Pty Ltd http://www.proximity.com.au/
http://www4.tpg.com.au/users/rita_tim/

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Tille 2000-08-14 07:33:22 Servlet examples
Previous Message Tim Allen 2000-08-14 04:33:55 +/- Inf for float8's