Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Date
Msg-id 20051203111740.GB14677@svana.org
Whole thread Raw
In response to Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
List pgsql-general
On Fri, Dec 02, 2005 at 07:37:49PM -0500, Tom Lane wrote:
> So the product I fancifully mentioned would weigh in somewhere around
> 10^300, and thus be *well* within the capability of even the proposed
> restricted numeric format.

I think numbers much bigger than that are only useful for theoretical
mathemeticians. I also think that most of the people dealing with such
numbers probably refer to the formula used to create them since
manipulating that is likely to be faster than reading all the digits of
such a large numbers.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: New.* and old.* as function arguments within rules
Next
From: chidambaramchand@aim.com
Date:
Subject: GENERAL] unsubscribe