diff options
Diffstat (limited to 'src/test/regress/expected/point.out')
| -rw-r--r-- | src/test/regress/expected/point.out | 14 |
1 files changed, 2 insertions, 12 deletions
diff --git a/src/test/regress/expected/point.out b/src/test/regress/expected/point.out index 1dc535d1b32..3bde8ac7d09 100644 --- a/src/test/regress/expected/point.out +++ b/src/test/regress/expected/point.out @@ -3,22 +3,12 @@ -- -- avoid bit-exact output here because operations may not be bit-exact. SET extra_float_digits = 0; -CREATE TABLE POINT_TBL(f1 point); -INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)'); -INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)'); -INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)'); -INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)'); -INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)'); -INSERT INTO POINT_TBL(f1) VALUES ('(1e-300,-1e-300)'); -- To underflow -INSERT INTO POINT_TBL(f1) VALUES ('(1e+300,Inf)'); -- To overflow -INSERT INTO POINT_TBL(f1) VALUES ('(Inf,1e+300)'); -- Transposed -INSERT INTO POINT_TBL(f1) VALUES (' ( Nan , NaN ) '); --- bad format points +-- point_tbl was already created and filled in test_setup.sql. +-- Here we just try to insert bad values. INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf'); ERROR: invalid input syntax for type point: "asdfasdf" LINE 1: INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf'); ^ -INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0'); INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)'); ERROR: invalid input syntax for type point: "(10.0 10.0)" LINE 1: INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)'); |