From: | jwieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) |
Cc: | jose(at)sferacarta(dot)com, jwieck(at)debis(dot)com, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] numeric & decimal |
Date: | 1999-05-10 16:51:02 |
Message-ID: | m10gtGg-000EBXC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
>
>
> This looks like something that should be addressed. Was it?
>
>
>
> > > For some reason (dunno why) the parser ignores the precision
> > > for DECIMAL. atttypmod is set hardcoded to -1. So the above
> > > is identical to a
> > >
> > > CREATE TABLE test (n numeric(10,3), d decimal);
> > >
> > > I'll test what happens if I enable it in gram.y and if it
> > > doesn't break any regression commit the changes.
This one is fixed. Parser handles precision of DECIMAL
already.
> > 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?
> >
> > - NUMERIC(4,1) transalte value -999.99 as -1000.0 (greater than his size)
Definitely a bug. The value is checked before the rounding.
Will fix it soon.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-05-10 16:51:03 | Re: [HACKERS] views and group by (formerly: create view as selec |
Previous Message | Tom Lane | 1999-05-10 16:49:22 | Re: [HACKERS] INSERT INTO |