diff options
| author | Thomas G. Lockhart | 2000-01-05 06:06:23 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart | 2000-01-05 06:06:23 +0000 |
| commit | d83105539a9c00f50a6a87b7cacd6c144a338dcb (patch) | |
| tree | 9b26bb780d0d11fc9149d49ab27a3f3130b22d62 /src/test/regress/expected/path.out | |
| parent | 24e8ca6ef94cb9902250040a11627e8ca3798def (diff) | |
Verified output from new psql.
Include a few new tests for datetime/timespan arithmetic.
Diffstat (limited to 'src/test/regress/expected/path.out')
| -rw-r--r-- | src/test/regress/expected/path.out | 121 |
1 files changed, 63 insertions, 58 deletions
diff --git a/src/test/regress/expected/path.out b/src/test/regress/expected/path.out index 730356c734f..29490ef052a 100644 --- a/src/test/regress/expected/path.out +++ b/src/test/regress/expected/path.out @@ -1,70 +1,75 @@ -QUERY: CREATE TABLE PATH_TBL (f1 path); -QUERY: INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]'); -QUERY: INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); -QUERY: INSERT INTO PATH_TBL VALUES ('[(0,0),(3,0),(4,5),(1,6)]'); -QUERY: INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); -QUERY: INSERT INTO PATH_TBL VALUES ('1,2 ,3,4'); -QUERY: INSERT INTO PATH_TBL VALUES ('[1,2,3, 4]'); -QUERY: INSERT INTO PATH_TBL VALUES ('[11,12,13,14]'); -QUERY: INSERT INTO PATH_TBL VALUES ('(11,12,13,14)'); -QUERY: INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]'); +-- +-- PATH +-- +--DROP TABLE PATH_TBL; +CREATE TABLE PATH_TBL (f1 path); +INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]'); +INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); +INSERT INTO PATH_TBL VALUES ('[(0,0),(3,0),(4,5),(1,6)]'); +INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); +INSERT INTO PATH_TBL VALUES ('1,2 ,3,4'); +INSERT INTO PATH_TBL VALUES ('[1,2,3, 4]'); +INSERT INTO PATH_TBL VALUES ('[11,12,13,14]'); +INSERT INTO PATH_TBL VALUES ('(11,12,13,14)'); +-- bad values for parser testing +INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]'); ERROR: Bad path external representation '[(,2),(3,4)]' -QUERY: INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)'); +INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)'); ERROR: Bad path external representation '[(1,2),(3,4)' -QUERY: SELECT f1 FROM PATH_TBL; -f1 -------------------------- -[(1,2),(3,4)] -((1,2),(3,4)) -[(0,0),(3,0),(4,5),(1,6)] -((1,2),(3,4)) -((1,2),(3,4)) -[(1,2),(3,4)] -[(11,12),(13,14)] -((11,12),(13,14)) +SELECT f1 FROM PATH_TBL; + f1 +--------------------------- + [(1,2),(3,4)] + ((1,2),(3,4)) + [(0,0),(3,0),(4,5),(1,6)] + ((1,2),(3,4)) + ((1,2),(3,4)) + [(1,2),(3,4)] + [(11,12),(13,14)] + ((11,12),(13,14)) (8 rows) -QUERY: SELECT '' AS count, f1 AS open_path FROM PATH_TBL WHERE isopen(f1); -count|open_path ------+------------------------- - |[(1,2),(3,4)] - |[(0,0),(3,0),(4,5),(1,6)] - |[(1,2),(3,4)] - |[(11,12),(13,14)] +SELECT '' AS count, f1 AS open_path FROM PATH_TBL WHERE isopen(f1); + count | open_path +-------+--------------------------- + | [(1,2),(3,4)] + | [(0,0),(3,0),(4,5),(1,6)] + | [(1,2),(3,4)] + | [(11,12),(13,14)] (4 rows) -QUERY: SELECT '' AS count, f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1); -count|closed_path ------+----------------- - |((1,2),(3,4)) - |((1,2),(3,4)) - |((1,2),(3,4)) - |((11,12),(13,14)) +SELECT '' AS count, f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1); + count | closed_path +-------+------------------- + | ((1,2),(3,4)) + | ((1,2),(3,4)) + | ((1,2),(3,4)) + | ((11,12),(13,14)) (4 rows) -QUERY: SELECT '' AS count, pclose(f1) AS closed_path FROM PATH_TBL; -count|closed_path ------+------------------------- - |((1,2),(3,4)) - |((1,2),(3,4)) - |((0,0),(3,0),(4,5),(1,6)) - |((1,2),(3,4)) - |((1,2),(3,4)) - |((1,2),(3,4)) - |((11,12),(13,14)) - |((11,12),(13,14)) +SELECT '' AS count, pclose(f1) AS closed_path FROM PATH_TBL; + count | closed_path +-------+--------------------------- + | ((1,2),(3,4)) + | ((1,2),(3,4)) + | ((0,0),(3,0),(4,5),(1,6)) + | ((1,2),(3,4)) + | ((1,2),(3,4)) + | ((1,2),(3,4)) + | ((11,12),(13,14)) + | ((11,12),(13,14)) (8 rows) -QUERY: SELECT '' AS count, popen(f1) AS open_path FROM PATH_TBL; -count|open_path ------+------------------------- - |[(1,2),(3,4)] - |[(1,2),(3,4)] - |[(0,0),(3,0),(4,5),(1,6)] - |[(1,2),(3,4)] - |[(1,2),(3,4)] - |[(1,2),(3,4)] - |[(11,12),(13,14)] - |[(11,12),(13,14)] +SELECT '' AS count, popen(f1) AS open_path FROM PATH_TBL; + count | open_path +-------+--------------------------- + | [(1,2),(3,4)] + | [(1,2),(3,4)] + | [(0,0),(3,0),(4,5),(1,6)] + | [(1,2),(3,4)] + | [(1,2),(3,4)] + | [(1,2),(3,4)] + | [(11,12),(13,14)] + | [(11,12),(13,14)] (8 rows) |