diff options
Diffstat (limited to 'src/test/regress/sql/float8.sql')
| -rw-r--r-- | src/test/regress/sql/float8.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/sql/float8.sql b/src/test/regress/sql/float8.sql index 593df68a326..4c706099cdd 100644 --- a/src/test/regress/sql/float8.sql +++ b/src/test/regress/sql/float8.sql @@ -10,11 +10,11 @@ INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84'); INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200'); INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200'); --- test for underflow and overflow -INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); -INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); -INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); -INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); +-- test for underflow and overflow handling +SELECT '10e400'::float8; +SELECT '-10e400'::float8; +SELECT '10e-400'::float8; +SELECT '-10e-400'::float8; -- bad input INSERT INTO FLOAT8_TBL(f1) VALUES (' '); |