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

2005-12-05 Thread Gregory Maxwell
On 12/5/05, Tom Lane <[EMAIL PROTECTED]> wrote: > > Not only does 4000! not work, but 400! doesn't even work. I just lost > > demo "wow" factor points! > > It looks like the limit would be about factorial(256). > > The question remains, though, is this computational range good for > anything excep

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

2005-12-05 Thread Tom Lane
Bruce Momjian writes: > The limit seems to be around 150k digits: It's exactly 10^(128K), as I've mentioned more than once. > So, with the patch, the storage length is going from 1000 digits to 508, > but the computational length is reduced from around 150k digits to 508. > Now, because no one

[HACKERS] Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

2005-12-05 Thread Bruce Momjian
[ Moved to hackers for patch discussion.] John D. Burger wrote: > >> There are practical applications, eg, 1024-bit keys are fairly common > >> objects in cryptography these days, and that equates to about 10^308. > >> I don't really foresee anyone trying to run crypto algorithms with SQL > >> NU