Bruce Momjian <pgman@candle.pha.pa.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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend