1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
|
--
-- 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 ('((10,20))'); -- Only one point
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 ('[]');
ERROR: invalid input syntax for type path: "[]"
LINE 1: INSERT INTO PATH_TBL VALUES ('[]');
^
INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]');
ERROR: invalid input syntax for type path: "[(,2),(3,4)]"
LINE 1: INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]');
^
INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)');
ERROR: invalid input syntax for type path: "[(1,2),(3,4)"
LINE 1: INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)');
^
INSERT INTO PATH_TBL VALUES ('(1,2,3,4');
ERROR: invalid input syntax for type path: "(1,2,3,4"
LINE 1: INSERT INTO PATH_TBL VALUES ('(1,2,3,4');
^
INSERT INTO PATH_TBL VALUES ('(1,2),(3,4)]');
ERROR: invalid input syntax for type path: "(1,2),(3,4)]"
LINE 1: INSERT INTO PATH_TBL VALUES ('(1,2),(3,4)]');
^
SELECT f1 AS open_path FROM PATH_TBL WHERE isopen(f1);
open_path
---------------------------
[(1,2),(3,4)]
[(0,0),(3,0),(4,5),(1,6)]
[(1,2),(3,4)]
[(11,12),(13,14)]
(4 rows)
SELECT f1 AS closed_path FROM PATH_TBL WHERE isclosed(f1);
closed_path
-------------------
((1,2),(3,4))
((1,2),(3,4))
((1,2),(3,4))
((10,20))
((11,12),(13,14))
(5 rows)
SELECT pclose(f1) AS closed_path FROM PATH_TBL;
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))
((10,20))
((11,12),(13,14))
((11,12),(13,14))
(9 rows)
SELECT popen(f1) AS open_path FROM PATH_TBL;
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)]
[(10,20)]
[(11,12),(13,14)]
[(11,12),(13,14)]
(9 rows)
-- test non-error-throwing API for some core types
SELECT pg_input_is_valid('[(1,2),(3)]', 'path');
pg_input_is_valid
-------------------
f
(1 row)
SELECT * FROM pg_input_error_info('[(1,2),(3)]', 'path');
message | detail | hint | sql_error_code
---------------------------------------------------+--------+------+----------------
invalid input syntax for type path: "[(1,2),(3)]" | | | 22P02
(1 row)
SELECT pg_input_is_valid('[(1,2,6),(3,4,6)]', 'path');
pg_input_is_valid
-------------------
f
(1 row)
SELECT * FROM pg_input_error_info('[(1,2,6),(3,4,6)]', 'path');
message | detail | hint | sql_error_code
---------------------------------------------------------+--------+------+----------------
invalid input syntax for type path: "[(1,2,6),(3,4,6)]" | | | 22P02
(1 row)
|
