Re: [HACKERS] numeric & decimal

Jan Wieck ha scritto:

> > Hi all,
> >
> > I'm trying numeric & decimal types in v6.5beta1 and I have two questions
> > about it.
> >
> > [...]
> >
> > Second question:
> > Why PostgreSQL allows to insert 14 digits into a numeric(5,1) ?
> >
> > create table test(
> > n numeric(10,3),
> > d decimal(5,1)
> > );
>
> 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.
>
> Jan
>

Great!
I have other questions about NUMERICs:

> create table test(
> num0 numeric,
> num1 numeric(1),
> num4 numeric(4,1)
> );
> CREATE
> insert into test values (11111111,11111111,-9,9,-999.99,-999.99);
> INSERT 78190 1
> select * from test;
> num0|num1| num4
> ---------------+----+-------
> 11111111.000000| 9|-1000.0
> ^^^^^^ ^^^^^^^

- I don't understand this default:
NUMERIC without size is interpreted as NUMERIC(x,6). Why ?
Standard SQL92 says that NUMERIC without size is equivalent to NUMERIC(1)

- NUMERIC(4,1) transalte value -999.99 as -1000.0 (greater than his size)

Comments?

José