Re: Precision of data types and functions

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