OK, I give up :) How do I use the numeric type?
postgres=> create table n1 (n numeric(10,5), d decimal(10,5));
CREATE
postgres=> insert into n1 values ('1.23456', '1.23456');
ERROR: overflow on numeric
ABS(value) >= 10^0 for field with precision 2087 scale 31828
postgres=> insert into n1 values ('12345.23456', '1.23456');
ERROR: overflow on numeric
ABS(value) >= 10^4 for field with precision 2087 scale 50860
- Tom