Re: numeric/decimal docs bug? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: numeric/decimal docs bug?
Date
Msg-id 20020312110117E.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: numeric/decimal docs bug?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: numeric/decimal docs bug?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> 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.

So are we going to just fix the docs?
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: Object?? -Relational DBMS Postgresql are you sure?
Next
From: Tom Lane
Date:
Subject: Re: Promising results with Intel Linux x86 compiler