Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Date: 2005-12-03 11:17:46
Message-ID: 20051203111740.GB14677@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

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(at)svana(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chidambaramchand 2005-12-03 11:40:15 GENERAL] unsubscribe
Previous Message Andreas Kretschmer 2005-12-03 07:43:38 Re: New.* and old.* as function arguments within rules

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans-Juergen Schoenig 2005-12-03 12:34:45 Re: generalizing the planner knobs
Previous Message Peter Eisentraut 2005-12-03 11:11:40 Re: [HACKERS] Should libedit be preferred to libreadline?

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-12-03 13:01:19 Re: [HACKERS] Should libedit be preferred to libreadline?
Previous Message Peter Eisentraut 2005-12-03 11:11:40 Re: [HACKERS] Should libedit be preferred to libreadline?