Greetings,
I'm not sure if this is a bug, but I thought someone might like to know
about it. If you create a numeric field with the precision and scale set
the same, you can't insert anything into the field... pg-7.0.2 on
FreeBSD-4.0-Rel.
Matthew
equinox=# create table test2 ( d numeric(8,2) );
CREATE
equinox=# insert into test2 values ('08.00');
INSERT 167730 1
equinox=# select * from test2; d
------ 8.00
(1 row)
equinox=# create table test2 ( d numeric(3,3) );
CREATE
equinox=# insert into test2 values ('8');
ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 3
scale 3
equinox=# drop table test2;
DROP
equinox=# create table test2 ( d numeric(4,4) );
CREATE
equinox=# insert into test2 values ('8');
ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4
scale 4
equinox=# create table test2 ( d numeric(3,2) );
CREATE
equinox=# insert into test2 values ('8');
INSERT 167742 1