Re: Precision of data types and functions

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