On Mon, 2006-08-28 at 13:54, Gregory Stark wrote: > Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes: > > > test=> create table test (a numeric(12,2)); > > CREATE TABLE > > 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?! It was in the post, it's 7.4.12 (just upgraded it to 7.4.13, as it was my workstation) It's the version we're stuck on for a while here work. 10^14 is just another way of saying precision 12, or somewhat close to it. My point being that a two+ year old version of PostgreSQL is still superior to the latest release version of MySQL...
