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