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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
|
-- Adjust this setting to control where the objects get dropped.
SET search_path = public;
DROP OPERATOR CLASS gist__ltree_ops USING gist;
DROP FUNCTION _ltree_same(internal, internal, internal);
DROP FUNCTION _ltree_union(internal, internal);
DROP FUNCTION _ltree_picksplit(internal, internal);
DROP FUNCTION _ltree_penalty(internal,internal,internal);
DROP FUNCTION _ltree_compress(internal);
DROP FUNCTION _ltree_consistent(internal,internal,int2);
DROP OPERATOR ?@ (_ltree, ltxtquery);
DROP FUNCTION _ltxtq_extract_exec(_ltree,ltxtquery);
DROP OPERATOR ?~ (_ltree, lquery);
DROP FUNCTION _ltq_extract_regex(_ltree,lquery);
DROP OPERATOR ?<@ (_ltree, ltree);
DROP FUNCTION _ltree_extract_risparent(_ltree,ltree);
DROP OPERATOR ?@> (_ltree, ltree);
DROP FUNCTION _ltree_extract_isparent(_ltree,ltree);
DROP OPERATOR ^@ (ltxtquery, _ltree);
DROP OPERATOR ^@ (_ltree, ltxtquery);
DROP OPERATOR ^? (_lquery, _ltree);
DROP OPERATOR ^? (_ltree, _lquery);
DROP OPERATOR ^~ (lquery, _ltree);
DROP OPERATOR ^~ (_ltree, lquery);
DROP OPERATOR ^@> (ltree, _ltree);
DROP OPERATOR ^<@ (_ltree, ltree);
DROP OPERATOR ^<@ (ltree, _ltree);
DROP OPERATOR ^@> (_ltree, ltree);
DROP OPERATOR @ (ltxtquery, _ltree);
DROP OPERATOR @ (_ltree, ltxtquery);
DROP OPERATOR ? (_lquery, _ltree);
DROP OPERATOR ? (_ltree, _lquery);
DROP OPERATOR ~ (lquery, _ltree);
DROP OPERATOR ~ (_ltree, lquery);
DROP OPERATOR @> (ltree, _ltree);
DROP OPERATOR <@ (_ltree, ltree);
DROP OPERATOR <@ (ltree, _ltree);
DROP OPERATOR @> (_ltree, ltree);
DROP FUNCTION _ltxtq_rexec(ltxtquery, _ltree);
DROP FUNCTION _ltxtq_exec(_ltree, ltxtquery);
DROP FUNCTION _lt_q_rregex(_lquery,_ltree);
DROP FUNCTION _lt_q_regex(_ltree,_lquery);
DROP FUNCTION _ltq_rregex(lquery,_ltree);
DROP FUNCTION _ltq_regex(_ltree,lquery);
DROP FUNCTION _ltree_r_risparent(ltree,_ltree);
DROP FUNCTION _ltree_risparent(_ltree,ltree);
DROP FUNCTION _ltree_r_isparent(ltree,_ltree);
DROP FUNCTION _ltree_isparent(_ltree,ltree);
DROP OPERATOR CLASS gist_ltree_ops USING gist;
DROP FUNCTION ltree_same(internal, internal, internal);
DROP FUNCTION ltree_union(internal, internal);
DROP FUNCTION ltree_picksplit(internal, internal);
DROP FUNCTION ltree_penalty(internal,internal,internal);
DROP FUNCTION ltree_decompress(internal);
DROP FUNCTION ltree_compress(internal);
DROP FUNCTION ltree_consistent(internal,internal,int2);
DROP TYPE ltree_gist CASCADE;
DROP OPERATOR ^@ (ltxtquery, ltree);
DROP OPERATOR ^@ (ltree, ltxtquery);
DROP OPERATOR @ (ltxtquery, ltree);
DROP OPERATOR @ (ltree, ltxtquery);
DROP FUNCTION ltxtq_rexec(ltxtquery, ltree);
DROP FUNCTION ltxtq_exec(ltree, ltxtquery);
DROP TYPE ltxtquery CASCADE;
DROP OPERATOR ^? (_lquery, ltree);
DROP OPERATOR ^? (ltree, _lquery);
DROP OPERATOR ? (_lquery, ltree);
DROP OPERATOR ? (ltree, _lquery);
DROP FUNCTION lt_q_rregex(_lquery,ltree);
DROP FUNCTION lt_q_regex(ltree,_lquery);
DROP OPERATOR ^~ (lquery, ltree);
DROP OPERATOR ^~ (ltree, lquery);
DROP OPERATOR ~ (lquery, ltree);
DROP OPERATOR ~ (ltree, lquery);
DROP FUNCTION ltq_rregex(lquery,ltree);
DROP FUNCTION ltq_regex(ltree,lquery);
DROP TYPE lquery CASCADE;
DROP OPERATOR CLASS ltree_ops USING btree;
DROP OPERATOR || (text, ltree);
DROP OPERATOR || (ltree, text);
DROP OPERATOR || (ltree, ltree);
DROP OPERATOR ^<@ (ltree, ltree);
DROP OPERATOR <@ (ltree, ltree);
DROP OPERATOR ^@> (ltree, ltree);
DROP OPERATOR @> (ltree, ltree);
DROP FUNCTION ltreeparentsel(internal, oid, internal, integer);
DROP FUNCTION ltree_textadd(text,ltree);
DROP FUNCTION ltree_addtext(ltree,text);
DROP FUNCTION ltree_addltree(ltree,ltree);
DROP FUNCTION ltree_risparent(ltree,ltree);
DROP FUNCTION ltree_isparent(ltree,ltree);
DROP FUNCTION lca(ltree,ltree,ltree,ltree,ltree,ltree,ltree,ltree);
DROP FUNCTION lca(ltree,ltree,ltree,ltree,ltree,ltree,ltree);
DROP FUNCTION lca(ltree,ltree,ltree,ltree,ltree,ltree);
DROP FUNCTION lca(ltree,ltree,ltree,ltree,ltree);
DROP FUNCTION lca(ltree,ltree,ltree,ltree);
DROP FUNCTION lca(ltree,ltree,ltree);
DROP FUNCTION lca(ltree,ltree);
DROP FUNCTION lca(_ltree);
DROP FUNCTION text2ltree(text);
DROP FUNCTION ltree2text(ltree);
DROP FUNCTION nlevel(ltree);
DROP FUNCTION index(ltree,ltree,int4);
DROP FUNCTION index(ltree,ltree);
DROP FUNCTION subpath(ltree,int4);
DROP FUNCTION subpath(ltree,int4,int4);
DROP FUNCTION subltree(ltree,int4,int4);
DROP OPERATOR <> (ltree, ltree);
DROP OPERATOR = (ltree, ltree);
DROP OPERATOR > (ltree, ltree);
DROP OPERATOR >= (ltree, ltree);
DROP OPERATOR <= (ltree, ltree);
DROP OPERATOR < (ltree, ltree);
DROP FUNCTION ltree_ne(ltree,ltree);
DROP FUNCTION ltree_gt(ltree,ltree);
DROP FUNCTION ltree_ge(ltree,ltree);
DROP FUNCTION ltree_eq(ltree,ltree);
DROP FUNCTION ltree_le(ltree,ltree);
DROP FUNCTION ltree_lt(ltree,ltree);
DROP FUNCTION ltree_cmp(ltree,ltree);
DROP TYPE ltree CASCADE;
|
