Re: Precision of data types and functions

On Mon, 2006-08-28 at 13:54, Gregory Stark wrote:
> Scott Marlowe <smarlowe@g2switchworks.com> 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...