| From: | "Andrus" <eetasoft(at)online(dot)ee> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Different exponent in error messages |
| Date: | 2006-01-11 20:23:42 |
| Message-ID: | dq3qnv$jur$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
I have NUMERIC(9,3) field.
Postgres produces different (!) error messages when inserted value is too
big to fit into this field
ERROR: numeric field overflow
DETAIL: The absolute value is greater than or equal to 10^6 for field with
precision 9, scale 3.;
DETAIL: The absolute value is greater than or equal to 10^9 for field with
precision 9, scale 3.;
DETAIL: The absolute value is greater than or equal to 10^7 for field with
precision 9, scale 3.;
Why Postgres 8.1.1 in XP returns different exponents ( 10^6, 10^9, 10^7) for
field with precision 9, scale 3 ?
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Qingqing Zhou | 2006-01-11 21:01:44 | Re: index and MVCC |
| Previous Message | Jim Nasby | 2006-01-11 19:31:06 | Re: [SPAM] - how can we use outer join in Postures - Found word(s) if you received this in error in the Text body |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-11 21:09:23 | Re: Different exponent in error messages |
| Previous Message | Tom Lane | 2006-01-11 20:17:16 | Re: TODO-item: Add sleep() function, remove from regress.c |