aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2006-01-25 18:20:22 +0000
committerBruce Momjian <bruce@momjian.us>2006-01-25 18:20:22 +0000
commit06d45e485dcb65e948b747ccc3e995fadd183887 (patch)
treef96f8d30336af122f2fc2e7d61322880aec7afee
parent514d0f4db63abb66271b9decf01385509e83edab (diff)
downloadpostgresql-06d45e485dcb65e948b747ccc3e995fadd183887.tar.gz
postgresql-06d45e485dcb65e948b747ccc3e995fadd183887.zip
Update regression error message for NUMERIC range overflow. Display "1"
instead of "10^0".
-rw-r--r--src/test/regress/expected/numeric.out4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out
index 6f88c541e44..08a4841458c 100644
--- a/src/test/regress/expected/numeric.out
+++ b/src/test/regress/expected/numeric.out
@@ -688,12 +688,12 @@ INSERT INTO fract_only VALUES (1, '0.0');
INSERT INTO fract_only VALUES (2, '0.1');
INSERT INTO fract_only VALUES (3, '1.0'); -- should fail
ERROR: numeric field overflow
-DETAIL: The absolute value is greater than or equal to 10^0 for field with precision 4, scale 4.
+DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1.
INSERT INTO fract_only VALUES (4, '-0.9999');
INSERT INTO fract_only VALUES (5, '0.99994');
INSERT INTO fract_only VALUES (6, '0.99995'); -- should fail
ERROR: numeric field overflow
-DETAIL: The absolute value is greater than or equal to 10^0 for field with precision 4, scale 4.
+DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1.
INSERT INTO fract_only VALUES (7, '0.00001');
INSERT INTO fract_only VALUES (8, '0.00017');
SELECT * FROM fract_only;