1-- 2-- PATH 3-- 4 5--DROP TABLE PATH_TBL; 6 7CREATE TABLE PATH_TBL (f1 path); 8 9INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)]'); 10 11INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); 12 13INSERT INTO PATH_TBL VALUES ('[(0,0),(3,0),(4,5),(1,6)]'); 14 15INSERT INTO PATH_TBL VALUES ('((1,2),(3,4))'); 16 17INSERT INTO PATH_TBL VALUES ('1,2 ,3,4'); 18 19INSERT INTO PATH_TBL VALUES ('[1,2,3, 4]'); 20 21INSERT INTO PATH_TBL VALUES ('[11,12,13,14]'); 22 23INSERT INTO PATH_TBL VALUES ('(11,12,13,14)'); 24 25-- bad values for parser testing 26INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]'); 27 28INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)'); 29 30SELECT f1 FROM PATH_TBL; 31 32SELECT '' AS count, f1 AS open_path FROM PATH_TBL WHERE isopen(f1); 33 34SELECT '' AS count, f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1); 35 36SELECT '' AS count, pclose(f1) AS closed_path FROM PATH_TBL; 37 38SELECT '' AS count, popen(f1) AS open_path FROM PATH_TBL; 39