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@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