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/test | |
| parent | 45c8ed96b9e4cd20b5ffed7e8a21a941eb3fa4c5 (diff) | |
| download | postgresql-0a42adcc320b0917d44a95029c35ec0343192268.tar.gz postgresql-0a42adcc320b0917d44a95029c35ec0343192268.zip | |
Improve numeric overflow error message.
David Fetter
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/numeric.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index 08a4841458c..96c70a8a097 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: A field with precision 4, scale 4 must have an absolute value less than 1. +DETAIL: A field with precision 4, scale 4 must round to 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: A field with precision 4, scale 4 must have an absolute value less than 1. +DETAIL: A field with precision 4, scale 4 must round to 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; |