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