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

Re: Numeric 508 datatype

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(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:21:05
Message-ID: 4187.1133547665@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
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.)

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-12-02 18:23:35
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?
Previous:From: Bruce MomjianDate: 2005-12-02 18:03:26
Subject: Re: Numeric 508 datatype

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-12-02 18:23:35
Subject: Re: [HACKERS] Should libedit be preferred to libreadline?
Previous:From: Julio C├ęsar ElizondoDate: 2005-12-02 18:19:49
Subject: unsuscribe pgsql-patches

pgsql-general by date

Next:From: Richard HuxtonDate: 2005-12-02 18:32:55
Subject: Re: accessing text of the query in a rule
Previous:From: Gary HortonDate: 2005-12-02 18:08:40
Subject: createuser ignores stdin in 8.1.0?

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