From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Gregory Stark <gsstark(at)mit(dot)edu> |
Cc: | Brandon Aiken <BAiken(at)winemantech(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Precision of data types and functions |
Date: | 2006-08-28 19:31:15 |
Message-ID: | 1156793475.10490.20.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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...
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Godoy | 2006-08-28 19:36:22 | Re: Precision of data types and functions |
Previous Message | Jasbinder Bali | 2006-08-28 19:26:55 | Re: [GENERAL] Shared Objects (Dynamic loading) |