Re: [HACKERS] numeric & decimal

> > > 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
declaredprecision ..."
 

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