Re: [HACKERS] numeric & decimal

Cool, item removed.

> > > > NUMERIC without size is interpreted as NUMERIC(x,6). Why ?
> > > > Standard SQL92 says that NUMERIC without size is equivalent
> > > > to NUMERIC(1)
> > PostgreSQL specific. Should I change it to standard?
>
> The standard (per Date's book) is:
>
> NUMERIC == NUMERIC(p), where p is implementation-defined.
> NUMERIC(p) == NUMERIC(p,0)
>
> Date also explicitly says that:
>
> "The following are implementation-defined:
> ...
> o The default precision for NUMERIC and DECIMAL if there is no
> declared precision
> ..."
>
> So where did NUMERIC(1) come from? afaict Jan should use what he feels
> are reasonable values...
>
> - Tom
>
> --
> Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
> South Pasadena, California
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(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