Gregory Stark <[EMAIL PROTECTED]> writes: > Scott Marlowe <[EMAIL PROTECTED]> writes: >> 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?! Looks like any current release :-( > Though I get a correct text with 8.2CVS: > ... > I guess Tom fixed some bugs when he reimplemented NUMERIC a while back. No, I think Bruce fixed this recently. It's just a cosmetic mistake in the error message so we didn't back-patch it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster