Skip site navigation (1) Skip section navigation (2)

Re: Numeric 508 datatype

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Numeric 508 datatype
Date: 2005-12-02 18:42:40
Message-ID: 200512021842.jB2Igeh00374@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > I am confused by your use of the term "dynamic" range.  From what you
> > say above that we are just moving from 1000 to 508 for storage, and that
> > computational range would still be 4096?
> 
> No, computational range would still be on the order of 10^16G ... in the
> computational format, the weight is an int.  The restriction to 1000
> digits was never anything but an artificial limit.  (Of course, you
> might not have the patience to actually do any arithmetic with that many
> digits, but the point is there was a whole lot of headroom before, and
> now there won't be.)

Sorry, I am confused.  If our computational range is that high, why does
SELECT factorial(4000) and SELECT factorial(6000) produce the same
number of digits on my screen.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-12-02 18:47:18
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?
Previous:From: Bruce MomjianDate: 2005-12-02 18:39:00
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?

pgsql-patches by date

Next:From: Tom LaneDate: 2005-12-02 18:47:18
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?
Previous:From: Bruce MomjianDate: 2005-12-02 18:39:00
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?

pgsql-general by date

Next:From: Tom LaneDate: 2005-12-02 18:54:33
Subject: Re: Numeric 508 datatype
Previous:From: Richard HuxtonDate: 2005-12-02 18:36:37
Subject: Re: createuser ignores stdin in 8.1.0?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group