From 0a42adcc320b0917d44a95029c35ec0343192268 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Tue, 3 Oct 2006 21:25:56 +0000
Subject: Improve numeric overflow error message.

David Fetter
---
 src/backend/utils/adt/numeric.c | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'src/backend/utils/adt/numeric.c')

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;
-- 
cgit v1.2.3