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


Wed, 04 Oct 2000 23:41:14 -0400
Matthew Hagerty <matthew@venux.net>
Numeric field quirk