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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
