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

From Michael Fuhr
Subject Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508
Date
Msg-id 20051206055112.GA62151@winnie.fuhr.org
Whole thread Raw
In response to Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, Dec 05, 2005 at 11:59:10PM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > It looks like the limit would be about factorial(256).
> > 
> > The question remains, though, is this computational range good for
> > anything except demos?
> 
> I can say that the extended range is good for finding *printf problems.  ;-)

Might anybody be calculating permutations or combinations with the
textbook functions that use factorials?  Not a show-stopper since
those calculations can be optimized (at least the basic formulas I
know), but somebody might get bit by the change.  Maybe the release
notes could mention the new upper limit of factorial().

-- 
Michael Fuhr


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Replication on the backend
Next
From: Tom Lane
Date:
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508