Search Postgresql Archives

Re: Precision of data types and functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux