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 ('((10,20))'); -- Only one point 22 23INSERT INTO PATH_TBL VALUES ('[ 11,12,13,14 ]'); 24 25INSERT INTO PATH_TBL VALUES ('( 11,12,13,14) '); 26 27-- bad values for parser testing 28INSERT INTO PATH_TBL VALUES ('[]'); 29 30INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]'); 31 32INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)'); 33 34INSERT INTO PATH_TBL VALUES ('(1,2,3,4'); 35 36INSERT INTO PATH_TBL VALUES ('(1,2),(3,4)]'); 37 38SELECT f1 AS open_path FROM PATH_TBL WHERE isopen(f1); 39 40SELECT f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1); 41 42SELECT pclose(f1) AS closed_path FROM PATH_TBL; 43 44SELECT popen(f1) AS open_path FROM PATH_TBL; 45