| From: | Gregory Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| 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 18:54:56 |
| Message-ID: | 87k64szo5b.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?!
Though I get a correct text with 8.2CVS:
postgres=> insert into test values (123123123123123.2);
ERROR: numeric field overflow
DETAIL: A field with precision 12, scale 2 must have an absolute value less than 10^10.
I guess Tom fixed some bugs when he reimplemented NUMERIC a while back.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brandon Aiken | 2006-08-28 19:17:37 | Re: Precision of data types and functions |
| Previous Message | Scott Marlowe | 2006-08-28 18:21:06 | Re: Precision of data types and functions |