Search Postgresql Archives

Different exponent in error messages

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

 



I have NUMERIC(9,3) field.
Postgres produces different (!) error messages when inserted value is too 
big to fit into this field

ERROR:  numeric field overflow

DETAIL:  The absolute value is greater than or equal to 10^6 for field with 
precision 9, scale 3.;

DETAIL:  The absolute value is greater than or equal to 10^9 for field with 
precision 9, scale 3.;

DETAIL:  The absolute value is greater than or equal to 10^7 for field with 
precision 9, scale 3.;


Why Postgres 8.1.1 in XP returns different exponents ( 10^6, 10^9, 10^7) for 
field with precision 9, scale 3 ?

Andrus. 




[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