5 CREATE TABLE PATH_TBL (f1 path);
6 INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]');
7 INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))');
8 INSERT INTO PATH_TBL VALUES ('[(0,0),(3,0),(4,5),(1,6)]');
9 INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))');
10 INSERT INTO PATH_TBL VALUES ('1,2 ,3,4');
11 INSERT INTO PATH_TBL VALUES ('[1,2,3, 4]');
12 INSERT INTO PATH_TBL VALUES ('[11,12,13,14]');
13 INSERT INTO PATH_TBL VALUES ('(11,12,13,14)');
14 -- bad values for parser testing
15 INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]');
16 ERROR: invalid input syntax for type path: "[(,2),(3,4)]"
17 INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)');
18 ERROR: invalid input syntax for type path: "[(1,2),(3,4)"
19 SELECT f1 FROM PATH_TBL;
21 ---------------------------
24 [(0,0),(3,0),(4,5),(1,6)]
32 SELECT '' AS count, f1 AS open_path FROM PATH_TBL WHERE isopen(f1);
34 -------+---------------------------
36 | [(0,0),(3,0),(4,5),(1,6)]
41 SELECT '' AS count, f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1);
43 -------+-------------------
50 SELECT '' AS count, pclose(f1) AS closed_path FROM PATH_TBL;
52 -------+---------------------------
55 | ((0,0),(3,0),(4,5),(1,6))
63 SELECT '' AS count, popen(f1) AS open_path FROM PATH_TBL;
65 -------+---------------------------
68 | [(0,0),(3,0),(4,5),(1,6)]