diff options
Diffstat (limited to 'src/test/regress/expected/float4.out')
| -rw-r--r-- | src/test/regress/expected/float4.out | 22 |
1 files changed, 13 insertions, 9 deletions
diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out index b94816eaeb..b3bc431a15 100644 --- a/src/test/regress/expected/float4.out +++ b/src/test/regress/expected/float4.out @@ -8,14 +8,14 @@ INSERT INTO FLOAT4_TBL(f1) VALUES (' -34.84 '); INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e+20'); INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e-20'); -- test for over and under flow -INSERT INTO FLOAT4_TBL(f1) VALUES ('10e40'); -ERROR: type "real" value out of range: overflow -INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e40'); -ERROR: type "real" value out of range: overflow -INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-40'); -ERROR: type "real" value out of range: underflow -INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-40'); -ERROR: type "real" value out of range: underflow +INSERT INTO FLOAT4_TBL(f1) VALUES ('10e70'); +ERROR: value out of range: overflow +INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e70'); +ERROR: value out of range: overflow +INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-70'); +ERROR: value out of range: underflow +INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-70'); +ERROR: value out of range: underflow -- bad input INSERT INTO FLOAT4_TBL(f1) VALUES (''); ERROR: invalid input syntax for type real: "" @@ -72,7 +72,11 @@ ERROR: invalid input syntax for type real: "NaN x" SELECT ' INFINITY x'::float4; ERROR: invalid input syntax for type real: " INFINITY x" SELECT 'Infinity'::float4 + 100.0; -ERROR: type "double precision" value out of range: overflow + ?column? +---------- + Infinity +(1 row) + SELECT 'Infinity'::float4 / 'Infinity'::float4; ?column? ---------- |