Re: numeric/decimal docs bug?

Jan Wieck wrote:
> > The hard limit is certainly no more than 64K, since we store these
> > numbers in half of an atttypmod. In practice I suspect the limit may
> > be less; Jan would be more likely to remember...
>
> It is arbitrary of course. I don't recall completely, have to
> dig into the code, but there might be some side effect when
> mucking with it.
>
> The NUMERIC code increases the actual internal precision when
> doing multiply and divide, what happens a gazillion times
> when doing higher functions like trigonometry. I think there
> was some connection between the max precision and how high
> this internal precision can grow, so increasing the precision
> might affect the computational performance of such higher
> functions significantly.

Oh, interesting, maybe we should just leave it alone.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026