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