Scott Marlowe <smarlowe@g2switchworks.com> writes:
> test=> create table test (a numeric(12,2));
> CREATE TABLE
> test=> insert into test values (123123123123123.2);
> ERROR: numeric field overflow
> DETAIL: The absolute value is greater than or equal to 10^14 for field
> with precision 12, scale 2.
Uhm 10^14? What version of Postgres is that?!
Though I get a correct text with 8.2CVS:
postgres=> insert into test values (123123123123123.2);
ERROR: numeric field overflow
DETAIL: A field with precision 12, scale 2 must have an absolute value less than 10^10.
I guess Tom fixed some bugs when he reimplemented NUMERIC a while back.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com