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@alumni.caltech.edu
> South Pasadena, California
>
-- Bruce Momjian | http://www.op.net/~candle maillist@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
