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.