aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2006-01-25 18:15:03 +0000
committerBruce Momjian <bruce@momjian.us>2006-01-25 18:15:03 +0000
commit514d0f4db63abb66271b9decf01385509e83edab (patch)
treefd6c90aad43f46a0ecbdc226c2d8a56d7a1cc00a /src
parentcdc15b24be5b4fa931c56f804492fe0c4ef1e76f (diff)
downloadpostgresql-514d0f4db63abb66271b9decf01385509e83edab.tar.gz
postgresql-514d0f4db63abb66271b9decf01385509e83edab.zip
Update regression error message for NUMERIC range overflow. Display "1"
instead of 10^0.
Diffstat (limited to 'src')
-rw-r--r--src/backend/utils/adt/numeric.c9
1 files changed, 6 insertions, 3 deletions
diff --git a/src/backend/utils/adt/numeric.c b/src/backend/utils/adt/numeric.c
index dcc9a7d6836..bd1e28d64b9 100644
--- a/src/backend/utils/adt/numeric.c
+++ b/src/backend/utils/adt/numeric.c
@@ -14,7 +14,7 @@
* Copyright (c) 1998-2005, PostgreSQL Global Development Group
*
* IDENTIFICATION
- * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.89 2006/01/25 17:54:14 momjian Exp $
+ * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.90 2006/01/25 18:15:03 momjian Exp $
*
*-------------------------------------------------------------------------
*/
@@ -3206,8 +3206,11 @@ apply_typmod(NumericVar *var, int32 typmod)
ereport(ERROR,
(errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE),
errmsg("numeric field overflow"),
- errdetail("A field with precision %d, scale %d must have an absolute value less than 10^%d.",
- precision, scale, maxdigits)));
+ errdetail("A field with precision %d, scale %d must have an absolute value less than %s%d.",
+ precision, scale,
+ /* Display 10^0 as 1 */
+ maxdigits ? "10^" : "",
+ maxdigits ? maxdigits : 1)));
break;
}
ddigits -= DEC_DIGITS;