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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026