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.