| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Jan Wieck <jwieck(at)debis(dot)com> |
| Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, jose(at)sferacarta(dot)com, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] numeric & decimal |
| Date: | 1999-05-10 17:58:30 |
| Message-ID: | 37371E46.13434AA0@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1999-05-10 18:01:24 | Re: [HACKERS] views and group by (formerly: create view as selec |
| Previous Message | Oleg Bartunov | 1999-05-10 17:56:14 | Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604 |