diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-10-03 21:25:56 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-10-03 21:25:56 +0000 |
| commit | 0a42adcc320b0917d44a95029c35ec0343192268 (patch) | |
| tree | b51e89ea4c20936dfb1039e481daca6040afbbcb /src/backend/utils/adt/numeric.c | |
| parent | 45c8ed96b9e4cd20b5ffed7e8a21a941eb3fa4c5 (diff) | |
| download | postgresql-0a42adcc320b0917d44a95029c35ec0343192268.tar.gz postgresql-0a42adcc320b0917d44a95029c35ec0343192268.zip | |
Improve numeric overflow error message.
David Fetter
Diffstat (limited to 'src/backend/utils/adt/numeric.c')
| -rw-r--r-- | src/backend/utils/adt/numeric.c | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/backend/utils/adt/numeric.c b/src/backend/utils/adt/numeric.c index fb15a6222fc..6d77c49c123 100644 --- a/src/backend/utils/adt/numeric.c +++ b/src/backend/utils/adt/numeric.c @@ -14,7 +14,7 @@ * Copyright (c) 1998-2006, PostgreSQL Global Development Group * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.94 2006/07/14 05:28:28 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.95 2006/10/03 21:25:55 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -3217,11 +3217,12 @@ 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 %s%d.", + errdetail("A field with precision %d, scale %d must round to an absolute value less than %s%d.", precision, scale, /* Display 10^0 as 1 */ maxdigits ? "10^" : "", - maxdigits ? maxdigits : 1))); + maxdigits ? maxdigits : 1 + ))); break; } ddigits -= DEC_DIGITS; |