[HACKERS] Numeric field quirk [Again]

[Matthew Hagerty]

Greetings,

Well, it seems that the numeric issue I was having has nothing to do with 
the precision and scale being set the same, it has to do with the input 
data.  The precision has to be at least 2 greater than the biggest number 
you need to enter, i.e.

equinox=# create table test ( d numeric(4,2) );
CREATE
equinox=# insert into test values(10);
INSERT 167844 1
equinox=# insert into test values(101);
ERROR:  overflow on numeric ABS(value) >= 10^2 for field with precision 4 
scale 2


Matthew