PostgreSQL Source Code  git master
 All Data Structures Namespaces Files Functions Variables Typedefs Enumerations Enumerator Macros
pg_operator.h
Go to the documentation of this file.
1 /*-------------------------------------------------------------------------
2  *
3  * pg_operator.h
4  * definition of the system "operator" relation (pg_operator)
5  * along with the relation's initial contents.
6  *
7  *
8  * Portions Copyright (c) 1996-2016, PostgreSQL Global Development Group
9  * Portions Copyright (c) 1994, Regents of the University of California
10  *
11  * src/include/catalog/pg_operator.h
12  *
13  * NOTES
14  * the genbki.pl script reads this file and generates .bki
15  * information from the DATA() statements.
16  *
17  * XXX do NOT break up DATA() statements into multiple lines!
18  * the scripts are not as smart as you might think...
19  *
20  *-------------------------------------------------------------------------
21  */
22 #ifndef PG_OPERATOR_H
23 #define PG_OPERATOR_H
24 
25 #include "catalog/genbki.h"
26 
27 /* ----------------
28  * pg_operator definition. cpp turns this into
29  * typedef struct FormData_pg_operator
30  * ----------------
31  */
32 #define OperatorRelationId 2617
33 
34 CATALOG(pg_operator,2617)
35 {
36  NameData oprname; /* name of operator */
37  Oid oprnamespace; /* OID of namespace containing this oper */
38  Oid oprowner; /* operator owner */
39  char oprkind; /* 'l', 'r', or 'b' */
40  bool oprcanmerge; /* can be used in merge join? */
41  bool oprcanhash; /* can be used in hash join? */
42  Oid oprleft; /* left arg type, or 0 if 'l' oprkind */
43  Oid oprright; /* right arg type, or 0 if 'r' oprkind */
44  Oid oprresult; /* result datatype */
45  Oid oprcom; /* OID of commutator oper, or 0 if none */
46  Oid oprnegate; /* OID of negator oper, or 0 if none */
47  regproc oprcode; /* OID of underlying function */
48  regproc oprrest; /* OID of restriction estimator, or 0 */
49  regproc oprjoin; /* OID of join estimator, or 0 */
50 } FormData_pg_operator;
51 
52 /* ----------------
53  * Form_pg_operator corresponds to a pointer to a tuple with
54  * the format of pg_operator relation.
55  * ----------------
56  */
57 typedef FormData_pg_operator *Form_pg_operator;
58 
59 /* ----------------
60  * compiler constants for pg_operator
61  * ----------------
62  */
63 
64 #define Natts_pg_operator 14
65 #define Anum_pg_operator_oprname 1
66 #define Anum_pg_operator_oprnamespace 2
67 #define Anum_pg_operator_oprowner 3
68 #define Anum_pg_operator_oprkind 4
69 #define Anum_pg_operator_oprcanmerge 5
70 #define Anum_pg_operator_oprcanhash 6
71 #define Anum_pg_operator_oprleft 7
72 #define Anum_pg_operator_oprright 8
73 #define Anum_pg_operator_oprresult 9
74 #define Anum_pg_operator_oprcom 10
75 #define Anum_pg_operator_oprnegate 11
76 #define Anum_pg_operator_oprcode 12
77 #define Anum_pg_operator_oprrest 13
78 #define Anum_pg_operator_oprjoin 14
79 
80 /* ----------------
81  * initial contents of pg_operator
82  * ----------------
83  */
84 
85 /*
86  * Note: every entry in pg_operator.h is expected to have a DESCR() comment.
87  * If the operator is a deprecated equivalent of some other entry, be sure
88  * to comment it as such so that initdb doesn't think it's a preferred name
89  * for the underlying function.
90  */
91 
92 DATA(insert OID = 15 ( "=" PGNSP PGUID b t t 23 20 16 416 36 int48eq eqsel eqjoinsel ));
93 DESCR("equal");
94 DATA(insert OID = 36 ( "<>" PGNSP PGUID b f f 23 20 16 417 15 int48ne neqsel neqjoinsel ));
95 DESCR("not equal");
96 DATA(insert OID = 37 ( "<" PGNSP PGUID b f f 23 20 16 419 82 int48lt scalarltsel scalarltjoinsel ));
97 DESCR("less than");
98 DATA(insert OID = 76 ( ">" PGNSP PGUID b f f 23 20 16 418 80 int48gt scalargtsel scalargtjoinsel ));
99 DESCR("greater than");
100 DATA(insert OID = 80 ( "<=" PGNSP PGUID b f f 23 20 16 430 76 int48le scalarltsel scalarltjoinsel ));
101 DESCR("less than or equal");
102 DATA(insert OID = 82 ( ">=" PGNSP PGUID b f f 23 20 16 420 37 int48ge scalargtsel scalargtjoinsel ));
103 DESCR("greater than or equal");
104 
105 DATA(insert OID = 58 ( "<" PGNSP PGUID b f f 16 16 16 59 1695 boollt scalarltsel scalarltjoinsel ));
106 DESCR("less than");
107 DATA(insert OID = 59 ( ">" PGNSP PGUID b f f 16 16 16 58 1694 boolgt scalargtsel scalargtjoinsel ));
108 DESCR("greater than");
109 DATA(insert OID = 85 ( "<>" PGNSP PGUID b f f 16 16 16 85 91 boolne neqsel neqjoinsel ));
110 DESCR("not equal");
111 #define BooleanNotEqualOperator 85
112 DATA(insert OID = 91 ( "=" PGNSP PGUID b t t 16 16 16 91 85 booleq eqsel eqjoinsel ));
113 DESCR("equal");
114 #define BooleanEqualOperator 91
115 DATA(insert OID = 1694 ( "<=" PGNSP PGUID b f f 16 16 16 1695 59 boolle scalarltsel scalarltjoinsel ));
116 DESCR("less than or equal");
117 DATA(insert OID = 1695 ( ">=" PGNSP PGUID b f f 16 16 16 1694 58 boolge scalargtsel scalargtjoinsel ));
118 DESCR("greater than or equal");
119 
120 DATA(insert OID = 92 ( "=" PGNSP PGUID b t t 18 18 16 92 630 chareq eqsel eqjoinsel ));
121 DESCR("equal");
122 DATA(insert OID = 93 ( "=" PGNSP PGUID b t t 19 19 16 93 643 nameeq eqsel eqjoinsel ));
123 DESCR("equal");
124 DATA(insert OID = 94 ( "=" PGNSP PGUID b t t 21 21 16 94 519 int2eq eqsel eqjoinsel ));
125 DESCR("equal");
126 DATA(insert OID = 95 ( "<" PGNSP PGUID b f f 21 21 16 520 524 int2lt scalarltsel scalarltjoinsel ));
127 DESCR("less than");
128 DATA(insert OID = 96 ( "=" PGNSP PGUID b t t 23 23 16 96 518 int4eq eqsel eqjoinsel ));
129 DESCR("equal");
130 #define Int4EqualOperator 96
131 DATA(insert OID = 97 ( "<" PGNSP PGUID b f f 23 23 16 521 525 int4lt scalarltsel scalarltjoinsel ));
132 DESCR("less than");
133 #define Int4LessOperator 97
134 DATA(insert OID = 98 ( "=" PGNSP PGUID b t t 25 25 16 98 531 texteq eqsel eqjoinsel ));
135 DESCR("equal");
136 #define TextEqualOperator 98
137 
138 DATA(insert OID = 349 ( "||" PGNSP PGUID b f f 2277 2283 2277 0 0 array_append - - ));
139 DESCR("append element onto end of array");
140 DATA(insert OID = 374 ( "||" PGNSP PGUID b f f 2283 2277 2277 0 0 array_prepend - - ));
141 DESCR("prepend element onto front of array");
142 DATA(insert OID = 375 ( "||" PGNSP PGUID b f f 2277 2277 2277 0 0 array_cat - - ));
143 DESCR("concatenate");
144 
145 DATA(insert OID = 352 ( "=" PGNSP PGUID b f t 28 28 16 352 3315 xideq eqsel eqjoinsel ));
146 DESCR("equal");
147 DATA(insert OID = 353 ( "=" PGNSP PGUID b f f 28 23 16 0 3316 xideqint4 eqsel eqjoinsel ));
148 DESCR("equal");
149 DATA(insert OID = 3315 ( "<>" PGNSP PGUID b f f 28 28 16 3315 352 xidneq neqsel neqjoinsel ));
150 DESCR("not equal");
151 DATA(insert OID = 3316 ( "<>" PGNSP PGUID b f f 28 23 16 0 353 xidneqint4 neqsel neqjoinsel ));
152 DESCR("not equal");
153 DATA(insert OID = 388 ( "!" PGNSP PGUID r f f 20 0 1700 0 0 numeric_fac - - ));
154 DESCR("factorial");
155 DATA(insert OID = 389 ( "!!" PGNSP PGUID l f f 0 20 1700 0 0 numeric_fac - - ));
156 DESCR("deprecated, use ! instead");
157 DATA(insert OID = 385 ( "=" PGNSP PGUID b f t 29 29 16 385 0 cideq eqsel eqjoinsel ));
158 DESCR("equal");
159 DATA(insert OID = 386 ( "=" PGNSP PGUID b f t 22 22 16 386 0 int2vectoreq eqsel eqjoinsel ));
160 DESCR("equal");
161 
162 DATA(insert OID = 387 ( "=" PGNSP PGUID b t f 27 27 16 387 402 tideq eqsel eqjoinsel ));
163 DESCR("equal");
164 #define TIDEqualOperator 387
165 DATA(insert OID = 402 ( "<>" PGNSP PGUID b f f 27 27 16 402 387 tidne neqsel neqjoinsel ));
166 DESCR("not equal");
167 DATA(insert OID = 2799 ( "<" PGNSP PGUID b f f 27 27 16 2800 2802 tidlt scalarltsel scalarltjoinsel ));
168 DESCR("less than");
169 #define TIDLessOperator 2799
170 DATA(insert OID = 2800 ( ">" PGNSP PGUID b f f 27 27 16 2799 2801 tidgt scalargtsel scalargtjoinsel ));
171 DESCR("greater than");
172 DATA(insert OID = 2801 ( "<=" PGNSP PGUID b f f 27 27 16 2802 2800 tidle scalarltsel scalarltjoinsel ));
173 DESCR("less than or equal");
174 DATA(insert OID = 2802 ( ">=" PGNSP PGUID b f f 27 27 16 2801 2799 tidge scalargtsel scalargtjoinsel ));
175 DESCR("greater than or equal");
176 
177 DATA(insert OID = 410 ( "=" PGNSP PGUID b t t 20 20 16 410 411 int8eq eqsel eqjoinsel ));
178 DESCR("equal");
179 DATA(insert OID = 411 ( "<>" PGNSP PGUID b f f 20 20 16 411 410 int8ne neqsel neqjoinsel ));
180 DESCR("not equal");
181 DATA(insert OID = 412 ( "<" PGNSP PGUID b f f 20 20 16 413 415 int8lt scalarltsel scalarltjoinsel ));
182 DESCR("less than");
183 #define Int8LessOperator 412
184 DATA(insert OID = 413 ( ">" PGNSP PGUID b f f 20 20 16 412 414 int8gt scalargtsel scalargtjoinsel ));
185 DESCR("greater than");
186 DATA(insert OID = 414 ( "<=" PGNSP PGUID b f f 20 20 16 415 413 int8le scalarltsel scalarltjoinsel ));
187 DESCR("less than or equal");
188 DATA(insert OID = 415 ( ">=" PGNSP PGUID b f f 20 20 16 414 412 int8ge scalargtsel scalargtjoinsel ));
189 DESCR("greater than or equal");
190 
191 DATA(insert OID = 416 ( "=" PGNSP PGUID b t t 20 23 16 15 417 int84eq eqsel eqjoinsel ));
192 DESCR("equal");
193 DATA(insert OID = 417 ( "<>" PGNSP PGUID b f f 20 23 16 36 416 int84ne neqsel neqjoinsel ));
194 DESCR("not equal");
195 DATA(insert OID = 418 ( "<" PGNSP PGUID b f f 20 23 16 76 430 int84lt scalarltsel scalarltjoinsel ));
196 DESCR("less than");
197 DATA(insert OID = 419 ( ">" PGNSP PGUID b f f 20 23 16 37 420 int84gt scalargtsel scalargtjoinsel ));
198 DESCR("greater than");
199 DATA(insert OID = 420 ( "<=" PGNSP PGUID b f f 20 23 16 82 419 int84le scalarltsel scalarltjoinsel ));
200 DESCR("less than or equal");
201 DATA(insert OID = 430 ( ">=" PGNSP PGUID b f f 20 23 16 80 418 int84ge scalargtsel scalargtjoinsel ));
202 DESCR("greater than or equal");
203 DATA(insert OID = 439 ( "%" PGNSP PGUID b f f 20 20 20 0 0 int8mod - - ));
204 DESCR("modulus");
205 DATA(insert OID = 473 ( "@" PGNSP PGUID l f f 0 20 20 0 0 int8abs - - ));
206 DESCR("absolute value");
207 
208 DATA(insert OID = 484 ( "-" PGNSP PGUID l f f 0 20 20 0 0 int8um - - ));
209 DESCR("negate");
210 DATA(insert OID = 485 ( "<<" PGNSP PGUID b f f 604 604 16 0 0 poly_left positionsel positionjoinsel ));
211 DESCR("is left of");
212 DATA(insert OID = 486 ( "&<" PGNSP PGUID b f f 604 604 16 0 0 poly_overleft positionsel positionjoinsel ));
213 DESCR("overlaps or is left of");
214 DATA(insert OID = 487 ( "&>" PGNSP PGUID b f f 604 604 16 0 0 poly_overright positionsel positionjoinsel ));
215 DESCR("overlaps or is right of");
216 DATA(insert OID = 488 ( ">>" PGNSP PGUID b f f 604 604 16 0 0 poly_right positionsel positionjoinsel ));
217 DESCR("is right of");
218 DATA(insert OID = 489 ( "<@" PGNSP PGUID b f f 604 604 16 490 0 poly_contained contsel contjoinsel ));
219 DESCR("is contained by");
220 DATA(insert OID = 490 ( "@>" PGNSP PGUID b f f 604 604 16 489 0 poly_contain contsel contjoinsel ));
221 DESCR("contains");
222 DATA(insert OID = 491 ( "~=" PGNSP PGUID b f f 604 604 16 491 0 poly_same eqsel eqjoinsel ));
223 DESCR("same as");
224 DATA(insert OID = 492 ( "&&" PGNSP PGUID b f f 604 604 16 492 0 poly_overlap areasel areajoinsel ));
225 DESCR("overlaps");
226 DATA(insert OID = 493 ( "<<" PGNSP PGUID b f f 603 603 16 0 0 box_left positionsel positionjoinsel ));
227 DESCR("is left of");
228 DATA(insert OID = 494 ( "&<" PGNSP PGUID b f f 603 603 16 0 0 box_overleft positionsel positionjoinsel ));
229 DESCR("overlaps or is left of");
230 DATA(insert OID = 495 ( "&>" PGNSP PGUID b f f 603 603 16 0 0 box_overright positionsel positionjoinsel ));
231 DESCR("overlaps or is right of");
232 DATA(insert OID = 496 ( ">>" PGNSP PGUID b f f 603 603 16 0 0 box_right positionsel positionjoinsel ));
233 DESCR("is right of");
234 DATA(insert OID = 497 ( "<@" PGNSP PGUID b f f 603 603 16 498 0 box_contained contsel contjoinsel ));
235 DESCR("is contained by");
236 DATA(insert OID = 498 ( "@>" PGNSP PGUID b f f 603 603 16 497 0 box_contain contsel contjoinsel ));
237 DESCR("contains");
238 DATA(insert OID = 499 ( "~=" PGNSP PGUID b f f 603 603 16 499 0 box_same eqsel eqjoinsel ));
239 DESCR("same as");
240 DATA(insert OID = 500 ( "&&" PGNSP PGUID b f f 603 603 16 500 0 box_overlap areasel areajoinsel ));
241 DESCR("overlaps");
242 DATA(insert OID = 501 ( ">=" PGNSP PGUID b f f 603 603 16 505 504 box_ge areasel areajoinsel ));
243 DESCR("greater than or equal by area");
244 DATA(insert OID = 502 ( ">" PGNSP PGUID b f f 603 603 16 504 505 box_gt areasel areajoinsel ));
245 DESCR("greater than by area");
246 DATA(insert OID = 503 ( "=" PGNSP PGUID b f f 603 603 16 503 0 box_eq eqsel eqjoinsel ));
247 DESCR("equal by area");
248 DATA(insert OID = 504 ( "<" PGNSP PGUID b f f 603 603 16 502 501 box_lt areasel areajoinsel ));
249 DESCR("less than by area");
250 DATA(insert OID = 505 ( "<=" PGNSP PGUID b f f 603 603 16 501 502 box_le areasel areajoinsel ));
251 DESCR("less than or equal by area");
252 DATA(insert OID = 506 ( ">^" PGNSP PGUID b f f 600 600 16 0 0 point_above positionsel positionjoinsel ));
253 DESCR("is above");
254 DATA(insert OID = 507 ( "<<" PGNSP PGUID b f f 600 600 16 0 0 point_left positionsel positionjoinsel ));
255 DESCR("is left of");
256 DATA(insert OID = 508 ( ">>" PGNSP PGUID b f f 600 600 16 0 0 point_right positionsel positionjoinsel ));
257 DESCR("is right of");
258 DATA(insert OID = 509 ( "<^" PGNSP PGUID b f f 600 600 16 0 0 point_below positionsel positionjoinsel ));
259 DESCR("is below");
260 DATA(insert OID = 510 ( "~=" PGNSP PGUID b f f 600 600 16 510 713 point_eq eqsel eqjoinsel ));
261 DESCR("same as");
262 DATA(insert OID = 511 ( "<@" PGNSP PGUID b f f 600 603 16 433 0 on_pb contsel contjoinsel ));
263 DESCR("point inside box");
264 DATA(insert OID = 433 ( "@>" PGNSP PGUID b f f 603 600 16 511 0 box_contain_pt contsel contjoinsel ));
265 DESCR("contains");
266 DATA(insert OID = 512 ( "<@" PGNSP PGUID b f f 600 602 16 755 0 on_ppath - - ));
267 DESCR("point within closed path, or point on open path");
268 DATA(insert OID = 513 ( "@@" PGNSP PGUID l f f 0 603 600 0 0 box_center - - ));
269 DESCR("center of");
270 DATA(insert OID = 514 ( "*" PGNSP PGUID b f f 23 23 23 514 0 int4mul - - ));
271 DESCR("multiply");
272 DATA(insert OID = 517 ( "<->" PGNSP PGUID b f f 600 600 701 517 0 point_distance - - ));
273 DESCR("distance between");
274 DATA(insert OID = 518 ( "<>" PGNSP PGUID b f f 23 23 16 518 96 int4ne neqsel neqjoinsel ));
275 DESCR("not equal");
276 DATA(insert OID = 519 ( "<>" PGNSP PGUID b f f 21 21 16 519 94 int2ne neqsel neqjoinsel ));
277 DESCR("not equal");
278 DATA(insert OID = 520 ( ">" PGNSP PGUID b f f 21 21 16 95 522 int2gt scalargtsel scalargtjoinsel ));
279 DESCR("greater than");
280 DATA(insert OID = 521 ( ">" PGNSP PGUID b f f 23 23 16 97 523 int4gt scalargtsel scalargtjoinsel ));
281 DESCR("greater than");
282 DATA(insert OID = 522 ( "<=" PGNSP PGUID b f f 21 21 16 524 520 int2le scalarltsel scalarltjoinsel ));
283 DESCR("less than or equal");
284 DATA(insert OID = 523 ( "<=" PGNSP PGUID b f f 23 23 16 525 521 int4le scalarltsel scalarltjoinsel ));
285 DESCR("less than or equal");
286 DATA(insert OID = 524 ( ">=" PGNSP PGUID b f f 21 21 16 522 95 int2ge scalargtsel scalargtjoinsel ));
287 DESCR("greater than or equal");
288 DATA(insert OID = 525 ( ">=" PGNSP PGUID b f f 23 23 16 523 97 int4ge scalargtsel scalargtjoinsel ));
289 DESCR("greater than or equal");
290 DATA(insert OID = 526 ( "*" PGNSP PGUID b f f 21 21 21 526 0 int2mul - - ));
291 DESCR("multiply");
292 DATA(insert OID = 527 ( "/" PGNSP PGUID b f f 21 21 21 0 0 int2div - - ));
293 DESCR("divide");
294 DATA(insert OID = 528 ( "/" PGNSP PGUID b f f 23 23 23 0 0 int4div - - ));
295 DESCR("divide");
296 DATA(insert OID = 529 ( "%" PGNSP PGUID b f f 21 21 21 0 0 int2mod - - ));
297 DESCR("modulus");
298 DATA(insert OID = 530 ( "%" PGNSP PGUID b f f 23 23 23 0 0 int4mod - - ));
299 DESCR("modulus");
300 DATA(insert OID = 531 ( "<>" PGNSP PGUID b f f 25 25 16 531 98 textne neqsel neqjoinsel ));
301 DESCR("not equal");
302 DATA(insert OID = 532 ( "=" PGNSP PGUID b t t 21 23 16 533 538 int24eq eqsel eqjoinsel ));
303 DESCR("equal");
304 DATA(insert OID = 533 ( "=" PGNSP PGUID b t t 23 21 16 532 539 int42eq eqsel eqjoinsel ));
305 DESCR("equal");
306 DATA(insert OID = 534 ( "<" PGNSP PGUID b f f 21 23 16 537 542 int24lt scalarltsel scalarltjoinsel ));
307 DESCR("less than");
308 DATA(insert OID = 535 ( "<" PGNSP PGUID b f f 23 21 16 536 543 int42lt scalarltsel scalarltjoinsel ));
309 DESCR("less than");
310 DATA(insert OID = 536 ( ">" PGNSP PGUID b f f 21 23 16 535 540 int24gt scalargtsel scalargtjoinsel ));
311 DESCR("greater than");
312 DATA(insert OID = 537 ( ">" PGNSP PGUID b f f 23 21 16 534 541 int42gt scalargtsel scalargtjoinsel ));
313 DESCR("greater than");
314 DATA(insert OID = 538 ( "<>" PGNSP PGUID b f f 21 23 16 539 532 int24ne neqsel neqjoinsel ));
315 DESCR("not equal");
316 DATA(insert OID = 539 ( "<>" PGNSP PGUID b f f 23 21 16 538 533 int42ne neqsel neqjoinsel ));
317 DESCR("not equal");
318 DATA(insert OID = 540 ( "<=" PGNSP PGUID b f f 21 23 16 543 536 int24le scalarltsel scalarltjoinsel ));
319 DESCR("less than or equal");
320 DATA(insert OID = 541 ( "<=" PGNSP PGUID b f f 23 21 16 542 537 int42le scalarltsel scalarltjoinsel ));
321 DESCR("less than or equal");
322 DATA(insert OID = 542 ( ">=" PGNSP PGUID b f f 21 23 16 541 534 int24ge scalargtsel scalargtjoinsel ));
323 DESCR("greater than or equal");
324 DATA(insert OID = 543 ( ">=" PGNSP PGUID b f f 23 21 16 540 535 int42ge scalargtsel scalargtjoinsel ));
325 DESCR("greater than or equal");
326 DATA(insert OID = 544 ( "*" PGNSP PGUID b f f 21 23 23 545 0 int24mul - - ));
327 DESCR("multiply");
328 DATA(insert OID = 545 ( "*" PGNSP PGUID b f f 23 21 23 544 0 int42mul - - ));
329 DESCR("multiply");
330 DATA(insert OID = 546 ( "/" PGNSP PGUID b f f 21 23 23 0 0 int24div - - ));
331 DESCR("divide");
332 DATA(insert OID = 547 ( "/" PGNSP PGUID b f f 23 21 23 0 0 int42div - - ));
333 DESCR("divide");
334 DATA(insert OID = 550 ( "+" PGNSP PGUID b f f 21 21 21 550 0 int2pl - - ));
335 DESCR("add");
336 DATA(insert OID = 551 ( "+" PGNSP PGUID b f f 23 23 23 551 0 int4pl - - ));
337 DESCR("add");
338 DATA(insert OID = 552 ( "+" PGNSP PGUID b f f 21 23 23 553 0 int24pl - - ));
339 DESCR("add");
340 DATA(insert OID = 553 ( "+" PGNSP PGUID b f f 23 21 23 552 0 int42pl - - ));
341 DESCR("add");
342 DATA(insert OID = 554 ( "-" PGNSP PGUID b f f 21 21 21 0 0 int2mi - - ));
343 DESCR("subtract");
344 DATA(insert OID = 555 ( "-" PGNSP PGUID b f f 23 23 23 0 0 int4mi - - ));
345 DESCR("subtract");
346 DATA(insert OID = 556 ( "-" PGNSP PGUID b f f 21 23 23 0 0 int24mi - - ));
347 DESCR("subtract");
348 DATA(insert OID = 557 ( "-" PGNSP PGUID b f f 23 21 23 0 0 int42mi - - ));
349 DESCR("subtract");
350 DATA(insert OID = 558 ( "-" PGNSP PGUID l f f 0 23 23 0 0 int4um - - ));
351 DESCR("negate");
352 DATA(insert OID = 559 ( "-" PGNSP PGUID l f f 0 21 21 0 0 int2um - - ));
353 DESCR("negate");
354 DATA(insert OID = 560 ( "=" PGNSP PGUID b t t 702 702 16 560 561 abstimeeq eqsel eqjoinsel ));
355 DESCR("equal");
356 DATA(insert OID = 561 ( "<>" PGNSP PGUID b f f 702 702 16 561 560 abstimene neqsel neqjoinsel ));
357 DESCR("not equal");
358 DATA(insert OID = 562 ( "<" PGNSP PGUID b f f 702 702 16 563 565 abstimelt scalarltsel scalarltjoinsel ));
359 DESCR("less than");
360 DATA(insert OID = 563 ( ">" PGNSP PGUID b f f 702 702 16 562 564 abstimegt scalargtsel scalargtjoinsel ));
361 DESCR("greater than");
362 DATA(insert OID = 564 ( "<=" PGNSP PGUID b f f 702 702 16 565 563 abstimele scalarltsel scalarltjoinsel ));
363 DESCR("less than or equal");
364 DATA(insert OID = 565 ( ">=" PGNSP PGUID b f f 702 702 16 564 562 abstimege scalargtsel scalargtjoinsel ));
365 DESCR("greater than or equal");
366 DATA(insert OID = 566 ( "=" PGNSP PGUID b t t 703 703 16 566 567 reltimeeq eqsel eqjoinsel ));
367 DESCR("equal");
368 DATA(insert OID = 567 ( "<>" PGNSP PGUID b f f 703 703 16 567 566 reltimene neqsel neqjoinsel ));
369 DESCR("not equal");
370 DATA(insert OID = 568 ( "<" PGNSP PGUID b f f 703 703 16 569 571 reltimelt scalarltsel scalarltjoinsel ));
371 DESCR("less than");
372 DATA(insert OID = 569 ( ">" PGNSP PGUID b f f 703 703 16 568 570 reltimegt scalargtsel scalargtjoinsel ));
373 DESCR("greater than");
374 DATA(insert OID = 570 ( "<=" PGNSP PGUID b f f 703 703 16 571 569 reltimele scalarltsel scalarltjoinsel ));
375 DESCR("less than or equal");
376 DATA(insert OID = 571 ( ">=" PGNSP PGUID b f f 703 703 16 570 568 reltimege scalargtsel scalargtjoinsel ));
377 DESCR("greater than or equal");
378 DATA(insert OID = 572 ( "~=" PGNSP PGUID b f f 704 704 16 572 0 tintervalsame eqsel eqjoinsel ));
379 DESCR("same as");
380 DATA(insert OID = 573 ( "<<" PGNSP PGUID b f f 704 704 16 0 0 tintervalct - - ));
381 DESCR("contains");
382 DATA(insert OID = 574 ( "&&" PGNSP PGUID b f f 704 704 16 574 0 tintervalov - - ));
383 DESCR("overlaps");
384 DATA(insert OID = 575 ( "#=" PGNSP PGUID b f f 704 703 16 0 576 tintervalleneq - - ));
385 DESCR("equal by length");
386 DATA(insert OID = 576 ( "#<>" PGNSP PGUID b f f 704 703 16 0 575 tintervallenne - - ));
387 DESCR("not equal by length");
388 DATA(insert OID = 577 ( "#<" PGNSP PGUID b f f 704 703 16 0 580 tintervallenlt - - ));
389 DESCR("less than by length");
390 DATA(insert OID = 578 ( "#>" PGNSP PGUID b f f 704 703 16 0 579 tintervallengt - - ));
391 DESCR("greater than by length");
392 DATA(insert OID = 579 ( "#<=" PGNSP PGUID b f f 704 703 16 0 578 tintervallenle - - ));
393 DESCR("less than or equal by length");
394 DATA(insert OID = 580 ( "#>=" PGNSP PGUID b f f 704 703 16 0 577 tintervallenge - - ));
395 DESCR("greater than or equal by length");
396 DATA(insert OID = 581 ( "+" PGNSP PGUID b f f 702 703 702 0 0 timepl - - ));
397 DESCR("add");
398 DATA(insert OID = 582 ( "-" PGNSP PGUID b f f 702 703 702 0 0 timemi - - ));
399 DESCR("subtract");
400 DATA(insert OID = 583 ( "<?>" PGNSP PGUID b f f 702 704 16 0 0 intinterval - - ));
401 DESCR("is contained by");
402 DATA(insert OID = 584 ( "-" PGNSP PGUID l f f 0 700 700 0 0 float4um - - ));
403 DESCR("negate");
404 DATA(insert OID = 585 ( "-" PGNSP PGUID l f f 0 701 701 0 0 float8um - - ));
405 DESCR("negate");
406 DATA(insert OID = 586 ( "+" PGNSP PGUID b f f 700 700 700 586 0 float4pl - - ));
407 DESCR("add");
408 DATA(insert OID = 587 ( "-" PGNSP PGUID b f f 700 700 700 0 0 float4mi - - ));
409 DESCR("subtract");
410 DATA(insert OID = 588 ( "/" PGNSP PGUID b f f 700 700 700 0 0 float4div - - ));
411 DESCR("divide");
412 DATA(insert OID = 589 ( "*" PGNSP PGUID b f f 700 700 700 589 0 float4mul - - ));
413 DESCR("multiply");
414 DATA(insert OID = 590 ( "@" PGNSP PGUID l f f 0 700 700 0 0 float4abs - - ));
415 DESCR("absolute value");
416 DATA(insert OID = 591 ( "+" PGNSP PGUID b f f 701 701 701 591 0 float8pl - - ));
417 DESCR("add");
418 DATA(insert OID = 592 ( "-" PGNSP PGUID b f f 701 701 701 0 0 float8mi - - ));
419 DESCR("subtract");
420 DATA(insert OID = 593 ( "/" PGNSP PGUID b f f 701 701 701 0 0 float8div - - ));
421 DESCR("divide");
422 DATA(insert OID = 594 ( "*" PGNSP PGUID b f f 701 701 701 594 0 float8mul - - ));
423 DESCR("multiply");
424 DATA(insert OID = 595 ( "@" PGNSP PGUID l f f 0 701 701 0 0 float8abs - - ));
425 DESCR("absolute value");
426 DATA(insert OID = 596 ( "|/" PGNSP PGUID l f f 0 701 701 0 0 dsqrt - - ));
427 DESCR("square root");
428 DATA(insert OID = 597 ( "||/" PGNSP PGUID l f f 0 701 701 0 0 dcbrt - - ));
429 DESCR("cube root");
430 DATA(insert OID = 1284 ( "|" PGNSP PGUID l f f 0 704 702 0 0 tintervalstart - - ));
431 DESCR("start of interval");
432 DATA(insert OID = 606 ( "<#>" PGNSP PGUID b f f 702 702 704 0 0 mktinterval - - ));
433 DESCR("convert to tinterval");
434 
435 DATA(insert OID = 607 ( "=" PGNSP PGUID b t t 26 26 16 607 608 oideq eqsel eqjoinsel ));
436 DESCR("equal");
437 DATA(insert OID = 608 ( "<>" PGNSP PGUID b f f 26 26 16 608 607 oidne neqsel neqjoinsel ));
438 DESCR("not equal");
439 DATA(insert OID = 609 ( "<" PGNSP PGUID b f f 26 26 16 610 612 oidlt scalarltsel scalarltjoinsel ));
440 DESCR("less than");
441 DATA(insert OID = 610 ( ">" PGNSP PGUID b f f 26 26 16 609 611 oidgt scalargtsel scalargtjoinsel ));
442 DESCR("greater than");
443 DATA(insert OID = 611 ( "<=" PGNSP PGUID b f f 26 26 16 612 610 oidle scalarltsel scalarltjoinsel ));
444 DESCR("less than or equal");
445 DATA(insert OID = 612 ( ">=" PGNSP PGUID b f f 26 26 16 611 609 oidge scalargtsel scalargtjoinsel ));
446 DESCR("greater than or equal");
447 
448 DATA(insert OID = 644 ( "<>" PGNSP PGUID b f f 30 30 16 644 649 oidvectorne neqsel neqjoinsel ));
449 DESCR("not equal");
450 DATA(insert OID = 645 ( "<" PGNSP PGUID b f f 30 30 16 646 648 oidvectorlt scalarltsel scalarltjoinsel ));
451 DESCR("less than");
452 DATA(insert OID = 646 ( ">" PGNSP PGUID b f f 30 30 16 645 647 oidvectorgt scalargtsel scalargtjoinsel ));
453 DESCR("greater than");
454 DATA(insert OID = 647 ( "<=" PGNSP PGUID b f f 30 30 16 648 646 oidvectorle scalarltsel scalarltjoinsel ));
455 DESCR("less than or equal");
456 DATA(insert OID = 648 ( ">=" PGNSP PGUID b f f 30 30 16 647 645 oidvectorge scalargtsel scalargtjoinsel ));
457 DESCR("greater than or equal");
458 DATA(insert OID = 649 ( "=" PGNSP PGUID b t t 30 30 16 649 644 oidvectoreq eqsel eqjoinsel ));
459 DESCR("equal");
460 
461 DATA(insert OID = 613 ( "<->" PGNSP PGUID b f f 600 628 701 0 0 dist_pl - - ));
462 DESCR("distance between");
463 DATA(insert OID = 614 ( "<->" PGNSP PGUID b f f 600 601 701 0 0 dist_ps - - ));
464 DESCR("distance between");
465 DATA(insert OID = 615 ( "<->" PGNSP PGUID b f f 600 603 701 0 0 dist_pb - - ));
466 DESCR("distance between");
467 DATA(insert OID = 616 ( "<->" PGNSP PGUID b f f 601 628 701 0 0 dist_sl - - ));
468 DESCR("distance between");
469 DATA(insert OID = 617 ( "<->" PGNSP PGUID b f f 601 603 701 0 0 dist_sb - - ));
470 DESCR("distance between");
471 DATA(insert OID = 618 ( "<->" PGNSP PGUID b f f 600 602 701 0 0 dist_ppath - - ));
472 DESCR("distance between");
473 
474 DATA(insert OID = 620 ( "=" PGNSP PGUID b t t 700 700 16 620 621 float4eq eqsel eqjoinsel ));
475 DESCR("equal");
476 DATA(insert OID = 621 ( "<>" PGNSP PGUID b f f 700 700 16 621 620 float4ne neqsel neqjoinsel ));
477 DESCR("not equal");
478 DATA(insert OID = 622 ( "<" PGNSP PGUID b f f 700 700 16 623 625 float4lt scalarltsel scalarltjoinsel ));
479 DESCR("less than");
480 DATA(insert OID = 623 ( ">" PGNSP PGUID b f f 700 700 16 622 624 float4gt scalargtsel scalargtjoinsel ));
481 DESCR("greater than");
482 DATA(insert OID = 624 ( "<=" PGNSP PGUID b f f 700 700 16 625 623 float4le scalarltsel scalarltjoinsel ));
483 DESCR("less than or equal");
484 DATA(insert OID = 625 ( ">=" PGNSP PGUID b f f 700 700 16 624 622 float4ge scalargtsel scalargtjoinsel ));
485 DESCR("greater than or equal");
486 DATA(insert OID = 630 ( "<>" PGNSP PGUID b f f 18 18 16 630 92 charne neqsel neqjoinsel ));
487 DESCR("not equal");
488 
489 DATA(insert OID = 631 ( "<" PGNSP PGUID b f f 18 18 16 633 634 charlt scalarltsel scalarltjoinsel ));
490 DESCR("less than");
491 DATA(insert OID = 632 ( "<=" PGNSP PGUID b f f 18 18 16 634 633 charle scalarltsel scalarltjoinsel ));
492 DESCR("less than or equal");
493 DATA(insert OID = 633 ( ">" PGNSP PGUID b f f 18 18 16 631 632 chargt scalargtsel scalargtjoinsel ));
494 DESCR("greater than");
495 DATA(insert OID = 634 ( ">=" PGNSP PGUID b f f 18 18 16 632 631 charge scalargtsel scalargtjoinsel ));
496 DESCR("greater than or equal");
497 
498 DATA(insert OID = 639 ( "~" PGNSP PGUID b f f 19 25 16 0 640 nameregexeq regexeqsel regexeqjoinsel ));
499 DESCR("matches regular expression, case-sensitive");
500 #define OID_NAME_REGEXEQ_OP 639
501 DATA(insert OID = 640 ( "!~" PGNSP PGUID b f f 19 25 16 0 639 nameregexne regexnesel regexnejoinsel ));
502 DESCR("does not match regular expression, case-sensitive");
503 DATA(insert OID = 641 ( "~" PGNSP PGUID b f f 25 25 16 0 642 textregexeq regexeqsel regexeqjoinsel ));
504 DESCR("matches regular expression, case-sensitive");
505 #define OID_TEXT_REGEXEQ_OP 641
506 DATA(insert OID = 642 ( "!~" PGNSP PGUID b f f 25 25 16 0 641 textregexne regexnesel regexnejoinsel ));
507 DESCR("does not match regular expression, case-sensitive");
508 DATA(insert OID = 643 ( "<>" PGNSP PGUID b f f 19 19 16 643 93 namene neqsel neqjoinsel ));
509 DESCR("not equal");
510 DATA(insert OID = 654 ( "||" PGNSP PGUID b f f 25 25 25 0 0 textcat - - ));
511 DESCR("concatenate");
512 
513 DATA(insert OID = 660 ( "<" PGNSP PGUID b f f 19 19 16 662 663 namelt scalarltsel scalarltjoinsel ));
514 DESCR("less than");
515 DATA(insert OID = 661 ( "<=" PGNSP PGUID b f f 19 19 16 663 662 namele scalarltsel scalarltjoinsel ));
516 DESCR("less than or equal");
517 DATA(insert OID = 662 ( ">" PGNSP PGUID b f f 19 19 16 660 661 namegt scalargtsel scalargtjoinsel ));
518 DESCR("greater than");
519 DATA(insert OID = 663 ( ">=" PGNSP PGUID b f f 19 19 16 661 660 namege scalargtsel scalargtjoinsel ));
520 DESCR("greater than or equal");
521 DATA(insert OID = 664 ( "<" PGNSP PGUID b f f 25 25 16 666 667 text_lt scalarltsel scalarltjoinsel ));
522 DESCR("less than");
523 DATA(insert OID = 665 ( "<=" PGNSP PGUID b f f 25 25 16 667 666 text_le scalarltsel scalarltjoinsel ));
524 DESCR("less than or equal");
525 DATA(insert OID = 666 ( ">" PGNSP PGUID b f f 25 25 16 664 665 text_gt scalargtsel scalargtjoinsel ));
526 DESCR("greater than");
527 DATA(insert OID = 667 ( ">=" PGNSP PGUID b f f 25 25 16 665 664 text_ge scalargtsel scalargtjoinsel ));
528 DESCR("greater than or equal");
529 
530 DATA(insert OID = 670 ( "=" PGNSP PGUID b t t 701 701 16 670 671 float8eq eqsel eqjoinsel ));
531 DESCR("equal");
532 DATA(insert OID = 671 ( "<>" PGNSP PGUID b f f 701 701 16 671 670 float8ne neqsel neqjoinsel ));
533 DESCR("not equal");
534 DATA(insert OID = 672 ( "<" PGNSP PGUID b f f 701 701 16 674 675 float8lt scalarltsel scalarltjoinsel ));
535 DESCR("less than");
536 #define Float8LessOperator 672
537 DATA(insert OID = 673 ( "<=" PGNSP PGUID b f f 701 701 16 675 674 float8le scalarltsel scalarltjoinsel ));
538 DESCR("less than or equal");
539 DATA(insert OID = 674 ( ">" PGNSP PGUID b f f 701 701 16 672 673 float8gt scalargtsel scalargtjoinsel ));
540 DESCR("greater than");
541 DATA(insert OID = 675 ( ">=" PGNSP PGUID b f f 701 701 16 673 672 float8ge scalargtsel scalargtjoinsel ));
542 DESCR("greater than or equal");
543 
544 DATA(insert OID = 682 ( "@" PGNSP PGUID l f f 0 21 21 0 0 int2abs - - ));
545 DESCR("absolute value");
546 DATA(insert OID = 684 ( "+" PGNSP PGUID b f f 20 20 20 684 0 int8pl - - ));
547 DESCR("add");
548 DATA(insert OID = 685 ( "-" PGNSP PGUID b f f 20 20 20 0 0 int8mi - - ));
549 DESCR("subtract");
550 DATA(insert OID = 686 ( "*" PGNSP PGUID b f f 20 20 20 686 0 int8mul - - ));
551 DESCR("multiply");
552 DATA(insert OID = 687 ( "/" PGNSP PGUID b f f 20 20 20 0 0 int8div - - ));
553 DESCR("divide");
554 
555 DATA(insert OID = 688 ( "+" PGNSP PGUID b f f 20 23 20 692 0 int84pl - - ));
556 DESCR("add");
557 DATA(insert OID = 689 ( "-" PGNSP PGUID b f f 20 23 20 0 0 int84mi - - ));
558 DESCR("subtract");
559 DATA(insert OID = 690 ( "*" PGNSP PGUID b f f 20 23 20 694 0 int84mul - - ));
560 DESCR("multiply");
561 DATA(insert OID = 691 ( "/" PGNSP PGUID b f f 20 23 20 0 0 int84div - - ));
562 DESCR("divide");
563 DATA(insert OID = 692 ( "+" PGNSP PGUID b f f 23 20 20 688 0 int48pl - - ));
564 DESCR("add");
565 DATA(insert OID = 693 ( "-" PGNSP PGUID b f f 23 20 20 0 0 int48mi - - ));
566 DESCR("subtract");
567 DATA(insert OID = 694 ( "*" PGNSP PGUID b f f 23 20 20 690 0 int48mul - - ));
568 DESCR("multiply");
569 DATA(insert OID = 695 ( "/" PGNSP PGUID b f f 23 20 20 0 0 int48div - - ));
570 DESCR("divide");
571 
572 DATA(insert OID = 818 ( "+" PGNSP PGUID b f f 20 21 20 822 0 int82pl - - ));
573 DESCR("add");
574 DATA(insert OID = 819 ( "-" PGNSP PGUID b f f 20 21 20 0 0 int82mi - - ));
575 DESCR("subtract");
576 DATA(insert OID = 820 ( "*" PGNSP PGUID b f f 20 21 20 824 0 int82mul - - ));
577 DESCR("multiply");
578 DATA(insert OID = 821 ( "/" PGNSP PGUID b f f 20 21 20 0 0 int82div - - ));
579 DESCR("divide");
580 DATA(insert OID = 822 ( "+" PGNSP PGUID b f f 21 20 20 818 0 int28pl - - ));
581 DESCR("add");
582 DATA(insert OID = 823 ( "-" PGNSP PGUID b f f 21 20 20 0 0 int28mi - - ));
583 DESCR("subtract");
584 DATA(insert OID = 824 ( "*" PGNSP PGUID b f f 21 20 20 820 0 int28mul - - ));
585 DESCR("multiply");
586 DATA(insert OID = 825 ( "/" PGNSP PGUID b f f 21 20 20 0 0 int28div - - ));
587 DESCR("divide");
588 
589 DATA(insert OID = 706 ( "<->" PGNSP PGUID b f f 603 603 701 706 0 box_distance - - ));
590 DESCR("distance between");
591 DATA(insert OID = 707 ( "<->" PGNSP PGUID b f f 602 602 701 707 0 path_distance - - ));
592 DESCR("distance between");
593 DATA(insert OID = 708 ( "<->" PGNSP PGUID b f f 628 628 701 708 0 line_distance - - ));
594 DESCR("distance between");
595 DATA(insert OID = 709 ( "<->" PGNSP PGUID b f f 601 601 701 709 0 lseg_distance - - ));
596 DESCR("distance between");
597 DATA(insert OID = 712 ( "<->" PGNSP PGUID b f f 604 604 701 712 0 poly_distance - - ));
598 DESCR("distance between");
599 
600 DATA(insert OID = 713 ( "<>" PGNSP PGUID b f f 600 600 16 713 510 point_ne neqsel neqjoinsel ));
601 DESCR("not equal");
602 
603 /* add translation/rotation/scaling operators for geometric types. - thomas 97/05/10 */
604 DATA(insert OID = 731 ( "+" PGNSP PGUID b f f 600 600 600 731 0 point_add - - ));
605 DESCR("add points (translate)");
606 DATA(insert OID = 732 ( "-" PGNSP PGUID b f f 600 600 600 0 0 point_sub - - ));
607 DESCR("subtract points (translate)");
608 DATA(insert OID = 733 ( "*" PGNSP PGUID b f f 600 600 600 733 0 point_mul - - ));
609 DESCR("multiply points (scale/rotate)");
610 DATA(insert OID = 734 ( "/" PGNSP PGUID b f f 600 600 600 0 0 point_div - - ));
611 DESCR("divide points (scale/rotate)");
612 DATA(insert OID = 735 ( "+" PGNSP PGUID b f f 602 602 602 735 0 path_add - - ));
613 DESCR("concatenate");
614 DATA(insert OID = 736 ( "+" PGNSP PGUID b f f 602 600 602 0 0 path_add_pt - - ));
615 DESCR("add (translate path)");
616 DATA(insert OID = 737 ( "-" PGNSP PGUID b f f 602 600 602 0 0 path_sub_pt - - ));
617 DESCR("subtract (translate path)");
618 DATA(insert OID = 738 ( "*" PGNSP PGUID b f f 602 600 602 0 0 path_mul_pt - - ));
619 DESCR("multiply (rotate/scale path)");
620 DATA(insert OID = 739 ( "/" PGNSP PGUID b f f 602 600 602 0 0 path_div_pt - - ));
621 DESCR("divide (rotate/scale path)");
622 DATA(insert OID = 755 ( "@>" PGNSP PGUID b f f 602 600 16 512 0 path_contain_pt - - ));
623 DESCR("contains");
624 DATA(insert OID = 756 ( "<@" PGNSP PGUID b f f 600 604 16 757 0 pt_contained_poly contsel contjoinsel ));
625 DESCR("is contained by");
626 DATA(insert OID = 757 ( "@>" PGNSP PGUID b f f 604 600 16 756 0 poly_contain_pt contsel contjoinsel ));
627 DESCR("contains");
628 DATA(insert OID = 758 ( "<@" PGNSP PGUID b f f 600 718 16 759 0 pt_contained_circle contsel contjoinsel ));
629 DESCR("is contained by");
630 DATA(insert OID = 759 ( "@>" PGNSP PGUID b f f 718 600 16 758 0 circle_contain_pt contsel contjoinsel ));
631 DESCR("contains");
632 
633 DATA(insert OID = 773 ( "@" PGNSP PGUID l f f 0 23 23 0 0 int4abs - - ));
634 DESCR("absolute value");
635 
636 /* additional operators for geometric types - thomas 1997-07-09 */
637 DATA(insert OID = 792 ( "=" PGNSP PGUID b f f 602 602 16 792 0 path_n_eq eqsel eqjoinsel ));
638 DESCR("equal");
639 DATA(insert OID = 793 ( "<" PGNSP PGUID b f f 602 602 16 794 0 path_n_lt - - ));
640 DESCR("less than");
641 DATA(insert OID = 794 ( ">" PGNSP PGUID b f f 602 602 16 793 0 path_n_gt - - ));
642 DESCR("greater than");
643 DATA(insert OID = 795 ( "<=" PGNSP PGUID b f f 602 602 16 796 0 path_n_le - - ));
644 DESCR("less than or equal");
645 DATA(insert OID = 796 ( ">=" PGNSP PGUID b f f 602 602 16 795 0 path_n_ge - - ));
646 DESCR("greater than or equal");
647 DATA(insert OID = 797 ( "#" PGNSP PGUID l f f 0 602 23 0 0 path_npoints - - ));
648 DESCR("number of points");
649 DATA(insert OID = 798 ( "?#" PGNSP PGUID b f f 602 602 16 0 0 path_inter - - ));
650 DESCR("intersect");
651 DATA(insert OID = 799 ( "@-@" PGNSP PGUID l f f 0 602 701 0 0 path_length - - ));
652 DESCR("sum of path segment lengths");
653 DATA(insert OID = 800 ( ">^" PGNSP PGUID b f f 603 603 16 0 0 box_above_eq positionsel positionjoinsel ));
654 DESCR("is above (allows touching)");
655 DATA(insert OID = 801 ( "<^" PGNSP PGUID b f f 603 603 16 0 0 box_below_eq positionsel positionjoinsel ));
656 DESCR("is below (allows touching)");
657 DATA(insert OID = 802 ( "?#" PGNSP PGUID b f f 603 603 16 0 0 box_overlap areasel areajoinsel ));
658 DESCR("deprecated, use && instead");
659 DATA(insert OID = 803 ( "#" PGNSP PGUID b f f 603 603 603 0 0 box_intersect - - ));
660 DESCR("box intersection");
661 DATA(insert OID = 804 ( "+" PGNSP PGUID b f f 603 600 603 0 0 box_add - - ));
662 DESCR("add point to box (translate)");
663 DATA(insert OID = 805 ( "-" PGNSP PGUID b f f 603 600 603 0 0 box_sub - - ));
664 DESCR("subtract point from box (translate)");
665 DATA(insert OID = 806 ( "*" PGNSP PGUID b f f 603 600 603 0 0 box_mul - - ));
666 DESCR("multiply box by point (scale)");
667 DATA(insert OID = 807 ( "/" PGNSP PGUID b f f 603 600 603 0 0 box_div - - ));
668 DESCR("divide box by point (scale)");
669 DATA(insert OID = 808 ( "?-" PGNSP PGUID b f f 600 600 16 808 0 point_horiz - - ));
670 DESCR("horizontally aligned");
671 DATA(insert OID = 809 ( "?|" PGNSP PGUID b f f 600 600 16 809 0 point_vert - - ));
672 DESCR("vertically aligned");
673 
674 DATA(insert OID = 811 ( "=" PGNSP PGUID b t f 704 704 16 811 812 tintervaleq eqsel eqjoinsel ));
675 DESCR("equal");
676 DATA(insert OID = 812 ( "<>" PGNSP PGUID b f f 704 704 16 812 811 tintervalne neqsel neqjoinsel ));
677 DESCR("not equal");
678 DATA(insert OID = 813 ( "<" PGNSP PGUID b f f 704 704 16 814 816 tintervallt scalarltsel scalarltjoinsel ));
679 DESCR("less than");
680 DATA(insert OID = 814 ( ">" PGNSP PGUID b f f 704 704 16 813 815 tintervalgt scalargtsel scalargtjoinsel ));
681 DESCR("greater than");
682 DATA(insert OID = 815 ( "<=" PGNSP PGUID b f f 704 704 16 816 814 tintervalle scalarltsel scalarltjoinsel ));
683 DESCR("less than or equal");
684 DATA(insert OID = 816 ( ">=" PGNSP PGUID b f f 704 704 16 815 813 tintervalge scalargtsel scalargtjoinsel ));
685 DESCR("greater than or equal");
686 
687 DATA(insert OID = 843 ( "*" PGNSP PGUID b f f 790 700 790 845 0 cash_mul_flt4 - - ));
688 DESCR("multiply");
689 DATA(insert OID = 844 ( "/" PGNSP PGUID b f f 790 700 790 0 0 cash_div_flt4 - - ));
690 DESCR("divide");
691 DATA(insert OID = 845 ( "*" PGNSP PGUID b f f 700 790 790 843 0 flt4_mul_cash - - ));
692 DESCR("multiply");
693 
694 DATA(insert OID = 900 ( "=" PGNSP PGUID b t f 790 790 16 900 901 cash_eq eqsel eqjoinsel ));
695 DESCR("equal");
696 DATA(insert OID = 901 ( "<>" PGNSP PGUID b f f 790 790 16 901 900 cash_ne neqsel neqjoinsel ));
697 DESCR("not equal");
698 DATA(insert OID = 902 ( "<" PGNSP PGUID b f f 790 790 16 903 905 cash_lt scalarltsel scalarltjoinsel ));
699 DESCR("less than");
700 DATA(insert OID = 903 ( ">" PGNSP PGUID b f f 790 790 16 902 904 cash_gt scalargtsel scalargtjoinsel ));
701 DESCR("greater than");
702 DATA(insert OID = 904 ( "<=" PGNSP PGUID b f f 790 790 16 905 903 cash_le scalarltsel scalarltjoinsel ));
703 DESCR("less than or equal");
704 DATA(insert OID = 905 ( ">=" PGNSP PGUID b f f 790 790 16 904 902 cash_ge scalargtsel scalargtjoinsel ));
705 DESCR("greater than or equal");
706 DATA(insert OID = 906 ( "+" PGNSP PGUID b f f 790 790 790 906 0 cash_pl - - ));
707 DESCR("add");
708 DATA(insert OID = 907 ( "-" PGNSP PGUID b f f 790 790 790 0 0 cash_mi - - ));
709 DESCR("subtract");
710 DATA(insert OID = 908 ( "*" PGNSP PGUID b f f 790 701 790 916 0 cash_mul_flt8 - - ));
711 DESCR("multiply");
712 DATA(insert OID = 909 ( "/" PGNSP PGUID b f f 790 701 790 0 0 cash_div_flt8 - - ));
713 DESCR("divide");
714 DATA(insert OID = 912 ( "*" PGNSP PGUID b f f 790 23 790 917 0 cash_mul_int4 - - ));
715 DESCR("multiply");
716 DATA(insert OID = 913 ( "/" PGNSP PGUID b f f 790 23 790 0 0 cash_div_int4 - - ));
717 DESCR("divide");
718 DATA(insert OID = 914 ( "*" PGNSP PGUID b f f 790 21 790 918 0 cash_mul_int2 - - ));
719 DESCR("multiply");
720 DATA(insert OID = 915 ( "/" PGNSP PGUID b f f 790 21 790 0 0 cash_div_int2 - - ));
721 DESCR("divide");
722 DATA(insert OID = 916 ( "*" PGNSP PGUID b f f 701 790 790 908 0 flt8_mul_cash - - ));
723 DESCR("multiply");
724 DATA(insert OID = 917 ( "*" PGNSP PGUID b f f 23 790 790 912 0 int4_mul_cash - - ));
725 DESCR("multiply");
726 DATA(insert OID = 918 ( "*" PGNSP PGUID b f f 21 790 790 914 0 int2_mul_cash - - ));
727 DESCR("multiply");
728 DATA(insert OID = 3825 ( "/" PGNSP PGUID b f f 790 790 701 0 0 cash_div_cash - - ));
729 DESCR("divide");
730 
731 DATA(insert OID = 965 ( "^" PGNSP PGUID b f f 701 701 701 0 0 dpow - - ));
732 DESCR("exponentiation");
733 DATA(insert OID = 966 ( "+" PGNSP PGUID b f f 1034 1033 1034 0 0 aclinsert - - ));
734 DESCR("add/update ACL item");
735 DATA(insert OID = 967 ( "-" PGNSP PGUID b f f 1034 1033 1034 0 0 aclremove - - ));
736 DESCR("remove ACL item");
737 DATA(insert OID = 968 ( "@>" PGNSP PGUID b f f 1034 1033 16 0 0 aclcontains - - ));
738 DESCR("contains");
739 DATA(insert OID = 974 ( "=" PGNSP PGUID b f t 1033 1033 16 974 0 aclitemeq eqsel eqjoinsel ));
740 DESCR("equal");
741 
742 /* additional geometric operators - thomas 1997-07-09 */
743 DATA(insert OID = 969 ( "@@" PGNSP PGUID l f f 0 601 600 0 0 lseg_center - - ));
744 DESCR("center of");
745 DATA(insert OID = 970 ( "@@" PGNSP PGUID l f f 0 602 600 0 0 path_center - - ));
746 DESCR("center of");
747 DATA(insert OID = 971 ( "@@" PGNSP PGUID l f f 0 604 600 0 0 poly_center - - ));
748 DESCR("center of");
749 
750 DATA(insert OID = 1054 ( "=" PGNSP PGUID b t t 1042 1042 16 1054 1057 bpchareq eqsel eqjoinsel ));
751 DESCR("equal");
752 
753 DATA(insert OID = 1055 ( "~" PGNSP PGUID b f f 1042 25 16 0 1056 bpcharregexeq regexeqsel regexeqjoinsel ));
754 DESCR("matches regular expression, case-sensitive");
755 #define OID_BPCHAR_REGEXEQ_OP 1055
756 DATA(insert OID = 1056 ( "!~" PGNSP PGUID b f f 1042 25 16 0 1055 bpcharregexne regexnesel regexnejoinsel ));
757 DESCR("does not match regular expression, case-sensitive");
758 DATA(insert OID = 1057 ( "<>" PGNSP PGUID b f f 1042 1042 16 1057 1054 bpcharne neqsel neqjoinsel ));
759 DESCR("not equal");
760 DATA(insert OID = 1058 ( "<" PGNSP PGUID b f f 1042 1042 16 1060 1061 bpcharlt scalarltsel scalarltjoinsel ));
761 DESCR("less than");
762 DATA(insert OID = 1059 ( "<=" PGNSP PGUID b f f 1042 1042 16 1061 1060 bpcharle scalarltsel scalarltjoinsel ));
763 DESCR("less than or equal");
764 DATA(insert OID = 1060 ( ">" PGNSP PGUID b f f 1042 1042 16 1058 1059 bpchargt scalargtsel scalargtjoinsel ));
765 DESCR("greater than");
766 DATA(insert OID = 1061 ( ">=" PGNSP PGUID b f f 1042 1042 16 1059 1058 bpcharge scalargtsel scalargtjoinsel ));
767 DESCR("greater than or equal");
768 
769 /* generic array comparison operators */
770 DATA(insert OID = 1070 ( "=" PGNSP PGUID b t t 2277 2277 16 1070 1071 array_eq eqsel eqjoinsel ));
771 DESCR("equal");
772 #define ARRAY_EQ_OP 1070
773 DATA(insert OID = 1071 ( "<>" PGNSP PGUID b f f 2277 2277 16 1071 1070 array_ne neqsel neqjoinsel ));
774 DESCR("not equal");
775 DATA(insert OID = 1072 ( "<" PGNSP PGUID b f f 2277 2277 16 1073 1075 array_lt scalarltsel scalarltjoinsel ));
776 DESCR("less than");
777 #define ARRAY_LT_OP 1072
778 DATA(insert OID = 1073 ( ">" PGNSP PGUID b f f 2277 2277 16 1072 1074 array_gt scalargtsel scalargtjoinsel ));
779 DESCR("greater than");
780 #define ARRAY_GT_OP 1073
781 DATA(insert OID = 1074 ( "<=" PGNSP PGUID b f f 2277 2277 16 1075 1073 array_le scalarltsel scalarltjoinsel ));
782 DESCR("less than or equal");
783 DATA(insert OID = 1075 ( ">=" PGNSP PGUID b f f 2277 2277 16 1074 1072 array_ge scalargtsel scalargtjoinsel ));
784 DESCR("greater than or equal");
785 
786 /* date operators */
787 DATA(insert OID = 1076 ( "+" PGNSP PGUID b f f 1082 1186 1114 2551 0 date_pl_interval - - ));
788 DESCR("add");
789 DATA(insert OID = 1077 ( "-" PGNSP PGUID b f f 1082 1186 1114 0 0 date_mi_interval - - ));
790 DESCR("subtract");
791 DATA(insert OID = 1093 ( "=" PGNSP PGUID b t t 1082 1082 16 1093 1094 date_eq eqsel eqjoinsel ));
792 DESCR("equal");
793 DATA(insert OID = 1094 ( "<>" PGNSP PGUID b f f 1082 1082 16 1094 1093 date_ne neqsel neqjoinsel ));
794 DESCR("not equal");
795 DATA(insert OID = 1095 ( "<" PGNSP PGUID b f f 1082 1082 16 1097 1098 date_lt scalarltsel scalarltjoinsel ));
796 DESCR("less than");
797 DATA(insert OID = 1096 ( "<=" PGNSP PGUID b f f 1082 1082 16 1098 1097 date_le scalarltsel scalarltjoinsel ));
798 DESCR("less than or equal");
799 DATA(insert OID = 1097 ( ">" PGNSP PGUID b f f 1082 1082 16 1095 1096 date_gt scalargtsel scalargtjoinsel ));
800 DESCR("greater than");
801 DATA(insert OID = 1098 ( ">=" PGNSP PGUID b f f 1082 1082 16 1096 1095 date_ge scalargtsel scalargtjoinsel ));
802 DESCR("greater than or equal");
803 DATA(insert OID = 1099 ( "-" PGNSP PGUID b f f 1082 1082 23 0 0 date_mi - - ));
804 DESCR("subtract");
805 DATA(insert OID = 1100 ( "+" PGNSP PGUID b f f 1082 23 1082 2555 0 date_pli - - ));
806 DESCR("add");
807 DATA(insert OID = 1101 ( "-" PGNSP PGUID b f f 1082 23 1082 0 0 date_mii - - ));
808 DESCR("subtract");
809 
810 /* time operators */
811 DATA(insert OID = 1108 ( "=" PGNSP PGUID b t t 1083 1083 16 1108 1109 time_eq eqsel eqjoinsel ));
812 DESCR("equal");
813 DATA(insert OID = 1109 ( "<>" PGNSP PGUID b f f 1083 1083 16 1109 1108 time_ne neqsel neqjoinsel ));
814 DESCR("not equal");
815 DATA(insert OID = 1110 ( "<" PGNSP PGUID b f f 1083 1083 16 1112 1113 time_lt scalarltsel scalarltjoinsel ));
816 DESCR("less than");
817 DATA(insert OID = 1111 ( "<=" PGNSP PGUID b f f 1083 1083 16 1113 1112 time_le scalarltsel scalarltjoinsel ));
818 DESCR("less than or equal");
819 DATA(insert OID = 1112 ( ">" PGNSP PGUID b f f 1083 1083 16 1110 1111 time_gt scalargtsel scalargtjoinsel ));
820 DESCR("greater than");
821 DATA(insert OID = 1113 ( ">=" PGNSP PGUID b f f 1083 1083 16 1111 1110 time_ge scalargtsel scalargtjoinsel ));
822 DESCR("greater than or equal");
823 
824 /* timetz operators */
825 DATA(insert OID = 1550 ( "=" PGNSP PGUID b t t 1266 1266 16 1550 1551 timetz_eq eqsel eqjoinsel ));
826 DESCR("equal");
827 DATA(insert OID = 1551 ( "<>" PGNSP PGUID b f f 1266 1266 16 1551 1550 timetz_ne neqsel neqjoinsel ));
828 DESCR("not equal");
829 DATA(insert OID = 1552 ( "<" PGNSP PGUID b f f 1266 1266 16 1554 1555 timetz_lt scalarltsel scalarltjoinsel ));
830 DESCR("less than");
831 DATA(insert OID = 1553 ( "<=" PGNSP PGUID b f f 1266 1266 16 1555 1554 timetz_le scalarltsel scalarltjoinsel ));
832 DESCR("less than or equal");
833 DATA(insert OID = 1554 ( ">" PGNSP PGUID b f f 1266 1266 16 1552 1553 timetz_gt scalargtsel scalargtjoinsel ));
834 DESCR("greater than");
835 DATA(insert OID = 1555 ( ">=" PGNSP PGUID b f f 1266 1266 16 1553 1552 timetz_ge scalargtsel scalargtjoinsel ));
836 DESCR("greater than or equal");
837 
838 /* float48 operators */
839 DATA(insert OID = 1116 ( "+" PGNSP PGUID b f f 700 701 701 1126 0 float48pl - - ));
840 DESCR("add");
841 DATA(insert OID = 1117 ( "-" PGNSP PGUID b f f 700 701 701 0 0 float48mi - - ));
842 DESCR("subtract");
843 DATA(insert OID = 1118 ( "/" PGNSP PGUID b f f 700 701 701 0 0 float48div - - ));
844 DESCR("divide");
845 DATA(insert OID = 1119 ( "*" PGNSP PGUID b f f 700 701 701 1129 0 float48mul - - ));
846 DESCR("multiply");
847 DATA(insert OID = 1120 ( "=" PGNSP PGUID b t t 700 701 16 1130 1121 float48eq eqsel eqjoinsel ));
848 DESCR("equal");
849 DATA(insert OID = 1121 ( "<>" PGNSP PGUID b f f 700 701 16 1131 1120 float48ne neqsel neqjoinsel ));
850 DESCR("not equal");
851 DATA(insert OID = 1122 ( "<" PGNSP PGUID b f f 700 701 16 1133 1125 float48lt scalarltsel scalarltjoinsel ));
852 DESCR("less than");
853 DATA(insert OID = 1123 ( ">" PGNSP PGUID b f f 700 701 16 1132 1124 float48gt scalargtsel scalargtjoinsel ));
854 DESCR("greater than");
855 DATA(insert OID = 1124 ( "<=" PGNSP PGUID b f f 700 701 16 1135 1123 float48le scalarltsel scalarltjoinsel ));
856 DESCR("less than or equal");
857 DATA(insert OID = 1125 ( ">=" PGNSP PGUID b f f 700 701 16 1134 1122 float48ge scalargtsel scalargtjoinsel ));
858 DESCR("greater than or equal");
859 
860 /* float84 operators */
861 DATA(insert OID = 1126 ( "+" PGNSP PGUID b f f 701 700 701 1116 0 float84pl - - ));
862 DESCR("add");
863 DATA(insert OID = 1127 ( "-" PGNSP PGUID b f f 701 700 701 0 0 float84mi - - ));
864 DESCR("subtract");
865 DATA(insert OID = 1128 ( "/" PGNSP PGUID b f f 701 700 701 0 0 float84div - - ));
866 DESCR("divide");
867 DATA(insert OID = 1129 ( "*" PGNSP PGUID b f f 701 700 701 1119 0 float84mul - - ));
868 DESCR("multiply");
869 DATA(insert OID = 1130 ( "=" PGNSP PGUID b t t 701 700 16 1120 1131 float84eq eqsel eqjoinsel ));
870 DESCR("equal");
871 DATA(insert OID = 1131 ( "<>" PGNSP PGUID b f f 701 700 16 1121 1130 float84ne neqsel neqjoinsel ));
872 DESCR("not equal");
873 DATA(insert OID = 1132 ( "<" PGNSP PGUID b f f 701 700 16 1123 1135 float84lt scalarltsel scalarltjoinsel ));
874 DESCR("less than");
875 DATA(insert OID = 1133 ( ">" PGNSP PGUID b f f 701 700 16 1122 1134 float84gt scalargtsel scalargtjoinsel ));
876 DESCR("greater than");
877 DATA(insert OID = 1134 ( "<=" PGNSP PGUID b f f 701 700 16 1125 1133 float84le scalarltsel scalarltjoinsel ));
878 DESCR("less than or equal");
879 DATA(insert OID = 1135 ( ">=" PGNSP PGUID b f f 701 700 16 1124 1132 float84ge scalargtsel scalargtjoinsel ));
880 DESCR("greater than or equal");
881 
882 
883 /* LIKE hacks by Keith Parks. */
884 DATA(insert OID = 1207 ( "~~" PGNSP PGUID b f f 19 25 16 0 1208 namelike likesel likejoinsel ));
885 DESCR("matches LIKE expression");
886 #define OID_NAME_LIKE_OP 1207
887 DATA(insert OID = 1208 ( "!~~" PGNSP PGUID b f f 19 25 16 0 1207 namenlike nlikesel nlikejoinsel ));
888 DESCR("does not match LIKE expression");
889 DATA(insert OID = 1209 ( "~~" PGNSP PGUID b f f 25 25 16 0 1210 textlike likesel likejoinsel ));
890 DESCR("matches LIKE expression");
891 #define OID_TEXT_LIKE_OP 1209
892 DATA(insert OID = 1210 ( "!~~" PGNSP PGUID b f f 25 25 16 0 1209 textnlike nlikesel nlikejoinsel ));
893 DESCR("does not match LIKE expression");
894 DATA(insert OID = 1211 ( "~~" PGNSP PGUID b f f 1042 25 16 0 1212 bpcharlike likesel likejoinsel ));
895 DESCR("matches LIKE expression");
896 #define OID_BPCHAR_LIKE_OP 1211
897 DATA(insert OID = 1212 ( "!~~" PGNSP PGUID b f f 1042 25 16 0 1211 bpcharnlike nlikesel nlikejoinsel ));
898 DESCR("does not match LIKE expression");
899 
900 /* case-insensitive regex hacks */
901 DATA(insert OID = 1226 ( "~*" PGNSP PGUID b f f 19 25 16 0 1227 nameicregexeq icregexeqsel icregexeqjoinsel ));
902 DESCR("matches regular expression, case-insensitive");
903 #define OID_NAME_ICREGEXEQ_OP 1226
904 DATA(insert OID = 1227 ( "!~*" PGNSP PGUID b f f 19 25 16 0 1226 nameicregexne icregexnesel icregexnejoinsel ));
905 DESCR("does not match regular expression, case-insensitive");
906 DATA(insert OID = 1228 ( "~*" PGNSP PGUID b f f 25 25 16 0 1229 texticregexeq icregexeqsel icregexeqjoinsel ));
907 DESCR("matches regular expression, case-insensitive");
908 #define OID_TEXT_ICREGEXEQ_OP 1228
909 DATA(insert OID = 1229 ( "!~*" PGNSP PGUID b f f 25 25 16 0 1228 texticregexne icregexnesel icregexnejoinsel ));
910 DESCR("does not match regular expression, case-insensitive");
911 DATA(insert OID = 1234 ( "~*" PGNSP PGUID b f f 1042 25 16 0 1235 bpcharicregexeq icregexeqsel icregexeqjoinsel ));
912 DESCR("matches regular expression, case-insensitive");
913 #define OID_BPCHAR_ICREGEXEQ_OP 1234
914 DATA(insert OID = 1235 ( "!~*" PGNSP PGUID b f f 1042 25 16 0 1234 bpcharicregexne icregexnesel icregexnejoinsel ));
915 DESCR("does not match regular expression, case-insensitive");
916 
917 /* timestamptz operators */
918 DATA(insert OID = 1320 ( "=" PGNSP PGUID b t t 1184 1184 16 1320 1321 timestamptz_eq eqsel eqjoinsel ));
919 DESCR("equal");
920 DATA(insert OID = 1321 ( "<>" PGNSP PGUID b f f 1184 1184 16 1321 1320 timestamptz_ne neqsel neqjoinsel ));
921 DESCR("not equal");
922 DATA(insert OID = 1322 ( "<" PGNSP PGUID b f f 1184 1184 16 1324 1325 timestamptz_lt scalarltsel scalarltjoinsel ));
923 DESCR("less than");
924 DATA(insert OID = 1323 ( "<=" PGNSP PGUID b f f 1184 1184 16 1325 1324 timestamptz_le scalarltsel scalarltjoinsel ));
925 DESCR("less than or equal");
926 DATA(insert OID = 1324 ( ">" PGNSP PGUID b f f 1184 1184 16 1322 1323 timestamptz_gt scalargtsel scalargtjoinsel ));
927 DESCR("greater than");
928 DATA(insert OID = 1325 ( ">=" PGNSP PGUID b f f 1184 1184 16 1323 1322 timestamptz_ge scalargtsel scalargtjoinsel ));
929 DESCR("greater than or equal");
930 DATA(insert OID = 1327 ( "+" PGNSP PGUID b f f 1184 1186 1184 2554 0 timestamptz_pl_interval - - ));
931 DESCR("add");
932 DATA(insert OID = 1328 ( "-" PGNSP PGUID b f f 1184 1184 1186 0 0 timestamptz_mi - - ));
933 DESCR("subtract");
934 DATA(insert OID = 1329 ( "-" PGNSP PGUID b f f 1184 1186 1184 0 0 timestamptz_mi_interval - - ));
935 DESCR("subtract");
936 
937 /* interval operators */
938 DATA(insert OID = 1330 ( "=" PGNSP PGUID b t t 1186 1186 16 1330 1331 interval_eq eqsel eqjoinsel ));
939 DESCR("equal");
940 DATA(insert OID = 1331 ( "<>" PGNSP PGUID b f f 1186 1186 16 1331 1330 interval_ne neqsel neqjoinsel ));
941 DESCR("not equal");
942 DATA(insert OID = 1332 ( "<" PGNSP PGUID b f f 1186 1186 16 1334 1335 interval_lt scalarltsel scalarltjoinsel ));
943 DESCR("less than");
944 DATA(insert OID = 1333 ( "<=" PGNSP PGUID b f f 1186 1186 16 1335 1334 interval_le scalarltsel scalarltjoinsel ));
945 DESCR("less than or equal");
946 DATA(insert OID = 1334 ( ">" PGNSP PGUID b f f 1186 1186 16 1332 1333 interval_gt scalargtsel scalargtjoinsel ));
947 DESCR("greater than");
948 DATA(insert OID = 1335 ( ">=" PGNSP PGUID b f f 1186 1186 16 1333 1332 interval_ge scalargtsel scalargtjoinsel ));
949 DESCR("greater than or equal");
950 
951 DATA(insert OID = 1336 ( "-" PGNSP PGUID l f f 0 1186 1186 0 0 interval_um - - ));
952 DESCR("negate");
953 DATA(insert OID = 1337 ( "+" PGNSP PGUID b f f 1186 1186 1186 1337 0 interval_pl - - ));
954 DESCR("add");
955 DATA(insert OID = 1338 ( "-" PGNSP PGUID b f f 1186 1186 1186 0 0 interval_mi - - ));
956 DESCR("subtract");
957 
958 DATA(insert OID = 1360 ( "+" PGNSP PGUID b f f 1082 1083 1114 1363 0 datetime_pl - - ));
959 DESCR("convert date and time to timestamp");
960 DATA(insert OID = 1361 ( "+" PGNSP PGUID b f f 1082 1266 1184 1366 0 datetimetz_pl - - ));
961 DESCR("convert date and time with time zone to timestamp with time zone");
962 DATA(insert OID = 1363 ( "+" PGNSP PGUID b f f 1083 1082 1114 1360 0 timedate_pl - - ));
963 DESCR("convert time and date to timestamp");
964 DATA(insert OID = 1366 ( "+" PGNSP PGUID b f f 1266 1082 1184 1361 0 timetzdate_pl - - ));
965 DESCR("convert time with time zone and date to timestamp with time zone");
966 
967 DATA(insert OID = 1399 ( "-" PGNSP PGUID b f f 1083 1083 1186 0 0 time_mi_time - - ));
968 DESCR("subtract");
969 
970 /* additional geometric operators - thomas 97/04/18 */
971 DATA(insert OID = 1420 ( "@@" PGNSP PGUID l f f 0 718 600 0 0 circle_center - - ));
972 DESCR("center of");
973 DATA(insert OID = 1500 ( "=" PGNSP PGUID b f f 718 718 16 1500 1501 circle_eq eqsel eqjoinsel ));
974 DESCR("equal by area");
975 DATA(insert OID = 1501 ( "<>" PGNSP PGUID b f f 718 718 16 1501 1500 circle_ne neqsel neqjoinsel ));
976 DESCR("not equal by area");
977 DATA(insert OID = 1502 ( "<" PGNSP PGUID b f f 718 718 16 1503 1505 circle_lt areasel areajoinsel ));
978 DESCR("less than by area");
979 DATA(insert OID = 1503 ( ">" PGNSP PGUID b f f 718 718 16 1502 1504 circle_gt areasel areajoinsel ));
980 DESCR("greater than by area");
981 DATA(insert OID = 1504 ( "<=" PGNSP PGUID b f f 718 718 16 1505 1503 circle_le areasel areajoinsel ));
982 DESCR("less than or equal by area");
983 DATA(insert OID = 1505 ( ">=" PGNSP PGUID b f f 718 718 16 1504 1502 circle_ge areasel areajoinsel ));
984 DESCR("greater than or equal by area");
985 
986 DATA(insert OID = 1506 ( "<<" PGNSP PGUID b f f 718 718 16 0 0 circle_left positionsel positionjoinsel ));
987 DESCR("is left of");
988 DATA(insert OID = 1507 ( "&<" PGNSP PGUID b f f 718 718 16 0 0 circle_overleft positionsel positionjoinsel ));
989 DESCR("overlaps or is left of");
990 DATA(insert OID = 1508 ( "&>" PGNSP PGUID b f f 718 718 16 0 0 circle_overright positionsel positionjoinsel ));
991 DESCR("overlaps or is right of");
992 DATA(insert OID = 1509 ( ">>" PGNSP PGUID b f f 718 718 16 0 0 circle_right positionsel positionjoinsel ));
993 DESCR("is right of");
994 DATA(insert OID = 1510 ( "<@" PGNSP PGUID b f f 718 718 16 1511 0 circle_contained contsel contjoinsel ));
995 DESCR("is contained by");
996 DATA(insert OID = 1511 ( "@>" PGNSP PGUID b f f 718 718 16 1510 0 circle_contain contsel contjoinsel ));
997 DESCR("contains");
998 DATA(insert OID = 1512 ( "~=" PGNSP PGUID b f f 718 718 16 1512 0 circle_same eqsel eqjoinsel ));
999 DESCR("same as");
1000 DATA(insert OID = 1513 ( "&&" PGNSP PGUID b f f 718 718 16 1513 0 circle_overlap areasel areajoinsel ));
1001 DESCR("overlaps");
1002 DATA(insert OID = 1514 ( "|>>" PGNSP PGUID b f f 718 718 16 0 0 circle_above positionsel positionjoinsel ));
1003 DESCR("is above");
1004 DATA(insert OID = 1515 ( "<<|" PGNSP PGUID b f f 718 718 16 0 0 circle_below positionsel positionjoinsel ));
1005 DESCR("is below");
1006 
1007 DATA(insert OID = 1516 ( "+" PGNSP PGUID b f f 718 600 718 0 0 circle_add_pt - - ));
1008 DESCR("add");
1009 DATA(insert OID = 1517 ( "-" PGNSP PGUID b f f 718 600 718 0 0 circle_sub_pt - - ));
1010 DESCR("subtract");
1011 DATA(insert OID = 1518 ( "*" PGNSP PGUID b f f 718 600 718 0 0 circle_mul_pt - - ));
1012 DESCR("multiply");
1013 DATA(insert OID = 1519 ( "/" PGNSP PGUID b f f 718 600 718 0 0 circle_div_pt - - ));
1014 DESCR("divide");
1015 
1016 DATA(insert OID = 1520 ( "<->" PGNSP PGUID b f f 718 718 701 1520 0 circle_distance - - ));
1017 DESCR("distance between");
1018 DATA(insert OID = 1521 ( "#" PGNSP PGUID l f f 0 604 23 0 0 poly_npoints - - ));
1019 DESCR("number of points");
1020 DATA(insert OID = 1522 ( "<->" PGNSP PGUID b f f 600 718 701 3291 0 dist_pc - - ));
1021 DESCR("distance between");
1022 DATA(insert OID = 3291 ( "<->" PGNSP PGUID b f f 718 600 701 1522 0 dist_cpoint - - ));
1023 DESCR("distance between");
1024 DATA(insert OID = 3276 ( "<->" PGNSP PGUID b f f 600 604 701 3289 0 dist_ppoly - - ));
1025 DESCR("distance between");
1026 DATA(insert OID = 3289 ( "<->" PGNSP PGUID b f f 604 600 701 3276 0 dist_polyp - - ));
1027 DESCR("distance between");
1028 DATA(insert OID = 1523 ( "<->" PGNSP PGUID b f f 718 604 701 0 0 dist_cpoly - - ));
1029 DESCR("distance between");
1030 
1031 /* additional geometric operators - thomas 1997-07-09 */
1032 DATA(insert OID = 1524 ( "<->" PGNSP PGUID b f f 628 603 701 0 0 dist_lb - - ));
1033 DESCR("distance between");
1034 
1035 DATA(insert OID = 1525 ( "?#" PGNSP PGUID b f f 601 601 16 1525 0 lseg_intersect - - ));
1036 DESCR("intersect");
1037 DATA(insert OID = 1526 ( "?||" PGNSP PGUID b f f 601 601 16 1526 0 lseg_parallel - - ));
1038 DESCR("parallel");
1039 DATA(insert OID = 1527 ( "?-|" PGNSP PGUID b f f 601 601 16 1527 0 lseg_perp - - ));
1040 DESCR("perpendicular");
1041 DATA(insert OID = 1528 ( "?-" PGNSP PGUID l f f 0 601 16 0 0 lseg_horizontal - - ));
1042 DESCR("horizontal");
1043 DATA(insert OID = 1529 ( "?|" PGNSP PGUID l f f 0 601 16 0 0 lseg_vertical - - ));
1044 DESCR("vertical");
1045 DATA(insert OID = 1535 ( "=" PGNSP PGUID b f f 601 601 16 1535 1586 lseg_eq eqsel eqjoinsel ));
1046 DESCR("equal");
1047 DATA(insert OID = 1536 ( "#" PGNSP PGUID b f f 601 601 600 1536 0 lseg_interpt - - ));
1048 DESCR("intersection point");
1049 DATA(insert OID = 1537 ( "?#" PGNSP PGUID b f f 601 628 16 0 0 inter_sl - - ));
1050 DESCR("intersect");
1051 DATA(insert OID = 1538 ( "?#" PGNSP PGUID b f f 601 603 16 0 0 inter_sb - - ));
1052 DESCR("intersect");
1053 DATA(insert OID = 1539 ( "?#" PGNSP PGUID b f f 628 603 16 0 0 inter_lb - - ));
1054 DESCR("intersect");
1055 
1056 DATA(insert OID = 1546 ( "<@" PGNSP PGUID b f f 600 628 16 0 0 on_pl - - ));
1057 DESCR("point on line");
1058 DATA(insert OID = 1547 ( "<@" PGNSP PGUID b f f 600 601 16 0 0 on_ps - - ));
1059 DESCR("is contained by");
1060 DATA(insert OID = 1548 ( "<@" PGNSP PGUID b f f 601 628 16 0 0 on_sl - - ));
1061 DESCR("lseg on line");
1062 DATA(insert OID = 1549 ( "<@" PGNSP PGUID b f f 601 603 16 0 0 on_sb - - ));
1063 DESCR("is contained by");
1064 
1065 DATA(insert OID = 1557 ( "##" PGNSP PGUID b f f 600 628 600 0 0 close_pl - - ));
1066 DESCR("closest point to A on B");
1067 DATA(insert OID = 1558 ( "##" PGNSP PGUID b f f 600 601 600 0 0 close_ps - - ));
1068 DESCR("closest point to A on B");
1069 DATA(insert OID = 1559 ( "##" PGNSP PGUID b f f 600 603 600 0 0 close_pb - - ));
1070 DESCR("closest point to A on B");
1071 
1072 DATA(insert OID = 1566 ( "##" PGNSP PGUID b f f 601 628 600 0 0 close_sl - - ));
1073 DESCR("closest point to A on B");
1074 DATA(insert OID = 1567 ( "##" PGNSP PGUID b f f 601 603 600 0 0 close_sb - - ));
1075 DESCR("closest point to A on B");
1076 DATA(insert OID = 1568 ( "##" PGNSP PGUID b f f 628 603 600 0 0 close_lb - - ));
1077 DESCR("closest point to A on B");
1078 DATA(insert OID = 1577 ( "##" PGNSP PGUID b f f 628 601 600 0 0 close_ls - - ));
1079 DESCR("closest point to A on B");
1080 DATA(insert OID = 1578 ( "##" PGNSP PGUID b f f 601 601 600 0 0 close_lseg - - ));
1081 DESCR("closest point to A on B");
1082 DATA(insert OID = 1583 ( "*" PGNSP PGUID b f f 1186 701 1186 1584 0 interval_mul - - ));
1083 DESCR("multiply");
1084 DATA(insert OID = 1584 ( "*" PGNSP PGUID b f f 701 1186 1186 1583 0 mul_d_interval - - ));
1085 DESCR("multiply");
1086 DATA(insert OID = 1585 ( "/" PGNSP PGUID b f f 1186 701 1186 0 0 interval_div - - ));
1087 DESCR("divide");
1088 
1089 DATA(insert OID = 1586 ( "<>" PGNSP PGUID b f f 601 601 16 1586 1535 lseg_ne neqsel neqjoinsel ));
1090 DESCR("not equal");
1091 DATA(insert OID = 1587 ( "<" PGNSP PGUID b f f 601 601 16 1589 1590 lseg_lt - - ));
1092 DESCR("less than by length");
1093 DATA(insert OID = 1588 ( "<=" PGNSP PGUID b f f 601 601 16 1590 1589 lseg_le - - ));
1094 DESCR("less than or equal by length");
1095 DATA(insert OID = 1589 ( ">" PGNSP PGUID b f f 601 601 16 1587 1588 lseg_gt - - ));
1096 DESCR("greater than by length");
1097 DATA(insert OID = 1590 ( ">=" PGNSP PGUID b f f 601 601 16 1588 1587 lseg_ge - - ));
1098 DESCR("greater than or equal by length");
1099 
1100 DATA(insert OID = 1591 ( "@-@" PGNSP PGUID l f f 0 601 701 0 0 lseg_length - - ));
1101 DESCR("distance between endpoints");
1102 
1103 DATA(insert OID = 1611 ( "?#" PGNSP PGUID b f f 628 628 16 1611 0 line_intersect - - ));
1104 DESCR("intersect");
1105 DATA(insert OID = 1612 ( "?||" PGNSP PGUID b f f 628 628 16 1612 0 line_parallel - - ));
1106 DESCR("parallel");
1107 DATA(insert OID = 1613 ( "?-|" PGNSP PGUID b f f 628 628 16 1613 0 line_perp - - ));
1108 DESCR("perpendicular");
1109 DATA(insert OID = 1614 ( "?-" PGNSP PGUID l f f 0 628 16 0 0 line_horizontal - - ));
1110 DESCR("horizontal");
1111 DATA(insert OID = 1615 ( "?|" PGNSP PGUID l f f 0 628 16 0 0 line_vertical - - ));
1112 DESCR("vertical");
1113 DATA(insert OID = 1616 ( "=" PGNSP PGUID b f f 628 628 16 1616 0 line_eq eqsel eqjoinsel ));
1114 DESCR("equal");
1115 DATA(insert OID = 1617 ( "#" PGNSP PGUID b f f 628 628 600 1617 0 line_interpt - - ));
1116 DESCR("intersection point");
1117 
1118 /* MAC type */
1119 DATA(insert OID = 1220 ( "=" PGNSP PGUID b t t 829 829 16 1220 1221 macaddr_eq eqsel eqjoinsel ));
1120 DESCR("equal");
1121 DATA(insert OID = 1221 ( "<>" PGNSP PGUID b f f 829 829 16 1221 1220 macaddr_ne neqsel neqjoinsel ));
1122 DESCR("not equal");
1123 DATA(insert OID = 1222 ( "<" PGNSP PGUID b f f 829 829 16 1224 1225 macaddr_lt scalarltsel scalarltjoinsel ));
1124 DESCR("less than");
1125 DATA(insert OID = 1223 ( "<=" PGNSP PGUID b f f 829 829 16 1225 1224 macaddr_le scalarltsel scalarltjoinsel ));
1126 DESCR("less than or equal");
1127 DATA(insert OID = 1224 ( ">" PGNSP PGUID b f f 829 829 16 1222 1223 macaddr_gt scalargtsel scalargtjoinsel ));
1128 DESCR("greater than");
1129 DATA(insert OID = 1225 ( ">=" PGNSP PGUID b f f 829 829 16 1223 1222 macaddr_ge scalargtsel scalargtjoinsel ));
1130 DESCR("greater than or equal");
1131 
1132 DATA(insert OID = 3147 ( "~" PGNSP PGUID l f f 0 829 829 0 0 macaddr_not - - ));
1133 DESCR("bitwise not");
1134 DATA(insert OID = 3148 ( "&" PGNSP PGUID b f f 829 829 829 0 0 macaddr_and - - ));
1135 DESCR("bitwise and");
1136 DATA(insert OID = 3149 ( "|" PGNSP PGUID b f f 829 829 829 0 0 macaddr_or - - ));
1137 DESCR("bitwise or");
1138 
1139 /* INET type (these also support CIDR via implicit cast) */
1140 DATA(insert OID = 1201 ( "=" PGNSP PGUID b t t 869 869 16 1201 1202 network_eq eqsel eqjoinsel ));
1141 DESCR("equal");
1142 DATA(insert OID = 1202 ( "<>" PGNSP PGUID b f f 869 869 16 1202 1201 network_ne neqsel neqjoinsel ));
1143 DESCR("not equal");
1144 DATA(insert OID = 1203 ( "<" PGNSP PGUID b f f 869 869 16 1205 1206 network_lt scalarltsel scalarltjoinsel ));
1145 DESCR("less than");
1146 DATA(insert OID = 1204 ( "<=" PGNSP PGUID b f f 869 869 16 1206 1205 network_le scalarltsel scalarltjoinsel ));
1147 DESCR("less than or equal");
1148 DATA(insert OID = 1205 ( ">" PGNSP PGUID b f f 869 869 16 1203 1204 network_gt scalargtsel scalargtjoinsel ));
1149 DESCR("greater than");
1150 DATA(insert OID = 1206 ( ">=" PGNSP PGUID b f f 869 869 16 1204 1203 network_ge scalargtsel scalargtjoinsel ));
1151 DESCR("greater than or equal");
1152 DATA(insert OID = 931 ( "<<" PGNSP PGUID b f f 869 869 16 933 0 network_sub networksel networkjoinsel ));
1153 DESCR("is subnet");
1154 #define OID_INET_SUB_OP 931
1155 DATA(insert OID = 932 ( "<<=" PGNSP PGUID b f f 869 869 16 934 0 network_subeq networksel networkjoinsel ));
1156 DESCR("is subnet or equal");
1157 #define OID_INET_SUBEQ_OP 932
1158 DATA(insert OID = 933 ( ">>" PGNSP PGUID b f f 869 869 16 931 0 network_sup networksel networkjoinsel ));
1159 DESCR("is supernet");
1160 #define OID_INET_SUP_OP 933
1161 DATA(insert OID = 934 ( ">>=" PGNSP PGUID b f f 869 869 16 932 0 network_supeq networksel networkjoinsel ));
1162 DESCR("is supernet or equal");
1163 #define OID_INET_SUPEQ_OP 934
1164 DATA(insert OID = 3552 ( "&&" PGNSP PGUID b f f 869 869 16 3552 0 network_overlap networksel networkjoinsel ));
1165 DESCR("overlaps (is subnet or supernet)");
1166 #define OID_INET_OVERLAP_OP 3552
1167 
1168 DATA(insert OID = 2634 ( "~" PGNSP PGUID l f f 0 869 869 0 0 inetnot - - ));
1169 DESCR("bitwise not");
1170 DATA(insert OID = 2635 ( "&" PGNSP PGUID b f f 869 869 869 0 0 inetand - - ));
1171 DESCR("bitwise and");
1172 DATA(insert OID = 2636 ( "|" PGNSP PGUID b f f 869 869 869 0 0 inetor - - ));
1173 DESCR("bitwise or");
1174 DATA(insert OID = 2637 ( "+" PGNSP PGUID b f f 869 20 869 2638 0 inetpl - - ));
1175 DESCR("add");
1176 DATA(insert OID = 2638 ( "+" PGNSP PGUID b f f 20 869 869 2637 0 int8pl_inet - - ));
1177 DESCR("add");
1178 DATA(insert OID = 2639 ( "-" PGNSP PGUID b f f 869 20 869 0 0 inetmi_int8 - - ));
1179 DESCR("subtract");
1180 DATA(insert OID = 2640 ( "-" PGNSP PGUID b f f 869 869 20 0 0 inetmi - - ));
1181 DESCR("subtract");
1182 
1183 /* case-insensitive LIKE hacks */
1184 DATA(insert OID = 1625 ( "~~*" PGNSP PGUID b f f 19 25 16 0 1626 nameiclike iclikesel iclikejoinsel ));
1185 DESCR("matches LIKE expression, case-insensitive");
1186 #define OID_NAME_ICLIKE_OP 1625
1187 DATA(insert OID = 1626 ( "!~~*" PGNSP PGUID b f f 19 25 16 0 1625 nameicnlike icnlikesel icnlikejoinsel ));
1188 DESCR("does not match LIKE expression, case-insensitive");
1189 DATA(insert OID = 1627 ( "~~*" PGNSP PGUID b f f 25 25 16 0 1628 texticlike iclikesel iclikejoinsel ));
1190 DESCR("matches LIKE expression, case-insensitive");
1191 #define OID_TEXT_ICLIKE_OP 1627
1192 DATA(insert OID = 1628 ( "!~~*" PGNSP PGUID b f f 25 25 16 0 1627 texticnlike icnlikesel icnlikejoinsel ));
1193 DESCR("does not match LIKE expression, case-insensitive");
1194 DATA(insert OID = 1629 ( "~~*" PGNSP PGUID b f f 1042 25 16 0 1630 bpchariclike iclikesel iclikejoinsel ));
1195 DESCR("matches LIKE expression, case-insensitive");
1196 #define OID_BPCHAR_ICLIKE_OP 1629
1197 DATA(insert OID = 1630 ( "!~~*" PGNSP PGUID b f f 1042 25 16 0 1629 bpcharicnlike icnlikesel icnlikejoinsel ));
1198 DESCR("does not match LIKE expression, case-insensitive");
1199 
1200 /* NUMERIC type - OID's 1700-1799 */
1201 DATA(insert OID = 1751 ( "-" PGNSP PGUID l f f 0 1700 1700 0 0 numeric_uminus - - ));
1202 DESCR("negate");
1203 DATA(insert OID = 1752 ( "=" PGNSP PGUID b t t 1700 1700 16 1752 1753 numeric_eq eqsel eqjoinsel ));
1204 DESCR("equal");
1205 DATA(insert OID = 1753 ( "<>" PGNSP PGUID b f f 1700 1700 16 1753 1752 numeric_ne neqsel neqjoinsel ));
1206 DESCR("not equal");
1207 DATA(insert OID = 1754 ( "<" PGNSP PGUID b f f 1700 1700 16 1756 1757 numeric_lt scalarltsel scalarltjoinsel ));
1208 DESCR("less than");
1209 DATA(insert OID = 1755 ( "<=" PGNSP PGUID b f f 1700 1700 16 1757 1756 numeric_le scalarltsel scalarltjoinsel ));
1210 DESCR("less than or equal");
1211 DATA(insert OID = 1756 ( ">" PGNSP PGUID b f f 1700 1700 16 1754 1755 numeric_gt scalargtsel scalargtjoinsel ));
1212 DESCR("greater than");
1213 DATA(insert OID = 1757 ( ">=" PGNSP PGUID b f f 1700 1700 16 1755 1754 numeric_ge scalargtsel scalargtjoinsel ));
1214 DESCR("greater than or equal");
1215 DATA(insert OID = 1758 ( "+" PGNSP PGUID b f f 1700 1700 1700 1758 0 numeric_add - - ));
1216 DESCR("add");
1217 DATA(insert OID = 1759 ( "-" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_sub - - ));
1218 DESCR("subtract");
1219 DATA(insert OID = 1760 ( "*" PGNSP PGUID b f f 1700 1700 1700 1760 0 numeric_mul - - ));
1220 DESCR("multiply");
1221 DATA(insert OID = 1761 ( "/" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_div - - ));
1222 DESCR("divide");
1223 DATA(insert OID = 1762 ( "%" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_mod - - ));
1224 DESCR("modulus");
1225 DATA(insert OID = 1038 ( "^" PGNSP PGUID b f f 1700 1700 1700 0 0 numeric_power - - ));
1226 DESCR("exponentiation");
1227 DATA(insert OID = 1763 ( "@" PGNSP PGUID l f f 0 1700 1700 0 0 numeric_abs - - ));
1228 DESCR("absolute value");
1229 
1230 DATA(insert OID = 1784 ( "=" PGNSP PGUID b t f 1560 1560 16 1784 1785 biteq eqsel eqjoinsel ));
1231 DESCR("equal");
1232 DATA(insert OID = 1785 ( "<>" PGNSP PGUID b f f 1560 1560 16 1785 1784 bitne neqsel neqjoinsel ));
1233 DESCR("not equal");
1234 DATA(insert OID = 1786 ( "<" PGNSP PGUID b f f 1560 1560 16 1787 1789 bitlt scalarltsel scalarltjoinsel ));
1235 DESCR("less than");
1236 DATA(insert OID = 1787 ( ">" PGNSP PGUID b f f 1560 1560 16 1786 1788 bitgt scalargtsel scalargtjoinsel ));
1237 DESCR("greater than");
1238 DATA(insert OID = 1788 ( "<=" PGNSP PGUID b f f 1560 1560 16 1789 1787 bitle scalarltsel scalarltjoinsel ));
1239 DESCR("less than or equal");
1240 DATA(insert OID = 1789 ( ">=" PGNSP PGUID b f f 1560 1560 16 1788 1786 bitge scalargtsel scalargtjoinsel ));
1241 DESCR("greater than or equal");
1242 DATA(insert OID = 1791 ( "&" PGNSP PGUID b f f 1560 1560 1560 1791 0 bitand - - ));
1243 DESCR("bitwise and");
1244 DATA(insert OID = 1792 ( "|" PGNSP PGUID b f f 1560 1560 1560 1792 0 bitor - - ));
1245 DESCR("bitwise or");
1246 DATA(insert OID = 1793 ( "#" PGNSP PGUID b f f 1560 1560 1560 1793 0 bitxor - - ));
1247 DESCR("bitwise exclusive or");
1248 DATA(insert OID = 1794 ( "~" PGNSP PGUID l f f 0 1560 1560 0 0 bitnot - - ));
1249 DESCR("bitwise not");
1250 DATA(insert OID = 1795 ( "<<" PGNSP PGUID b f f 1560 23 1560 0 0 bitshiftleft - - ));
1251 DESCR("bitwise shift left");
1252 DATA(insert OID = 1796 ( ">>" PGNSP PGUID b f f 1560 23 1560 0 0 bitshiftright - - ));
1253 DESCR("bitwise shift right");
1254 DATA(insert OID = 1797 ( "||" PGNSP PGUID b f f 1562 1562 1562 0 0 bitcat - - ));
1255 DESCR("concatenate");
1256 
1257 DATA(insert OID = 1800 ( "+" PGNSP PGUID b f f 1083 1186 1083 1849 0 time_pl_interval - - ));
1258 DESCR("add");
1259 DATA(insert OID = 1801 ( "-" PGNSP PGUID b f f 1083 1186 1083 0 0 time_mi_interval - - ));
1260 DESCR("subtract");
1261 DATA(insert OID = 1802 ( "+" PGNSP PGUID b f f 1266 1186 1266 2552 0 timetz_pl_interval - - ));
1262 DESCR("add");
1263 DATA(insert OID = 1803 ( "-" PGNSP PGUID b f f 1266 1186 1266 0 0 timetz_mi_interval - - ));
1264 DESCR("subtract");
1265 
1266 DATA(insert OID = 1804 ( "=" PGNSP PGUID b t f 1562 1562 16 1804 1805 varbiteq eqsel eqjoinsel ));
1267 DESCR("equal");
1268 DATA(insert OID = 1805 ( "<>" PGNSP PGUID b f f 1562 1562 16 1805 1804 varbitne neqsel neqjoinsel ));
1269 DESCR("not equal");
1270 DATA(insert OID = 1806 ( "<" PGNSP PGUID b f f 1562 1562 16 1807 1809 varbitlt scalarltsel scalarltjoinsel ));
1271 DESCR("less than");
1272 DATA(insert OID = 1807 ( ">" PGNSP PGUID b f f 1562 1562 16 1806 1808 varbitgt scalargtsel scalargtjoinsel ));
1273 DESCR("greater than");
1274 DATA(insert OID = 1808 ( "<=" PGNSP PGUID b f f 1562 1562 16 1809 1807 varbitle scalarltsel scalarltjoinsel ));
1275 DESCR("less than or equal");
1276 DATA(insert OID = 1809 ( ">=" PGNSP PGUID b f f 1562 1562 16 1808 1806 varbitge scalargtsel scalargtjoinsel ));
1277 DESCR("greater than or equal");
1278 
1279 DATA(insert OID = 1849 ( "+" PGNSP PGUID b f f 1186 1083 1083 1800 0 interval_pl_time - - ));
1280 DESCR("add");
1281 
1282 DATA(insert OID = 1862 ( "=" PGNSP PGUID b t t 21 20 16 1868 1863 int28eq eqsel eqjoinsel ));
1283 DESCR("equal");
1284 DATA(insert OID = 1863 ( "<>" PGNSP PGUID b f f 21 20 16 1869 1862 int28ne neqsel neqjoinsel ));
1285 DESCR("not equal");
1286 DATA(insert OID = 1864 ( "<" PGNSP PGUID b f f 21 20 16 1871 1867 int28lt scalarltsel scalarltjoinsel ));
1287 DESCR("less than");
1288 DATA(insert OID = 1865 ( ">" PGNSP PGUID b f f 21 20 16 1870 1866 int28gt scalargtsel scalargtjoinsel ));
1289 DESCR("greater than");
1290 DATA(insert OID = 1866 ( "<=" PGNSP PGUID b f f 21 20 16 1873 1865 int28le scalarltsel scalarltjoinsel ));
1291 DESCR("less than or equal");
1292 DATA(insert OID = 1867 ( ">=" PGNSP PGUID b f f 21 20 16 1872 1864 int28ge scalargtsel scalargtjoinsel ));
1293 DESCR("greater than or equal");
1294 
1295 DATA(insert OID = 1868 ( "=" PGNSP PGUID b t t 20 21 16 1862 1869 int82eq eqsel eqjoinsel ));
1296 DESCR("equal");
1297 DATA(insert OID = 1869 ( "<>" PGNSP PGUID b f f 20 21 16 1863 1868 int82ne neqsel neqjoinsel ));
1298 DESCR("not equal");
1299 DATA(insert OID = 1870 ( "<" PGNSP PGUID b f f 20 21 16 1865 1873 int82lt scalarltsel scalarltjoinsel ));
1300 DESCR("less than");
1301 DATA(insert OID = 1871 ( ">" PGNSP PGUID b f f 20 21 16 1864 1872 int82gt scalargtsel scalargtjoinsel ));
1302 DESCR("greater than");
1303 DATA(insert OID = 1872 ( "<=" PGNSP PGUID b f f 20 21 16 1867 1871 int82le scalarltsel scalarltjoinsel ));
1304 DESCR("less than or equal");
1305 DATA(insert OID = 1873 ( ">=" PGNSP PGUID b f f 20 21 16 1866 1870 int82ge scalargtsel scalargtjoinsel ));
1306 DESCR("greater than or equal");
1307 
1308 DATA(insert OID = 1874 ( "&" PGNSP PGUID b f f 21 21 21 1874 0 int2and - - ));
1309 DESCR("bitwise and");
1310 DATA(insert OID = 1875 ( "|" PGNSP PGUID b f f 21 21 21 1875 0 int2or - - ));
1311 DESCR("bitwise or");
1312 DATA(insert OID = 1876 ( "#" PGNSP PGUID b f f 21 21 21 1876 0 int2xor - - ));
1313 DESCR("bitwise exclusive or");
1314 DATA(insert OID = 1877 ( "~" PGNSP PGUID l f f 0 21 21 0 0 int2not - - ));
1315 DESCR("bitwise not");
1316 DATA(insert OID = 1878 ( "<<" PGNSP PGUID b f f 21 23 21 0 0 int2shl - - ));
1317 DESCR("bitwise shift left");
1318 DATA(insert OID = 1879 ( ">>" PGNSP PGUID b f f 21 23 21 0 0 int2shr - - ));
1319 DESCR("bitwise shift right");
1320 
1321 DATA(insert OID = 1880 ( "&" PGNSP PGUID b f f 23 23 23 1880 0 int4and - - ));
1322 DESCR("bitwise and");
1323 DATA(insert OID = 1881 ( "|" PGNSP PGUID b f f 23 23 23 1881 0 int4or - - ));
1324 DESCR("bitwise or");
1325 DATA(insert OID = 1882 ( "#" PGNSP PGUID b f f 23 23 23 1882 0 int4xor - - ));
1326 DESCR("bitwise exclusive or");
1327 DATA(insert OID = 1883 ( "~" PGNSP PGUID l f f 0 23 23 0 0 int4not - - ));
1328 DESCR("bitwise not");
1329 DATA(insert OID = 1884 ( "<<" PGNSP PGUID b f f 23 23 23 0 0 int4shl - - ));
1330 DESCR("bitwise shift left");
1331 DATA(insert OID = 1885 ( ">>" PGNSP PGUID b f f 23 23 23 0 0 int4shr - - ));
1332 DESCR("bitwise shift right");
1333 
1334 DATA(insert OID = 1886 ( "&" PGNSP PGUID b f f 20 20 20 1886 0 int8and - - ));
1335 DESCR("bitwise and");
1336 DATA(insert OID = 1887 ( "|" PGNSP PGUID b f f 20 20 20 1887 0 int8or - - ));
1337 DESCR("bitwise or");
1338 DATA(insert OID = 1888 ( "#" PGNSP PGUID b f f 20 20 20 1888 0 int8xor - - ));
1339 DESCR("bitwise exclusive or");
1340 DATA(insert OID = 1889 ( "~" PGNSP PGUID l f f 0 20 20 0 0 int8not - - ));
1341 DESCR("bitwise not");
1342 DATA(insert OID = 1890 ( "<<" PGNSP PGUID b f f 20 23 20 0 0 int8shl - - ));
1343 DESCR("bitwise shift left");
1344 DATA(insert OID = 1891 ( ">>" PGNSP PGUID b f f 20 23 20 0 0 int8shr - - ));
1345 DESCR("bitwise shift right");
1346 
1347 DATA(insert OID = 1916 ( "+" PGNSP PGUID l f f 0 20 20 0 0 int8up - - ));
1348 DESCR("unary plus");
1349 DATA(insert OID = 1917 ( "+" PGNSP PGUID l f f 0 21 21 0 0 int2up - - ));
1350 DESCR("unary plus");
1351 DATA(insert OID = 1918 ( "+" PGNSP PGUID l f f 0 23 23 0 0 int4up - - ));
1352 DESCR("unary plus");
1353 DATA(insert OID = 1919 ( "+" PGNSP PGUID l f f 0 700 700 0 0 float4up - - ));
1354 DESCR("unary plus");
1355 DATA(insert OID = 1920 ( "+" PGNSP PGUID l f f 0 701 701 0 0 float8up - - ));
1356 DESCR("unary plus");
1357 DATA(insert OID = 1921 ( "+" PGNSP PGUID l f f 0 1700 1700 0 0 numeric_uplus - - ));
1358 DESCR("unary plus");
1359 
1360 /* bytea operators */
1361 DATA(insert OID = 1955 ( "=" PGNSP PGUID b t t 17 17 16 1955 1956 byteaeq eqsel eqjoinsel ));
1362 DESCR("equal");
1363 DATA(insert OID = 1956 ( "<>" PGNSP PGUID b f f 17 17 16 1956 1955 byteane neqsel neqjoinsel ));
1364 DESCR("not equal");
1365 DATA(insert OID = 1957 ( "<" PGNSP PGUID b f f 17 17 16 1959 1960 bytealt scalarltsel scalarltjoinsel ));
1366 DESCR("less than");
1367 DATA(insert OID = 1958 ( "<=" PGNSP PGUID b f f 17 17 16 1960 1959 byteale scalarltsel scalarltjoinsel ));
1368 DESCR("less than or equal");
1369 DATA(insert OID = 1959 ( ">" PGNSP PGUID b f f 17 17 16 1957 1958 byteagt scalargtsel scalargtjoinsel ));
1370 DESCR("greater than");
1371 DATA(insert OID = 1960 ( ">=" PGNSP PGUID b f f 17 17 16 1958 1957 byteage scalargtsel scalargtjoinsel ));
1372 DESCR("greater than or equal");
1373 
1374 DATA(insert OID = 2016 ( "~~" PGNSP PGUID b f f 17 17 16 0 2017 bytealike likesel likejoinsel ));
1375 DESCR("matches LIKE expression");
1376 #define OID_BYTEA_LIKE_OP 2016
1377 DATA(insert OID = 2017 ( "!~~" PGNSP PGUID b f f 17 17 16 0 2016 byteanlike nlikesel nlikejoinsel ));
1378 DESCR("does not match LIKE expression");
1379 DATA(insert OID = 2018 ( "||" PGNSP PGUID b f f 17 17 17 0 0 byteacat - - ));
1380 DESCR("concatenate");
1381 
1382 /* timestamp operators */
1383 DATA(insert OID = 2060 ( "=" PGNSP PGUID b t t 1114 1114 16 2060 2061 timestamp_eq eqsel eqjoinsel ));
1384 DESCR("equal");
1385 DATA(insert OID = 2061 ( "<>" PGNSP PGUID b f f 1114 1114 16 2061 2060 timestamp_ne neqsel neqjoinsel ));
1386 DESCR("not equal");
1387 DATA(insert OID = 2062 ( "<" PGNSP PGUID b f f 1114 1114 16 2064 2065 timestamp_lt scalarltsel scalarltjoinsel ));
1388 DESCR("less than");
1389 DATA(insert OID = 2063 ( "<=" PGNSP PGUID b f f 1114 1114 16 2065 2064 timestamp_le scalarltsel scalarltjoinsel ));
1390 DESCR("less than or equal");
1391 DATA(insert OID = 2064 ( ">" PGNSP PGUID b f f 1114 1114 16 2062 2063 timestamp_gt scalargtsel scalargtjoinsel ));
1392 DESCR("greater than");
1393 DATA(insert OID = 2065 ( ">=" PGNSP PGUID b f f 1114 1114 16 2063 2062 timestamp_ge scalargtsel scalargtjoinsel ));
1394 DESCR("greater than or equal");
1395 DATA(insert OID = 2066 ( "+" PGNSP PGUID b f f 1114 1186 1114 2553 0 timestamp_pl_interval - - ));
1396 DESCR("add");
1397 DATA(insert OID = 2067 ( "-" PGNSP PGUID b f f 1114 1114 1186 0 0 timestamp_mi - - ));
1398 DESCR("subtract");
1399 DATA(insert OID = 2068 ( "-" PGNSP PGUID b f f 1114 1186 1114 0 0 timestamp_mi_interval - - ));
1400 DESCR("subtract");
1401 
1402 /* character-by-character (not collation order) comparison operators for character types */
1403 
1404 DATA(insert OID = 2314 ( "~<~" PGNSP PGUID b f f 25 25 16 2318 2317 text_pattern_lt scalarltsel scalarltjoinsel ));
1405 DESCR("less than");
1406 DATA(insert OID = 2315 ( "~<=~" PGNSP PGUID b f f 25 25 16 2317 2318 text_pattern_le scalarltsel scalarltjoinsel ));
1407 DESCR("less than or equal");
1408 DATA(insert OID = 2317 ( "~>=~" PGNSP PGUID b f f 25 25 16 2315 2314 text_pattern_ge scalargtsel scalargtjoinsel ));
1409 DESCR("greater than or equal");
1410 DATA(insert OID = 2318 ( "~>~" PGNSP PGUID b f f 25 25 16 2314 2315 text_pattern_gt scalargtsel scalargtjoinsel ));
1411 DESCR("greater than");
1412 
1413 DATA(insert OID = 2326 ( "~<~" PGNSP PGUID b f f 1042 1042 16 2330 2329 bpchar_pattern_lt scalarltsel scalarltjoinsel ));
1414 DESCR("less than");
1415 DATA(insert OID = 2327 ( "~<=~" PGNSP PGUID b f f 1042 1042 16 2329 2330 bpchar_pattern_le scalarltsel scalarltjoinsel ));
1416 DESCR("less than or equal");
1417 DATA(insert OID = 2329 ( "~>=~" PGNSP PGUID b f f 1042 1042 16 2327 2326 bpchar_pattern_ge scalargtsel scalargtjoinsel ));
1418 DESCR("greater than or equal");
1419 DATA(insert OID = 2330 ( "~>~" PGNSP PGUID b f f 1042 1042 16 2326 2327 bpchar_pattern_gt scalargtsel scalargtjoinsel ));
1420 DESCR("greater than");
1421 
1422 /* crosstype operations for date vs. timestamp and timestamptz */
1423 
1424 DATA(insert OID = 2345 ( "<" PGNSP PGUID b f f 1082 1114 16 2375 2348 date_lt_timestamp scalarltsel scalarltjoinsel ));
1425 DESCR("less than");
1426 DATA(insert OID = 2346 ( "<=" PGNSP PGUID b f f 1082 1114 16 2374 2349 date_le_timestamp scalarltsel scalarltjoinsel ));
1427 DESCR("less than or equal");
1428 DATA(insert OID = 2347 ( "=" PGNSP PGUID b t f 1082 1114 16 2373 2350 date_eq_timestamp eqsel eqjoinsel ));
1429 DESCR("equal");
1430 DATA(insert OID = 2348 ( ">=" PGNSP PGUID b f f 1082 1114 16 2372 2345 date_ge_timestamp scalargtsel scalargtjoinsel ));
1431 DESCR("greater than or equal");
1432 DATA(insert OID = 2349 ( ">" PGNSP PGUID b f f 1082 1114 16 2371 2346 date_gt_timestamp scalargtsel scalargtjoinsel ));
1433 DESCR("greater than");
1434 DATA(insert OID = 2350 ( "<>" PGNSP PGUID b f f 1082 1114 16 2376 2347 date_ne_timestamp neqsel neqjoinsel ));
1435 DESCR("not equal");
1436 
1437 DATA(insert OID = 2358 ( "<" PGNSP PGUID b f f 1082 1184 16 2388 2361 date_lt_timestamptz scalarltsel scalarltjoinsel ));
1438 DESCR("less than");
1439 DATA(insert OID = 2359 ( "<=" PGNSP PGUID b f f 1082 1184 16 2387 2362 date_le_timestamptz scalarltsel scalarltjoinsel ));
1440 DESCR("less than or equal");
1441 DATA(insert OID = 2360 ( "=" PGNSP PGUID b t f 1082 1184 16 2386 2363 date_eq_timestamptz eqsel eqjoinsel ));
1442 DESCR("equal");
1443 DATA(insert OID = 2361 ( ">=" PGNSP PGUID b f f 1082 1184 16 2385 2358 date_ge_timestamptz scalargtsel scalargtjoinsel ));
1444 DESCR("greater than or equal");
1445 DATA(insert OID = 2362 ( ">" PGNSP PGUID b f f 1082 1184 16 2384 2359 date_gt_timestamptz scalargtsel scalargtjoinsel ));
1446 DESCR("greater than");
1447 DATA(insert OID = 2363 ( "<>" PGNSP PGUID b f f 1082 1184 16 2389 2360 date_ne_timestamptz neqsel neqjoinsel ));
1448 DESCR("not equal");
1449 
1450 DATA(insert OID = 2371 ( "<" PGNSP PGUID b f f 1114 1082 16 2349 2374 timestamp_lt_date scalarltsel scalarltjoinsel ));
1451 DESCR("less than");
1452 DATA(insert OID = 2372 ( "<=" PGNSP PGUID b f f 1114 1082 16 2348 2375 timestamp_le_date scalarltsel scalarltjoinsel ));
1453 DESCR("less than or equal");
1454 DATA(insert OID = 2373 ( "=" PGNSP PGUID b t f 1114 1082 16 2347 2376 timestamp_eq_date eqsel eqjoinsel ));
1455 DESCR("equal");
1456 DATA(insert OID = 2374 ( ">=" PGNSP PGUID b f f 1114 1082 16 2346 2371 timestamp_ge_date scalargtsel scalargtjoinsel ));
1457 DESCR("greater than or equal");
1458 DATA(insert OID = 2375 ( ">" PGNSP PGUID b f f 1114 1082 16 2345 2372 timestamp_gt_date scalargtsel scalargtjoinsel ));
1459 DESCR("greater than");
1460 DATA(insert OID = 2376 ( "<>" PGNSP PGUID b f f 1114 1082 16 2350 2373 timestamp_ne_date neqsel neqjoinsel ));
1461 DESCR("not equal");
1462 
1463 DATA(insert OID = 2384 ( "<" PGNSP PGUID b f f 1184 1082 16 2362 2387 timestamptz_lt_date scalarltsel scalarltjoinsel ));
1464 DESCR("less than");
1465 DATA(insert OID = 2385 ( "<=" PGNSP PGUID b f f 1184 1082 16 2361 2388 timestamptz_le_date scalarltsel scalarltjoinsel ));
1466 DESCR("less than or equal");
1467 DATA(insert OID = 2386 ( "=" PGNSP PGUID b t f 1184 1082 16 2360 2389 timestamptz_eq_date eqsel eqjoinsel ));
1468 DESCR("equal");
1469 DATA(insert OID = 2387 ( ">=" PGNSP PGUID b f f 1184 1082 16 2359 2384 timestamptz_ge_date scalargtsel scalargtjoinsel ));
1470 DESCR("greater than or equal");
1471 DATA(insert OID = 2388 ( ">" PGNSP PGUID b f f 1184 1082 16 2358 2385 timestamptz_gt_date scalargtsel scalargtjoinsel ));
1472 DESCR("greater than");
1473 DATA(insert OID = 2389 ( "<>" PGNSP PGUID b f f 1184 1082 16 2363 2386 timestamptz_ne_date neqsel neqjoinsel ));
1474 DESCR("not equal");
1475 
1476 /* crosstype operations for timestamp vs. timestamptz */
1477 
1478 DATA(insert OID = 2534 ( "<" PGNSP PGUID b f f 1114 1184 16 2544 2537 timestamp_lt_timestamptz scalarltsel scalarltjoinsel ));
1479 DESCR("less than");
1480 DATA(insert OID = 2535 ( "<=" PGNSP PGUID b f f 1114 1184 16 2543 2538 timestamp_le_timestamptz scalarltsel scalarltjoinsel ));
1481 DESCR("less than or equal");
1482 DATA(insert OID = 2536 ( "=" PGNSP PGUID b t f 1114 1184 16 2542 2539 timestamp_eq_timestamptz eqsel eqjoinsel ));
1483 DESCR("equal");
1484 DATA(insert OID = 2537 ( ">=" PGNSP PGUID b f f 1114 1184 16 2541 2534 timestamp_ge_timestamptz scalargtsel scalargtjoinsel ));
1485 DESCR("greater than or equal");
1486 DATA(insert OID = 2538 ( ">" PGNSP PGUID b f f 1114 1184 16 2540 2535 timestamp_gt_timestamptz scalargtsel scalargtjoinsel ));
1487 DESCR("greater than");
1488 DATA(insert OID = 2539 ( "<>" PGNSP PGUID b f f 1114 1184 16 2545 2536 timestamp_ne_timestamptz neqsel neqjoinsel ));
1489 DESCR("not equal");
1490 
1491 DATA(insert OID = 2540 ( "<" PGNSP PGUID b f f 1184 1114 16 2538 2543 timestamptz_lt_timestamp scalarltsel scalarltjoinsel ));
1492 DESCR("less than");
1493 DATA(insert OID = 2541 ( "<=" PGNSP PGUID b f f 1184 1114 16 2537 2544 timestamptz_le_timestamp scalarltsel scalarltjoinsel ));
1494 DESCR("less than or equal");
1495 DATA(insert OID = 2542 ( "=" PGNSP PGUID b t f 1184 1114 16 2536 2545 timestamptz_eq_timestamp eqsel eqjoinsel ));
1496 DESCR("equal");
1497 DATA(insert OID = 2543 ( ">=" PGNSP PGUID b f f 1184 1114 16 2535 2540 timestamptz_ge_timestamp scalargtsel scalargtjoinsel ));
1498 DESCR("greater than or equal");
1499 DATA(insert OID = 2544 ( ">" PGNSP PGUID b f f 1184 1114 16 2534 2541 timestamptz_gt_timestamp scalargtsel scalargtjoinsel ));
1500 DESCR("greater than");
1501 DATA(insert OID = 2545 ( "<>" PGNSP PGUID b f f 1184 1114 16 2539 2542 timestamptz_ne_timestamp neqsel neqjoinsel ));
1502 DESCR("not equal");
1503 
1504 /* formerly-missing interval + datetime operators */
1505 DATA(insert OID = 2551 ( "+" PGNSP PGUID b f f 1186 1082 1114 1076 0 interval_pl_date - - ));
1506 DESCR("add");
1507 DATA(insert OID = 2552 ( "+" PGNSP PGUID b f f 1186 1266 1266 1802 0 interval_pl_timetz - - ));
1508 DESCR("add");
1509 DATA(insert OID = 2553 ( "+" PGNSP PGUID b f f 1186 1114 1114 2066 0 interval_pl_timestamp - - ));
1510 DESCR("add");
1511 DATA(insert OID = 2554 ( "+" PGNSP PGUID b f f 1186 1184 1184 1327 0 interval_pl_timestamptz - - ));
1512 DESCR("add");
1513 DATA(insert OID = 2555 ( "+" PGNSP PGUID b f f 23 1082 1082 1100 0 integer_pl_date - - ));
1514 DESCR("add");
1515 
1516 /* new operators for Y-direction rtree opfamilies */
1517 DATA(insert OID = 2570 ( "<<|" PGNSP PGUID b f f 603 603 16 0 0 box_below positionsel positionjoinsel ));
1518 DESCR("is below");
1519 DATA(insert OID = 2571 ( "&<|" PGNSP PGUID b f f 603 603 16 0 0 box_overbelow positionsel positionjoinsel ));
1520 DESCR("overlaps or is below");
1521 DATA(insert OID = 2572 ( "|&>" PGNSP PGUID b f f 603 603 16 0 0 box_overabove positionsel positionjoinsel ));
1522 DESCR("overlaps or is above");
1523 DATA(insert OID = 2573 ( "|>>" PGNSP PGUID b f f 603 603 16 0 0 box_above positionsel positionjoinsel ));
1524 DESCR("is above");
1525 DATA(insert OID = 2574 ( "<<|" PGNSP PGUID b f f 604 604 16 0 0 poly_below positionsel positionjoinsel ));
1526 DESCR("is below");
1527 DATA(insert OID = 2575 ( "&<|" PGNSP PGUID b f f 604 604 16 0 0 poly_overbelow positionsel positionjoinsel ));
1528 DESCR("overlaps or is below");
1529 DATA(insert OID = 2576 ( "|&>" PGNSP PGUID b f f 604 604 16 0 0 poly_overabove positionsel positionjoinsel ));
1530 DESCR("overlaps or is above");
1531 DATA(insert OID = 2577 ( "|>>" PGNSP PGUID b f f 604 604 16 0 0 poly_above positionsel positionjoinsel ));
1532 DESCR("is above");
1533 DATA(insert OID = 2589 ( "&<|" PGNSP PGUID b f f 718 718 16 0 0 circle_overbelow positionsel positionjoinsel ));
1534 DESCR("overlaps or is below");
1535 DATA(insert OID = 2590 ( "|&>" PGNSP PGUID b f f 718 718 16 0 0 circle_overabove positionsel positionjoinsel ));
1536 DESCR("overlaps or is above");
1537 
1538 /* overlap/contains/contained for arrays */
1539 DATA(insert OID = 2750 ( "&&" PGNSP PGUID b f f 2277 2277 16 2750 0 arrayoverlap arraycontsel arraycontjoinsel ));
1540 DESCR("overlaps");
1541 #define OID_ARRAY_OVERLAP_OP 2750
1542 DATA(insert OID = 2751 ( "@>" PGNSP PGUID b f f 2277 2277 16 2752 0 arraycontains arraycontsel arraycontjoinsel ));
1543 DESCR("contains");
1544 #define OID_ARRAY_CONTAINS_OP 2751
1545 DATA(insert OID = 2752 ( "<@" PGNSP PGUID b f f 2277 2277 16 2751 0 arraycontained arraycontsel arraycontjoinsel ));
1546 DESCR("is contained by");
1547 #define OID_ARRAY_CONTAINED_OP 2752
1548 
1549 /* capturing operators to preserve pre-8.3 behavior of text concatenation */
1550 DATA(insert OID = 2779 ( "||" PGNSP PGUID b f f 25 2776 25 0 0 textanycat - - ));
1551 DESCR("concatenate");
1552 DATA(insert OID = 2780 ( "||" PGNSP PGUID b f f 2776 25 25 0 0 anytextcat - - ));
1553 DESCR("concatenate");
1554 
1555 /* obsolete names for contains/contained-by operators; remove these someday */
1556 DATA(insert OID = 2860 ( "@" PGNSP PGUID b f f 604 604 16 2861 0 poly_contained contsel contjoinsel ));
1557 DESCR("deprecated, use <@ instead");
1558 DATA(insert OID = 2861 ( "~" PGNSP PGUID b f f 604 604 16 2860 0 poly_contain contsel contjoinsel ));
1559 DESCR("deprecated, use @> instead");
1560 DATA(insert OID = 2862 ( "@" PGNSP PGUID b f f 603 603 16 2863 0 box_contained contsel contjoinsel ));
1561 DESCR("deprecated, use <@ instead");
1562 DATA(insert OID = 2863 ( "~" PGNSP PGUID b f f 603 603 16 2862 0 box_contain contsel contjoinsel ));
1563 DESCR("deprecated, use @> instead");
1564 DATA(insert OID = 2864 ( "@" PGNSP PGUID b f f 718 718 16 2865 0 circle_contained contsel contjoinsel ));
1565 DESCR("deprecated, use <@ instead");
1566 DATA(insert OID = 2865 ( "~" PGNSP PGUID b f f 718 718 16 2864 0 circle_contain contsel contjoinsel ));
1567 DESCR("deprecated, use @> instead");
1568 DATA(insert OID = 2866 ( "@" PGNSP PGUID b f f 600 603 16 0 0 on_pb - - ));
1569 DESCR("deprecated, use <@ instead");
1570 DATA(insert OID = 2867 ( "@" PGNSP PGUID b f f 600 602 16 2868 0 on_ppath - - ));
1571 DESCR("deprecated, use <@ instead");
1572 DATA(insert OID = 2868 ( "~" PGNSP PGUID b f f 602 600 16 2867 0 path_contain_pt - - ));
1573 DESCR("deprecated, use @> instead");
1574 DATA(insert OID = 2869 ( "@" PGNSP PGUID b f f 600 604 16 2870 0 pt_contained_poly - - ));
1575 DESCR("deprecated, use <@ instead");
1576 DATA(insert OID = 2870 ( "~" PGNSP PGUID b f f 604 600 16 2869 0 poly_contain_pt - - ));
1577 DESCR("deprecated, use @> instead");
1578 DATA(insert OID = 2871 ( "@" PGNSP PGUID b f f 600 718 16 2872 0 pt_contained_circle - - ));
1579 DESCR("deprecated, use <@ instead");
1580 DATA(insert OID = 2872 ( "~" PGNSP PGUID b f f 718 600 16 2871 0 circle_contain_pt - - ));
1581 DESCR("deprecated, use @> instead");
1582 DATA(insert OID = 2873 ( "@" PGNSP PGUID b f f 600 628 16 0 0 on_pl - - ));
1583 DESCR("deprecated, use <@ instead");
1584 DATA(insert OID = 2874 ( "@" PGNSP PGUID b f f 600 601 16 0 0 on_ps - - ));
1585 DESCR("deprecated, use <@ instead");
1586 DATA(insert OID = 2875 ( "@" PGNSP PGUID b f f 601 628 16 0 0 on_sl - - ));
1587 DESCR("deprecated, use <@ instead");
1588 DATA(insert OID = 2876 ( "@" PGNSP PGUID b f f 601 603 16 0 0 on_sb - - ));
1589 DESCR("deprecated, use <@ instead");
1590 DATA(insert OID = 2877 ( "~" PGNSP PGUID b f f 1034 1033 16 0 0 aclcontains - - ));
1591 DESCR("deprecated, use @> instead");
1592 
1593 /* uuid operators */
1594 DATA(insert OID = 2972 ( "=" PGNSP PGUID b t t 2950 2950 16 2972 2973 uuid_eq eqsel eqjoinsel ));
1595 DESCR("equal");
1596 DATA(insert OID = 2973 ( "<>" PGNSP PGUID b f f 2950 2950 16 2973 2972 uuid_ne neqsel neqjoinsel ));
1597 DESCR("not equal");
1598 DATA(insert OID = 2974 ( "<" PGNSP PGUID b f f 2950 2950 16 2975 2977 uuid_lt scalarltsel scalarltjoinsel ));
1599 DESCR("less than");
1600 DATA(insert OID = 2975 ( ">" PGNSP PGUID b f f 2950 2950 16 2974 2976 uuid_gt scalargtsel scalargtjoinsel ));
1601 DESCR("greater than");
1602 DATA(insert OID = 2976 ( "<=" PGNSP PGUID b f f 2950 2950 16 2977 2975 uuid_le scalarltsel scalarltjoinsel ));
1603 DESCR("less than or equal");
1604 DATA(insert OID = 2977 ( ">=" PGNSP PGUID b f f 2950 2950 16 2976 2974 uuid_ge scalargtsel scalargtjoinsel ));
1605 DESCR("greater than or equal");
1606 
1607 /* pg_lsn operators */
1608 DATA(insert OID = 3222 ( "=" PGNSP PGUID b t t 3220 3220 16 3222 3223 pg_lsn_eq eqsel eqjoinsel ));
1609 DESCR("equal");
1610 DATA(insert OID = 3223 ( "<>" PGNSP PGUID b f f 3220 3220 16 3223 3222 pg_lsn_ne neqsel neqjoinsel ));
1611 DESCR("not equal");
1612 DATA(insert OID = 3224 ( "<" PGNSP PGUID b f f 3220 3220 16 3225 3227 pg_lsn_lt scalarltsel scalarltjoinsel ));
1613 DESCR("less than");
1614 DATA(insert OID = 3225 ( ">" PGNSP PGUID b f f 3220 3220 16 3224 3226 pg_lsn_gt scalargtsel scalargtjoinsel ));
1615 DESCR("greater than");
1616 DATA(insert OID = 3226 ( "<=" PGNSP PGUID b f f 3220 3220 16 3227 3225 pg_lsn_le scalarltsel scalarltjoinsel ));
1617 DESCR("less than or equal");
1618 DATA(insert OID = 3227 ( ">=" PGNSP PGUID b f f 3220 3220 16 3226 3224 pg_lsn_ge scalargtsel scalargtjoinsel ));
1619 DESCR("greater than or equal");
1620 DATA(insert OID = 3228 ( "-" PGNSP PGUID b f f 3220 3220 1700 0 0 pg_lsn_mi - - ));
1621 DESCR("minus");
1622 
1623 /* enum operators */
1624 DATA(insert OID = 3516 ( "=" PGNSP PGUID b t t 3500 3500 16 3516 3517 enum_eq eqsel eqjoinsel ));
1625 DESCR("equal");
1626 DATA(insert OID = 3517 ( "<>" PGNSP PGUID b f f 3500 3500 16 3517 3516 enum_ne neqsel neqjoinsel ));
1627 DESCR("not equal");
1628 DATA(insert OID = 3518 ( "<" PGNSP PGUID b f f 3500 3500 16 3519 3521 enum_lt scalarltsel scalarltjoinsel ));
1629 DESCR("less than");
1630 DATA(insert OID = 3519 ( ">" PGNSP PGUID b f f 3500 3500 16 3518 3520 enum_gt scalargtsel scalargtjoinsel ));
1631 DESCR("greater than");
1632 DATA(insert OID = 3520 ( "<=" PGNSP PGUID b f f 3500 3500 16 3521 3519 enum_le scalarltsel scalarltjoinsel ));
1633 DESCR("less than or equal");
1634 DATA(insert OID = 3521 ( ">=" PGNSP PGUID b f f 3500 3500 16 3520 3518 enum_ge scalargtsel scalargtjoinsel ));
1635 DESCR("greater than or equal");
1636 
1637 /*
1638  * tsearch operations
1639  */
1640 DATA(insert OID = 3627 ( "<" PGNSP PGUID b f f 3614 3614 16 3632 3631 tsvector_lt scalarltsel scalarltjoinsel ));
1641 DESCR("less than");
1642 DATA(insert OID = 3628 ( "<=" PGNSP PGUID b f f 3614 3614 16 3631 3632 tsvector_le scalarltsel scalarltjoinsel ));
1643 DESCR("less than or equal");
1644 DATA(insert OID = 3629 ( "=" PGNSP PGUID b t f 3614 3614 16 3629 3630 tsvector_eq eqsel eqjoinsel ));
1645 DESCR("equal");
1646 DATA(insert OID = 3630 ( "<>" PGNSP PGUID b f f 3614 3614 16 3630 3629 tsvector_ne neqsel neqjoinsel ));
1647 DESCR("not equal");
1648 DATA(insert OID = 3631 ( ">=" PGNSP PGUID b f f 3614 3614 16 3628 3627 tsvector_ge scalargtsel scalargtjoinsel ));
1649 DESCR("greater than or equal");
1650 DATA(insert OID = 3632 ( ">" PGNSP PGUID b f f 3614 3614 16 3627 3628 tsvector_gt scalargtsel scalargtjoinsel ));
1651 DESCR("greater than");
1652 DATA(insert OID = 3633 ( "||" PGNSP PGUID b f f 3614 3614 3614 0 0 tsvector_concat - - ));
1653 DESCR("concatenate");
1654 DATA(insert OID = 3636 ( "@@" PGNSP PGUID b f f 3614 3615 16 3637 0 ts_match_vq tsmatchsel tsmatchjoinsel ));
1655 DESCR("text search match");
1656 DATA(insert OID = 3637 ( "@@" PGNSP PGUID b f f 3615 3614 16 3636 0 ts_match_qv tsmatchsel tsmatchjoinsel ));
1657 DESCR("text search match");
1658 DATA(insert OID = 3660 ( "@@@" PGNSP PGUID b f f 3614 3615 16 3661 0 ts_match_vq tsmatchsel tsmatchjoinsel ));
1659 DESCR("deprecated, use @@ instead");
1660 DATA(insert OID = 3661 ( "@@@" PGNSP PGUID b f f 3615 3614 16 3660 0 ts_match_qv tsmatchsel tsmatchjoinsel ));
1661 DESCR("deprecated, use @@ instead");
1662 DATA(insert OID = 3674 ( "<" PGNSP PGUID b f f 3615 3615 16 3679 3678 tsquery_lt scalarltsel scalarltjoinsel ));
1663 DESCR("less than");
1664 DATA(insert OID = 3675 ( "<=" PGNSP PGUID b f f 3615 3615 16 3678 3679 tsquery_le scalarltsel scalarltjoinsel ));
1665 DESCR("less than or equal");
1666 DATA(insert OID = 3676 ( "=" PGNSP PGUID b t f 3615 3615 16 3676 3677 tsquery_eq eqsel eqjoinsel ));
1667 DESCR("equal");
1668 DATA(insert OID = 3677 ( "<>" PGNSP PGUID b f f 3615 3615 16 3677 3676 tsquery_ne neqsel neqjoinsel ));
1669 DESCR("not equal");
1670 DATA(insert OID = 3678 ( ">=" PGNSP PGUID b f f 3615 3615 16 3675 3674 tsquery_ge scalargtsel scalargtjoinsel ));
1671 DESCR("greater than or equal");
1672 DATA(insert OID = 3679 ( ">" PGNSP PGUID b f f 3615 3615 16 3674 3675 tsquery_gt scalargtsel scalargtjoinsel ));
1673 DESCR("greater than");
1674 DATA(insert OID = 3680 ( "&&" PGNSP PGUID b f f 3615 3615 3615 0 0 tsquery_and - - ));
1675 DESCR("AND-concatenate");
1676 DATA(insert OID = 3681 ( "||" PGNSP PGUID b f f 3615 3615 3615 0 0 tsquery_or - - ));
1677 DESCR("OR-concatenate");
1678 /* <-> operation calls tsquery_phrase, but function is polymorphic. So, point to OID of the tsquery_phrase */
1679 DATA(insert OID = 5005 ( "<->" PGNSP PGUID b f f 3615 3615 3615 0 0 5003 - - ));
1680 DESCR("phrase-concatenate");
1681 DATA(insert OID = 3682 ( "!!" PGNSP PGUID l f f 0 3615 3615 0 0 tsquery_not - - ));
1682 DESCR("NOT tsquery");
1683 DATA(insert OID = 3693 ( "@>" PGNSP PGUID b f f 3615 3615 16 3694 0 tsq_mcontains contsel contjoinsel ));
1684 DESCR("contains");
1685 DATA(insert OID = 3694 ( "<@" PGNSP PGUID b f f 3615 3615 16 3693 0 tsq_mcontained contsel contjoinsel ));
1686 DESCR("is contained by");
1687 DATA(insert OID = 3762 ( "@@" PGNSP PGUID b f f 25 25 16 0 0 ts_match_tt contsel contjoinsel ));
1688 DESCR("text search match");
1689 DATA(insert OID = 3763 ( "@@" PGNSP PGUID b f f 25 3615 16 0 0 ts_match_tq contsel contjoinsel ));
1690 DESCR("text search match");
1691 
1692 /* generic record comparison operators */
1693 DATA(insert OID = 2988 ( "=" PGNSP PGUID b t f 2249 2249 16 2988 2989 record_eq eqsel eqjoinsel ));
1694 DESCR("equal");
1695 #define RECORD_EQ_OP 2988
1696 DATA(insert OID = 2989 ( "<>" PGNSP PGUID b f f 2249 2249 16 2989 2988 record_ne neqsel neqjoinsel ));
1697 DESCR("not equal");
1698 DATA(insert OID = 2990 ( "<" PGNSP PGUID b f f 2249 2249 16 2991 2993 record_lt scalarltsel scalarltjoinsel ));
1699 DESCR("less than");
1700 #define RECORD_LT_OP 2990
1701 DATA(insert OID = 2991 ( ">" PGNSP PGUID b f f 2249 2249 16 2990 2992 record_gt scalargtsel scalargtjoinsel ));
1702 DESCR("greater than");
1703 #define RECORD_GT_OP 2991
1704 DATA(insert OID = 2992 ( "<=" PGNSP PGUID b f f 2249 2249 16 2993 2991 record_le scalarltsel scalarltjoinsel ));
1705 DESCR("less than or equal");
1706 DATA(insert OID = 2993 ( ">=" PGNSP PGUID b f f 2249 2249 16 2992 2990 record_ge scalargtsel scalargtjoinsel ));
1707 DESCR("greater than or equal");
1708 
1709 /* byte-oriented tests for identical rows and fast sorting */
1710 DATA(insert OID = 3188 ( "*=" PGNSP PGUID b t f 2249 2249 16 3188 3189 record_image_eq eqsel eqjoinsel ));
1711 DESCR("identical");
1712 DATA(insert OID = 3189 ( "*<>" PGNSP PGUID b f f 2249 2249 16 3189 3188 record_image_ne neqsel neqjoinsel ));
1713 DESCR("not identical");
1714 DATA(insert OID = 3190 ( "*<" PGNSP PGUID b f f 2249 2249 16 3191 3193 record_image_lt scalarltsel scalarltjoinsel ));
1715 DESCR("less than");
1716 DATA(insert OID = 3191 ( "*>" PGNSP PGUID b f f 2249 2249 16 3190 3192 record_image_gt scalargtsel scalargtjoinsel ));
1717 DESCR("greater than");
1718 DATA(insert OID = 3192 ( "*<=" PGNSP PGUID b f f 2249 2249 16 3193 3191 record_image_le scalarltsel scalarltjoinsel ));
1719 DESCR("less than or equal");
1720 DATA(insert OID = 3193 ( "*>=" PGNSP PGUID b f f 2249 2249 16 3192 3190 record_image_ge scalargtsel scalargtjoinsel ));
1721 DESCR("greater than or equal");
1722 
1723 /* generic range type operators */
1724 DATA(insert OID = 3882 ( "=" PGNSP PGUID b t t 3831 3831 16 3882 3883 range_eq eqsel eqjoinsel ));
1725 DESCR("equal");
1726 DATA(insert OID = 3883 ( "<>" PGNSP PGUID b f f 3831 3831 16 3883 3882 range_ne neqsel neqjoinsel ));
1727 DESCR("not equal");
1728 DATA(insert OID = 3884 ( "<" PGNSP PGUID b f f 3831 3831 16 3887 3886 range_lt rangesel scalarltjoinsel ));
1729 DESCR("less than");
1730 #define OID_RANGE_LESS_OP 3884
1731 DATA(insert OID = 3885 ( "<=" PGNSP PGUID b f f 3831 3831 16 3886 3887 range_le rangesel scalarltjoinsel ));
1732 DESCR("less than or equal");
1733 #define OID_RANGE_LESS_EQUAL_OP 3885
1734 DATA(insert OID = 3886 ( ">=" PGNSP PGUID b f f 3831 3831 16 3885 3884 range_ge rangesel scalargtjoinsel ));
1735 DESCR("greater than or equal");
1736 #define OID_RANGE_GREATER_EQUAL_OP 3886
1737 DATA(insert OID = 3887 ( ">" PGNSP PGUID b f f 3831 3831 16 3884 3885 range_gt rangesel scalargtjoinsel ));
1738 DESCR("greater than");
1739 #define OID_RANGE_GREATER_OP 3887
1740 DATA(insert OID = 3888 ( "&&" PGNSP PGUID b f f 3831 3831 16 3888 0 range_overlaps rangesel areajoinsel ));
1741 DESCR("overlaps");
1742 #define OID_RANGE_OVERLAP_OP 3888
1743 DATA(insert OID = 3889 ( "@>" PGNSP PGUID b f f 3831 2283 16 3891 0 range_contains_elem rangesel contjoinsel ));
1744 DESCR("contains");
1745 #define OID_RANGE_CONTAINS_ELEM_OP 3889
1746 DATA(insert OID = 3890 ( "@>" PGNSP PGUID b f f 3831 3831 16 3892 0 range_contains rangesel contjoinsel ));
1747 DESCR("contains");
1748 #define OID_RANGE_CONTAINS_OP 3890
1749 DATA(insert OID = 3891 ( "<@" PGNSP PGUID b f f 2283 3831 16 3889 0 elem_contained_by_range rangesel contjoinsel ));
1750 DESCR("is contained by");
1751 #define OID_RANGE_ELEM_CONTAINED_OP 3891
1752 DATA(insert OID = 3892 ( "<@" PGNSP PGUID b f f 3831 3831 16 3890 0 range_contained_by rangesel contjoinsel ));
1753 DESCR("is contained by");
1754 #define OID_RANGE_CONTAINED_OP 3892
1755 DATA(insert OID = 3893 ( "<<" PGNSP PGUID b f f 3831 3831 16 3894 0 range_before rangesel scalarltjoinsel ));
1756 DESCR("is left of");
1757 #define OID_RANGE_LEFT_OP 3893
1758 DATA(insert OID = 3894 ( ">>" PGNSP PGUID b f f 3831 3831 16 3893 0 range_after rangesel scalargtjoinsel ));
1759 DESCR("is right of");
1760 #define OID_RANGE_RIGHT_OP 3894
1761 DATA(insert OID = 3895 ( "&<" PGNSP PGUID b f f 3831 3831 16 0 0 range_overleft rangesel scalarltjoinsel ));
1762 DESCR("overlaps or is left of");
1763 #define OID_RANGE_OVERLAPS_LEFT_OP 3895
1764 DATA(insert OID = 3896 ( "&>" PGNSP PGUID b f f 3831 3831 16 0 0 range_overright rangesel scalargtjoinsel ));
1765 DESCR("overlaps or is right of");
1766 #define OID_RANGE_OVERLAPS_RIGHT_OP 3896
1767 DATA(insert OID = 3897 ( "-|-" PGNSP PGUID b f f 3831 3831 16 3897 0 range_adjacent contsel contjoinsel ));
1768 DESCR("is adjacent to");
1769 DATA(insert OID = 3898 ( "+" PGNSP PGUID b f f 3831 3831 3831 3898 0 range_union - - ));
1770 DESCR("range union");
1771 DATA(insert OID = 3899 ( "-" PGNSP PGUID b f f 3831 3831 3831 0 0 range_minus - - ));
1772 DESCR("range difference");
1773 DATA(insert OID = 3900 ( "*" PGNSP PGUID b f f 3831 3831 3831 3900 0 range_intersect - - ));
1774 DESCR("range intersection");
1775 DATA(insert OID = 3962 ( "->" PGNSP PGUID b f f 114 25 114 0 0 json_object_field - - ));
1776 DESCR("get json object field");
1777 DATA(insert OID = 3963 ( "->>" PGNSP PGUID b f f 114 25 25 0 0 json_object_field_text - - ));
1778 DESCR("get json object field as text");
1779 DATA(insert OID = 3964 ( "->" PGNSP PGUID b f f 114 23 114 0 0 json_array_element - - ));
1780 DESCR("get json array element");
1781 DATA(insert OID = 3965 ( "->>" PGNSP PGUID b f f 114 23 25 0 0 json_array_element_text - - ));
1782 DESCR("get json array element as text");
1783 DATA(insert OID = 3966 ( "#>" PGNSP PGUID b f f 114 1009 114 0 0 json_extract_path - - ));
1784 DESCR("get value from json with path elements");
1785 DATA(insert OID = 3967 ( "#>>" PGNSP PGUID b f f 114 1009 25 0 0 json_extract_path_text - - ));
1786 DESCR("get value from json as text with path elements");
1787 DATA(insert OID = 3211 ( "->" PGNSP PGUID b f f 3802 25 3802 0 0 jsonb_object_field - - ));
1788 DESCR("get jsonb object field");
1789 DATA(insert OID = 3477 ( "->>" PGNSP PGUID b f f 3802 25 25 0 0 jsonb_object_field_text - - ));
1790 DESCR("get jsonb object field as text");
1791 DATA(insert OID = 3212 ( "->" PGNSP PGUID b f f 3802 23 3802 0 0 jsonb_array_element - - ));
1792 DESCR("get jsonb array element");
1793 DATA(insert OID = 3481 ( "->>" PGNSP PGUID b f f 3802 23 25 0 0 jsonb_array_element_text - - ));
1794 DESCR("get jsonb array element as text");
1795 DATA(insert OID = 3213 ( "#>" PGNSP PGUID b f f 3802 1009 3802 0 0 jsonb_extract_path - - ));
1796 DESCR("get value from jsonb with path elements");
1797 DATA(insert OID = 3206 ( "#>>" PGNSP PGUID b f f 3802 1009 25 0 0 jsonb_extract_path_text - - ));
1798 DESCR("get value from jsonb as text with path elements");
1799 DATA(insert OID = 3240 ( "=" PGNSP PGUID b t t 3802 3802 16 3240 3241 jsonb_eq eqsel eqjoinsel ));
1800 DESCR("equal");
1801 DATA(insert OID = 3241 ( "<>" PGNSP PGUID b f f 3802 3802 16 3241 3240 jsonb_ne neqsel neqjoinsel ));
1802 DESCR("not equal");
1803 DATA(insert OID = 3242 ( "<" PGNSP PGUID b f f 3802 3802 16 3243 3245 jsonb_lt scalarltsel scalarltjoinsel ));
1804 DESCR("less than");
1805 DATA(insert OID = 3243 ( ">" PGNSP PGUID b f f 3802 3802 16 3242 3244 jsonb_gt scalargtsel scalargtjoinsel ));
1806 DESCR("greater than");
1807 DATA(insert OID = 3244 ( "<=" PGNSP PGUID b f f 3802 3802 16 3245 3243 jsonb_le scalarltsel scalarltjoinsel ));
1808 DESCR("less than or equal");
1809 DATA(insert OID = 3245 ( ">=" PGNSP PGUID b f f 3802 3802 16 3244 3242 jsonb_ge scalargtsel scalargtjoinsel ));
1810 DESCR("greater than or equal");
1811 DATA(insert OID = 3246 ( "@>" PGNSP PGUID b f f 3802 3802 16 3250 0 jsonb_contains contsel contjoinsel ));
1812 DESCR("contains");
1813 DATA(insert OID = 3247 ( "?" PGNSP PGUID b f f 3802 25 16 0 0 jsonb_exists contsel contjoinsel ));
1814 DESCR("key exists");
1815 DATA(insert OID = 3248 ( "?|" PGNSP PGUID b f f 3802 1009 16 0 0 jsonb_exists_any contsel contjoinsel ));
1816 DESCR("any key exists");
1817 DATA(insert OID = 3249 ( "?&" PGNSP PGUID b f f 3802 1009 16 0 0 jsonb_exists_all contsel contjoinsel ));
1818 DESCR("all keys exist");
1819 DATA(insert OID = 3250 ( "<@" PGNSP PGUID b f f 3802 3802 16 3246 0 jsonb_contained contsel contjoinsel ));
1820 DESCR("is contained by");
1821 DATA(insert OID = 3284 ( "||" PGNSP PGUID b f f 3802 3802 3802 0 0 jsonb_concat - - ));
1822 DESCR("concatenate");
1823 DATA(insert OID = 3285 ( "-" PGNSP PGUID b f f 3802 25 3802 0 0 3302 - - ));
1824 DESCR("delete object field");
1825 DATA(insert OID = 3286 ( "-" PGNSP PGUID b f f 3802 23 3802 0 0 3303 - - ));
1826 DESCR("delete array element");
1827 DATA(insert OID = 3287 ( "#-" PGNSP PGUID b f f 3802 1009 3802 0 0 jsonb_delete_path - - ));
1828 DESCR("delete path");
1829 
1830 #endif /* PG_OPERATOR_H */
int2not
Datum int2not(PG_FUNCTION_ARGS)
Definition: int.c:1306
float48lt
Datum float48lt(PG_FUNCTION_ARGS)
Definition: float.c:3416
textnlike
Datum textnlike(PG_FUNCTION_ARGS)
Definition: like.c:294
namelike
Datum namelike(PG_FUNCTION_ARGS)
Definition: like.c:231
box_right
Datum box_right(PG_FUNCTION_ARGS)
Definition: geo_ops.c:564
float8ne
Datum float8ne(PG_FUNCTION_ARGS)
Definition: float.c:1093
dist_pb
Datum dist_pb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2480
dist_cpoly
Datum dist_cpoly(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2564
DESCR
DESCR("equal")
int8lt
Datum int8lt(PG_FUNCTION_ARGS)
Definition: int8.c:221
float4pl
Datum float4pl(PG_FUNCTION_ARGS)
Definition: float.c:803
tintervallt
Datum tintervallt(PG_FUNCTION_ARGS)
Definition: nabstime.c:1211
time_mi_interval
Datum time_mi_interval(PG_FUNCTION_ARGS)
Definition: date.c:1859
int8ge
Datum int8ge(PG_FUNCTION_ARGS)
Definition: int8.c:248
tidlt
Datum tidlt(PG_FUNCTION_ARGS)
Definition: tid.c:186
tintervalstart
Datum tintervalstart(PG_FUNCTION_ARGS)
Definition: nabstime.c:1400
date_eq
Datum date_eq(PG_FUNCTION_ARGS)
Definition: date.c:306
box_contained
Datum box_contained(PG_FUNCTION_ARGS)
Definition: geo_ops.c:636
float4mi
Datum float4mi(PG_FUNCTION_ARGS)
Definition: float.c:823
timestamptz_ge_timestamp
Datum timestamptz_ge_timestamp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2485
float84ge
Datum float84ge(PG_FUNCTION_ARGS)
Definition: float.c:3500
timetz_pl_interval
Datum timetz_pl_interval(PG_FUNCTION_ARGS)
Definition: date.c:2349
array_ne
Datum array_ne(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:3718
timetz_ge
Datum timetz_ge(PG_FUNCTION_ARGS)
Definition: date.c:2277
nameiclike
Datum nameiclike(PG_FUNCTION_ARGS)
Definition: like.c:361
box_sub
Datum box_sub(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4122
bitle
Datum bitle(PG_FUNCTION_ARGS)
Definition: varbit.c:883
jsonb_lt
Datum jsonb_lt(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:166
time_pl_interval
Datum time_pl_interval(PG_FUNCTION_ARGS)
Definition: date.c:1832
float4eq
Datum float4eq(PG_FUNCTION_ARGS)
Definition: float.c:970
circle_gt
Datum circle_gt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4830
bpchargt
Datum bpchargt(PG_FUNCTION_ARGS)
Definition: varchar.c:807
charle
Datum charle(PG_FUNCTION_ARGS)
Definition: char.c:126
abstimegt
Datum abstimegt(PG_FUNCTION_ARGS)
Definition: nabstime.c:393
box_same
Datum box_same(PG_FUNCTION_ARGS)
Definition: geo_ops.c:504
CATALOG
CATALOG(pg_operator, 2617)
Definition: pg_operator.h:34
box_le
Datum box_le(PG_FUNCTION_ARGS)
Definition: geo_ops.c:720
date_le
Datum date_le(PG_FUNCTION_ARGS)
Definition: date.c:333
close_pl
Datum close_pl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2714
flt8_mul_cash
Datum flt8_mul_cash(PG_FUNCTION_ARGS)
Definition: cash.c:633
date_lt
Datum date_lt(PG_FUNCTION_ARGS)
Definition: date.c:324
int2shr
Datum int2shr(PG_FUNCTION_ARGS)
Definition: int.c:1324
int2vectoreq
Datum int2vectoreq(PG_FUNCTION_ARGS)
Definition: int.c:262
timestamp_ne_date
Datum timestamp_ne_date(PG_FUNCTION_ARGS)
Definition: date.c:791
lseg_ge
Datum lseg_ge(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2189
oideq
#define oideq(x, y)
Definition: pg_dump.h:21
int24mi
Datum int24mi(PG_FUNCTION_ARGS)
Definition: int.c:912
array_ge
Datum array_ge(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:3742
likejoinsel
Datum likejoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2761
int84ge
Datum int84ge(PG_FUNCTION_ARGS)
Definition: int8.c:305
int82mul
Datum int82mul(PG_FUNCTION_ARGS)
Definition: int8.c:1057
numeric_uplus
Datum numeric_uplus(PG_FUNCTION_ARGS)
Definition: numeric.c:1102
box_left
Datum box_left(PG_FUNCTION_ARGS)
Definition: geo_ops.c:538
inetpl
Datum inetpl(PG_FUNCTION_ARGS)
Definition: network.c:1448
timemi
Datum timemi(PG_FUNCTION_ARGS)
Definition: nabstime.c:944
tsquery_le
Datum tsquery_le(PG_FUNCTION_ARGS)
int2mod
Datum int2mod(PG_FUNCTION_ARGS)
Definition: int.c:1116
float4le
Datum float4le(PG_FUNCTION_ARGS)
Definition: float.c:997
circle_contained
Datum circle_contained(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4728
float48mi
Datum float48mi(PG_FUNCTION_ARGS)
Definition: float.c:3283
abstimeeq
Datum abstimeeq(PG_FUNCTION_ARGS)
Definition: nabstime.c:366
lseg_perp
Datum lseg_perp(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2096
close_lb
Datum close_lb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3099
aclcontains
Datum aclcontains(PG_FUNCTION_ARGS)
Definition: acl.c:1553
int82eq
Datum int82eq(PG_FUNCTION_ARGS)
Definition: int8.c:374
lseg_le
Datum lseg_le(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2169
pg_lsn_le
Datum pg_lsn_le(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:140
float8mi
Datum float8mi(PG_FUNCTION_ARGS)
Definition: float.c:885
text_lt
Datum text_lt(PG_FUNCTION_ARGS)
Definition: varlena.c:1663
text_pattern_le
Datum text_pattern_le(PG_FUNCTION_ARGS)
Definition: varlena.c:2512
nameregexeq
Datum nameregexeq(PG_FUNCTION_ARGS)
Definition: regexp.c:436
cash_ne
Datum cash_ne(PG_FUNCTION_ARGS)
Definition: cash.c:503
timetz_ne
Datum timetz_ne(PG_FUNCTION_ARGS)
Definition: date.c:2241
json_extract_path_text
Datum json_extract_path_text(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:708
int24gt
Datum int24gt(PG_FUNCTION_ARGS)
Definition: int.c:534
circle_same
Datum circle_same(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4653
contsel
Datum contsel(PG_FUNCTION_ARGS)
Definition: geo_selfuncs.c:86
float8gt
Datum float8gt(PG_FUNCTION_ARGS)
Definition: float.c:1120
namene
Datum namene(PG_FUNCTION_ARGS)
Definition: name.c:143
float48eq
Datum float48eq(PG_FUNCTION_ARGS)
Definition: float.c:3398
tintervalsame
Datum tintervalsame(PG_FUNCTION_ARGS)
Definition: nabstime.c:1112
cash_div_int4
Datum cash_div_int4(PG_FUNCTION_ARGS)
Definition: cash.c:800
int8xor
Datum int8xor(PG_FUNCTION_ARGS)
Definition: int8.c:1240
charlt
Datum charlt(PG_FUNCTION_ARGS)
Definition: char.c:117
tintervallenlt
Datum tintervallenlt(PG_FUNCTION_ARGS)
Definition: nabstime.c:1299
timestamptz_eq_timestamp
Datum timestamptz_eq_timestamp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2425
timestamp_lt
Datum timestamp_lt(PG_FUNCTION_ARGS)
Definition: timestamp.c:2261
range_overleft
Datum range_overleft(PG_FUNCTION_ARGS)
Definition: rangetypes.c:898
text_pattern_gt
Datum text_pattern_gt(PG_FUNCTION_ARGS)
Definition: varlena.c:2544
timestamp_ne
Datum timestamp_ne(PG_FUNCTION_ARGS)
Definition: timestamp.c:2252
int42eq
Datum int42eq(PG_FUNCTION_ARGS)
Definition: int.c:552
int82ge
Datum int82ge(PG_FUNCTION_ARGS)
Definition: int8.c:419
poly_overleft
Datum poly_overleft(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3548
lseg_eq
Datum lseg_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2135
circle_below
Datum circle_below(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4751
int48div
Datum int48div(PG_FUNCTION_ARGS)
Definition: int8.c:996
int24ge
Datum int24ge(PG_FUNCTION_ARGS)
Definition: int.c:543
timetz_gt
Datum timetz_gt(PG_FUNCTION_ARGS)
Definition: date.c:2268
ts_match_qv
Datum ts_match_qv(PG_FUNCTION_ARGS)
Definition: tsvector_op.c:1578
icregexeqsel
Datum icregexeqsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1386
lseg_center
Datum lseg_center(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2245
byteagt
Datum byteagt(PG_FUNCTION_ARGS)
Definition: varlena.c:3455
timestamptz_ne_date
Datum timestamptz_ne_date(PG_FUNCTION_ARGS)
Definition: date.c:875
box_overright
Datum box_overright(PG_FUNCTION_ARGS)
Definition: geo_ops.c:579
poly_overright
Datum poly_overright(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3594
box_intersect
Datum box_intersect(PG_FUNCTION_ARGS)
Definition: geo_ops.c:857
on_ppath
Datum on_ppath(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3184
lseg_vertical
Datum lseg_vertical(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2118
tintervalle
Datum tintervalle(PG_FUNCTION_ARGS)
Definition: nabstime.c:1220
nlikesel
Datum nlikesel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1431
bpchar_pattern_gt
Datum bpchar_pattern_gt(PG_FUNCTION_ARGS)
Definition: varchar.c:1030
path_inter
Datum path_inter(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1555
tsvector_ne
Datum tsvector_ne(PG_FUNCTION_ARGS)
float4ge
Datum float4ge(PG_FUNCTION_ARGS)
Definition: float.c:1015
timestamp_gt
Datum timestamp_gt(PG_FUNCTION_ARGS)
Definition: timestamp.c:2270
time_le
Datum time_le(PG_FUNCTION_ARGS)
Definition: date.c:1467
float8um
Datum float8um(PG_FUNCTION_ARGS)
Definition: float.c:744
numeric_gt
Datum numeric_gt(PG_FUNCTION_ARGS)
Definition: numeric.c:2020
int2ge
Datum int2ge(PG_FUNCTION_ARGS)
Definition: int.c:489
regexnesel
Datum regexnesel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1413
bytealike
Datum bytealike(PG_FUNCTION_ARGS)
Definition: like.c:315
int28gt
Datum int28gt(PG_FUNCTION_ARGS)
Definition: int8.c:458
poly_distance
Datum poly_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3995
pg_lsn_mi
Datum pg_lsn_mi(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:186
box_contain_pt
Datum box_contain_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3163
int4mod
Datum int4mod(PG_FUNCTION_ARGS)
Definition: int.c:1088
timestamp_mi
Datum timestamp_mi(PG_FUNCTION_ARGS)
Definition: timestamp.c:2786
int42lt
Datum int42lt(PG_FUNCTION_ARGS)
Definition: int.c:570
boollt
Datum boollt(PG_FUNCTION_ARGS)
Definition: bool.c:247
cash_lt
Datum cash_lt(PG_FUNCTION_ARGS)
Definition: cash.c:512
date_ne_timestamptz
Datum date_ne_timestamptz(PG_FUNCTION_ARGS)
Definition: date.c:707
tsquery_gt
Datum tsquery_gt(PG_FUNCTION_ARGS)
scalargtsel
Datum scalargtsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1037
int4and
Datum int4and(PG_FUNCTION_ARGS)
Definition: int.c:1226
path_add
Datum path_add(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4225
int8pl
Datum int8pl(PG_FUNCTION_ARGS)
Definition: int8.c:513
tsvector_concat
Datum tsvector_concat(PG_FUNCTION_ARGS)
Definition: tsvector_op.c:865
date_eq_timestamp
Datum date_eq_timestamp(PG_FUNCTION_ARGS)
Definition: date.c:611
oidvectorle
Datum oidvectorle(PG_FUNCTION_ARGS)
Definition: oid.c:433
oidvectorne
Datum oidvectorne(PG_FUNCTION_ARGS)
Definition: oid.c:417
timestamp_ge_date
Datum timestamp_ge_date(PG_FUNCTION_ARGS)
Definition: date.c:839
texticregexne
Datum texticregexne(PG_FUNCTION_ARGS)
Definition: regexp.c:541
tintervallenle
Datum tintervallenle(PG_FUNCTION_ARGS)
Definition: nabstime.c:1327
dpow
Datum dpow(PG_FUNCTION_ARGS)
Definition: float.c:1460
circle_mul_pt
Datum circle_mul_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4913
float84div
Datum float84div(PG_FUNCTION_ARGS)
Definition: float.c:3371
int2and
Datum int2and(PG_FUNCTION_ARGS)
Definition: int.c:1279
inter_sb
Datum inter_sb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3266
int24ne
Datum int24ne(PG_FUNCTION_ARGS)
Definition: int.c:507
poly_overbelow
Datum poly_overbelow(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3640
time_eq
Datum time_eq(PG_FUNCTION_ARGS)
Definition: date.c:1440
float8up
Datum float8up(PG_FUNCTION_ARGS)
Definition: float.c:754
oidgt
Datum oidgt(PG_FUNCTION_ARGS)
Definition: oid.c:382
cash_mul_int4
Datum cash_mul_int4(PG_FUNCTION_ARGS)
Definition: cash.c:769
box_overlap
Datum box_overlap(PG_FUNCTION_ARGS)
Definition: geo_ops.c:518
int28eq
Datum int28eq(PG_FUNCTION_ARGS)
Definition: int8.c:431
float48le
Datum float48le(PG_FUNCTION_ARGS)
Definition: float.c:3425
macaddr_le
Datum macaddr_le(PG_FUNCTION_ARGS)
Definition: mac.c:192
macaddr_ge
Datum macaddr_ge(PG_FUNCTION_ARGS)
Definition: mac.c:210
bpcharge
Datum bpcharge(PG_FUNCTION_ARGS)
Definition: varchar.c:828
tsq_mcontains
Datum tsq_mcontains(PG_FUNCTION_ARGS)
Definition: tsquery_op.c:328
aclinsert
Datum aclinsert(PG_FUNCTION_ARGS)
Definition: acl.c:1533
abstimene
Datum abstimene(PG_FUNCTION_ARGS)
Definition: nabstime.c:375
cash_div_int2
Datum cash_div_int2(PG_FUNCTION_ARGS)
Definition: cash.c:850
int24mul
Datum int24mul(PG_FUNCTION_ARGS)
Definition: int.c:933
int84div
Datum int84div(PG_FUNCTION_ARGS)
Definition: int8.c:887
point_add
Datum point_add(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4026
float8eq
Datum float8eq(PG_FUNCTION_ARGS)
Definition: float.c:1084
interval_ne
Datum interval_ne(PG_FUNCTION_ARGS)
Definition: timestamp.c:2551
reltimene
Datum reltimene(PG_FUNCTION_ARGS)
Definition: nabstime.c:1053
chargt
Datum chargt(PG_FUNCTION_ARGS)
Definition: char.c:135
date_lt_timestamptz
Datum date_lt_timestamptz(PG_FUNCTION_ARGS)
Definition: date.c:719
int2xor
Datum int2xor(PG_FUNCTION_ARGS)
Definition: int.c:1297
timetz_lt
Datum timetz_lt(PG_FUNCTION_ARGS)
Definition: date.c:2250
lseg_interpt
Datum lseg_interpt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2310
int28div
Datum int28div(PG_FUNCTION_ARGS)
Definition: int8.c:1193
int8le
Datum int8le(PG_FUNCTION_ARGS)
Definition: int8.c:239
tsvector_ge
Datum tsvector_ge(PG_FUNCTION_ARGS)
icregexnejoinsel
Datum icregexnejoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2788
textlike
Datum textlike(PG_FUNCTION_ARGS)
Definition: like.c:273
int4up
Datum int4up(PG_FUNCTION_ARGS)
Definition: int.c:628
int4ne
Datum int4ne(PG_FUNCTION_ARGS)
Definition: int.c:399
range_minus
Datum range_minus(PG_FUNCTION_ARGS)
Definition: rangetypes.c:955
timestamptz_lt_timestamp
Datum timestamptz_lt_timestamp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2449
range_after
Datum range_after(PG_FUNCTION_ARGS)
Definition: rangetypes.c:710
int8mi
Datum int8mi(PG_FUNCTION_ARGS)
Definition: int8.c:534
textregexeq
Datum textregexeq(PG_FUNCTION_ARGS)
Definition: regexp.c:464
int82pl
Datum int82pl(PG_FUNCTION_ARGS)
Definition: int8.c:1015
path_center
Datum path_center(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4349
network_le
Datum network_le(PG_FUNCTION_ARGS)
Definition: network.c:430
float84ne
Datum float84ne(PG_FUNCTION_ARGS)
Definition: float.c:3464
range_overlaps
Datum range_overlaps(PG_FUNCTION_ARGS)
Definition: rangetypes.c:857
path_distance
Datum path_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1633
int82mi
Datum int82mi(PG_FUNCTION_ARGS)
Definition: int8.c:1036
scalargtjoinsel
Datum scalargtjoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2724
neqsel
Datum neqsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:486
poly_contain_pt
Datum poly_contain_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3976
timetz_mi_interval
Datum timetz_mi_interval(PG_FUNCTION_ARGS)
Definition: date.c:2382
bpchareq
Datum bpchareq(PG_FUNCTION_ARGS)
Definition: varchar.c:711
float8ge
Datum float8ge(PG_FUNCTION_ARGS)
Definition: float.c:1129
range_before
Datum range_before(PG_FUNCTION_ARGS)
Definition: rangetypes.c:672
xideq
Datum xideq(PG_FUNCTION_ARGS)
Definition: xid.c:82
timestamp_gt_date
Datum timestamp_gt_date(PG_FUNCTION_ARGS)
Definition: date.c:815
date_eq_timestamptz
Datum date_eq_timestamptz(PG_FUNCTION_ARGS)
Definition: date.c:695
bpcharlt
Datum bpcharlt(PG_FUNCTION_ARGS)
Definition: varchar.c:765
regexeqjoinsel
Datum regexeqjoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2743
poly_contain
Datum poly_contain(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3919
Oid
unsigned int Oid
Definition: postgres_ext.h:31
bitxor
Datum bitxor(PG_FUNCTION_ARGS)
Definition: varbit.c:1296
poly_right
Datum poly_right(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3571
dist_lb
Datum dist_lb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2545
byteaeq
Datum byteaeq(PG_FUNCTION_ARGS)
Definition: varlena.c:3351
box_below_eq
Datum box_below_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:671
line_eq
Datum line_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1148
lseg_ne
Datum lseg_ne(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2147
line_perp
Datum line_perp(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1118
reltimeeq
Datum reltimeeq(PG_FUNCTION_ARGS)
Definition: nabstime.c:1044
namege
Datum namege(PG_FUNCTION_ARGS)
Definition: name.c:179
namelt
Datum namelt(PG_FUNCTION_ARGS)
Definition: name.c:152
bitge
Datum bitge(PG_FUNCTION_ARGS)
Definition: varbit.c:913
int48mi
Datum int48mi(PG_FUNCTION_ARGS)
Definition: int8.c:948
enum_eq
Datum enum_eq(PG_FUNCTION_ARGS)
Definition: enum.c:231
numeric_div
Datum numeric_div(PG_FUNCTION_ARGS)
Definition: numeric.c:2320
path_n_eq
Datum path_n_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1473
network_ne
Datum network_ne(PG_FUNCTION_ARGS)
Definition: network.c:466
int2lt
Datum int2lt(PG_FUNCTION_ARGS)
Definition: int.c:462
int48ge
Datum int48ge(PG_FUNCTION_ARGS)
Definition: int8.c:362
int4pl
Datum int4pl(PG_FUNCTION_ARGS)
Definition: int.c:636
network_lt
Datum network_lt(PG_FUNCTION_ARGS)
Definition: network.c:421
int24div
Datum int24div(PG_FUNCTION_ARGS)
Definition: int.c:960
areasel
Datum areasel(PG_FUNCTION_ARGS)
Definition: geo_selfuncs.c:48
interval_mi
Datum interval_mi(PG_FUNCTION_ARGS)
Definition: timestamp.c:3300
box_above_eq
Datum box_above_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:680
timestamptz_ne_timestamp
Datum timestamptz_ne_timestamp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2437
bpchar_pattern_lt
Datum bpchar_pattern_lt(PG_FUNCTION_ARGS)
Definition: varchar.c:982
float48pl
Datum float48pl(PG_FUNCTION_ARGS)
Definition: float.c:3271
boolne
Datum boolne(PG_FUNCTION_ARGS)
Definition: bool.c:238
arraycontsel
Datum arraycontsel(PG_FUNCTION_ARGS)
Definition: array_selfuncs.c:250
cideq
Datum cideq(PG_FUNCTION_ARGS)
Definition: xid.c:210
array_gt
Datum array_gt(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:3730
json_array_element_text
Datum json_array_element_text(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:628
flt4_mul_cash
Datum flt4_mul_cash(PG_FUNCTION_ARGS)
Definition: cash.c:683
int24eq
Datum int24eq(PG_FUNCTION_ARGS)
Definition: int.c:498
timestamp_le_date
Datum timestamp_le_date(PG_FUNCTION_ARGS)
Definition: date.c:827
point_distance
Datum point_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1897
circle_above
Datum circle_above(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4763
point_mul
Datum point_mul(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4056
numeric_eq
Datum numeric_eq(PG_FUNCTION_ARGS)
Definition: numeric.c:1990
line_parallel
Datum line_parallel(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1106
enum_lt
Datum enum_lt(PG_FUNCTION_ARGS)
Definition: enum.c:213
arrayoverlap
Datum arrayoverlap(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:4182
mktinterval
Datum mktinterval(PG_FUNCTION_ARGS)
Definition: nabstime.c:891
point_below
Datum point_below(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1848
lseg_length
Datum lseg_length(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2035
float4up
Datum float4up(PG_FUNCTION_ARGS)
Definition: float.c:687
array_cat
Datum array_cat(PG_FUNCTION_ARGS)
Definition: array_userfuncs.c:211
float48ge
Datum float48ge(PG_FUNCTION_ARGS)
Definition: float.c:3443
cash_div_cash
Datum cash_div_cash(PG_FUNCTION_ARGS)
Definition: cash.c:598
int2up
Datum int2up(PG_FUNCTION_ARGS)
Definition: int.c:780
point_right
Datum point_right(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1830
FormData_pg_operator
FormData_pg_operator
Definition: pg_operator.h:50
timestamp_mi_interval
Datum timestamp_mi_interval(PG_FUNCTION_ARGS)
Definition: timestamp.c:3081
bytealt
Datum bytealt(PG_FUNCTION_ARGS)
Definition: varlena.c:3415
networkjoinsel
Datum networkjoinsel(PG_FUNCTION_ARGS)
Definition: network_selfuncs.c:198
timestamp_pl_interval
Datum timestamp_pl_interval(PG_FUNCTION_ARGS)
Definition: timestamp.c:3002
interval_pl
Datum interval_pl(PG_FUNCTION_ARGS)
Definition: timestamp.c:3266
tsvector_le
Datum tsvector_le(PG_FUNCTION_ARGS)
int48eq
Datum int48eq(PG_FUNCTION_ARGS)
Definition: int8.c:317
on_pl
Datum on_pl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3123
nameicnlike
Datum nameicnlike(PG_FUNCTION_ARGS)
Definition: like.c:376
timestamp_eq_timestamptz
Datum timestamp_eq_timestamptz(PG_FUNCTION_ARGS)
Definition: timestamp.c:2341
circle_contain
Datum circle_contain(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4739
enum_gt
Datum enum_gt(PG_FUNCTION_ARGS)
Definition: enum.c:258
box_gt
Datum box_gt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:702
enum_ne
Datum enum_ne(PG_FUNCTION_ARGS)
Definition: enum.c:240
circle_ge
Datum circle_ge(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4848
cash_mul_flt4
Datum cash_mul_flt4(PG_FUNCTION_ARGS)
Definition: cash.c:668
line_interpt
Datum line_interpt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1199
reltimegt
Datum reltimegt(PG_FUNCTION_ARGS)
Definition: nabstime.c:1071
float8pl
Datum float8pl(PG_FUNCTION_ARGS)
Definition: float.c:872
circle_overleft
Datum circle_overleft(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4679
numeric_uminus
Datum numeric_uminus(PG_FUNCTION_ARGS)
Definition: numeric.c:1061
numeric_abs
Datum numeric_abs(PG_FUNCTION_ARGS)
Definition: numeric.c:1033
icregexeqjoinsel
Datum icregexeqjoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2752
likesel
Datum likesel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1395
jsonb_gt
Datum jsonb_gt(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:180
time_lt
Datum time_lt(PG_FUNCTION_ARGS)
Definition: date.c:1458
int82le
Datum int82le(PG_FUNCTION_ARGS)
Definition: int8.c:410
reltimege
Datum reltimege(PG_FUNCTION_ARGS)
Definition: nabstime.c:1089
range_contains
Datum range_contains(PG_FUNCTION_ARGS)
Definition: rangetypes.c:621
int8and
Datum int8and(PG_FUNCTION_ARGS)
Definition: int8.c:1222
float84pl
Datum float84pl(PG_FUNCTION_ARGS)
Definition: float.c:3331
poly_below
Datum poly_below(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3617
json_array_element
Datum json_array_element(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:585
numeric_mod
Datum numeric_mod(PG_FUNCTION_ARGS)
Definition: numeric.c:2410
point_div
Datum point_div(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4071
float4div
Datum float4div(PG_FUNCTION_ARGS)
Definition: float.c:848
oidvectorge
Datum oidvectorge(PG_FUNCTION_ARGS)
Definition: oid.c:441
int4abs
Datum int4abs(PG_FUNCTION_ARGS)
Definition: int.c:1149
int28ge
Datum int28ge(PG_FUNCTION_ARGS)
Definition: int8.c:476
byteage
Datum byteage(PG_FUNCTION_ARGS)
Definition: varlena.c:3475
path_add_pt
Datum path_add_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4273
pt_contained_circle
Datum pt_contained_circle(PG_FUNCTION_ARGS)
Definition: geo_ops.c:5017
bitlt
Datum bitlt(PG_FUNCTION_ARGS)
Definition: varbit.c:868
int8eq
Datum int8eq(PG_FUNCTION_ARGS)
Definition: int8.c:203
texticregexeq
Datum texticregexeq(PG_FUNCTION_ARGS)
Definition: regexp.c:527
bpcharle
Datum bpcharle(PG_FUNCTION_ARGS)
Definition: varchar.c:786
ts_match_vq
Datum ts_match_vq(PG_FUNCTION_ARGS)
Definition: tsvector_op.c:1586
box_distance
Datum box_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:781
range_gt
Datum range_gt(PG_FUNCTION_ARGS)
Definition: rangetypes.c:1211
dcbrt
Datum dcbrt(PG_FUNCTION_ARGS)
Definition: float.c:1445
close_pb
Datum close_pb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2923
int42gt
Datum int42gt(PG_FUNCTION_ARGS)
Definition: int.c:588
int4ge
Datum int4ge(PG_FUNCTION_ARGS)
Definition: int.c:435
macaddr_lt
Datum macaddr_lt(PG_FUNCTION_ARGS)
Definition: mac.c:183
interval_lt
Datum interval_lt(PG_FUNCTION_ARGS)
Definition: timestamp.c:2560
int4lt
Datum int4lt(PG_FUNCTION_ARGS)
Definition: int.c:408
int4mi
Datum int4mi(PG_FUNCTION_ARGS)
Definition: int.c:657
time_gt
Datum time_gt(PG_FUNCTION_ARGS)
Definition: date.c:1476
rangesel
Datum rangesel(PG_FUNCTION_ARGS)
Definition: rangetypes_selfuncs.c:105
timestamp_gt_timestamptz
Datum timestamp_gt_timestamptz(PG_FUNCTION_ARGS)
Definition: timestamp.c:2377
point_left
Datum point_left(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1821
float8abs
Datum float8abs(PG_FUNCTION_ARGS)
Definition: float.c:732
nameData
Definition: c.h:488
box_contain
Datum box_contain(PG_FUNCTION_ARGS)
Definition: geo_ops.c:650
texteq
Datum texteq(PG_FUNCTION_ARGS)
Definition: varlena.c:1599
int2mul
Datum int2mul(PG_FUNCTION_ARGS)
Definition: int.c:830
path_n_lt
Datum path_n_lt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1455
enum_le
Datum enum_le(PG_FUNCTION_ARGS)
Definition: enum.c:222
poly_contained
Datum poly_contained(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3965
box_above
Datum box_above(PG_FUNCTION_ARGS)
Definition: geo_ops.c:613
float8div
Datum float8div(PG_FUNCTION_ARGS)
Definition: float.c:912
int8gt
Datum int8gt(PG_FUNCTION_ARGS)
Definition: int8.c:230
date_gt_timestamp
Datum date_gt_timestamp(PG_FUNCTION_ARGS)
Definition: date.c:647
timestamp_ne_timestamptz
Datum timestamp_ne_timestamptz(PG_FUNCTION_ARGS)
Definition: timestamp.c:2353
path_n_ge
Datum path_n_ge(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1491
jsonb_array_element_text
Datum jsonb_array_element_text(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:643
range_overright
Datum range_overright(PG_FUNCTION_ARGS)
Definition: rangetypes.c:939
textne
Datum textne(PG_FUNCTION_ARGS)
Definition: varlena.c:1634
eqsel
Datum eqsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:219
int82gt
Datum int82gt(PG_FUNCTION_ARGS)
Definition: int8.c:401
timestamp_ge_timestamptz
Datum timestamp_ge_timestamptz(PG_FUNCTION_ARGS)
Definition: timestamp.c:2401
int8mul
Datum int8mul(PG_FUNCTION_ARGS)
Definition: int8.c:555
boolgt
Datum boolgt(PG_FUNCTION_ARGS)
Definition: bool.c:256
box_eq
Datum box_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:711
scalarltsel
Datum scalarltsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:962
jsonb_object_field
Datum jsonb_object_field(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:498
abstimele
Datum abstimele(PG_FUNCTION_ARGS)
Definition: nabstime.c:402
path_n_le
Datum path_n_le(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1482
record_ge
Datum record_ge(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1255
reltimele
Datum reltimele(PG_FUNCTION_ARGS)
Definition: nabstime.c:1080
namenlike
Datum namenlike(PG_FUNCTION_ARGS)
Definition: like.c:252
macaddr_not
Datum macaddr_not(PG_FUNCTION_ARGS)
Definition: mac.c:251
numeric_le
Datum numeric_le(PG_FUNCTION_ARGS)
Definition: numeric.c:2065
float84mul
Datum float84mul(PG_FUNCTION_ARGS)
Definition: float.c:3357
box_add
Datum box_add(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4110
date_ne
Datum date_ne(PG_FUNCTION_ARGS)
Definition: date.c:315
tsquery_ne
Datum tsquery_ne(PG_FUNCTION_ARGS)
circle_le
Datum circle_le(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4839
eqjoinsel
Datum eqjoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2182
texticnlike
Datum texticnlike(PG_FUNCTION_ARGS)
Definition: like.c:403
nameicregexne
Datum nameicregexne(PG_FUNCTION_ARGS)
Definition: regexp.c:513
range_eq
Datum range_eq(PG_FUNCTION_ARGS)
Definition: rangetypes.c:588
cash_le
Datum cash_le(PG_FUNCTION_ARGS)
Definition: cash.c:521
box_center
Datum box_center(PG_FUNCTION_ARGS)
Definition: geo_ops.c:798
timestamp_eq
Datum timestamp_eq(PG_FUNCTION_ARGS)
Definition: timestamp.c:2243
date_gt
Datum date_gt(PG_FUNCTION_ARGS)
Definition: date.c:342
pt_contained_poly
Datum pt_contained_poly(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3985
float4abs
Datum float4abs(PG_FUNCTION_ARGS)
Definition: float.c:666
int8div
Datum int8div(PG_FUNCTION_ARGS)
Definition: int8.c:587
inter_lb
Datum inter_lb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3321
chareq
Datum chareq(PG_FUNCTION_ARGS)
Definition: char.c:99
lseg_horizontal
Datum lseg_horizontal(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2126
on_sl
Datum on_sl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3214
regexeqsel
Datum regexeqsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1377
dist_ps
Datum dist_ps(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2358
interval_ge
Datum interval_ge(PG_FUNCTION_ARGS)
Definition: timestamp.c:2587
poly_left
Datum poly_left(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3525
pg_lsn_ge
Datum pg_lsn_ge(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:149
box_lt
Datum box_lt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:693
int48gt
Datum int48gt(PG_FUNCTION_ARGS)
Definition: int8.c:344
tsmatchsel
Datum tsmatchsel(PG_FUNCTION_ARGS)
Definition: ts_selfuncs.c:67
timestamptz_le_date
Datum timestamptz_le_date(PG_FUNCTION_ARGS)
Definition: date.c:911
charge
Datum charge(PG_FUNCTION_ARGS)
Definition: char.c:144
int2eq
Datum int2eq(PG_FUNCTION_ARGS)
Definition: int.c:444
interval_le
Datum interval_le(PG_FUNCTION_ARGS)
Definition: timestamp.c:2578
tsvector_gt
Datum tsvector_gt(PG_FUNCTION_ARGS)
circle_div_pt
Datum circle_div_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4933
int84lt
Datum int84lt(PG_FUNCTION_ARGS)
Definition: int8.c:278
enum_ge
Datum enum_ge(PG_FUNCTION_ARGS)
Definition: enum.c:249
int4not
Datum int4not(PG_FUNCTION_ARGS)
Definition: int.c:1271
lseg_distance
Datum lseg_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2209
timetz_le
Datum timetz_le(PG_FUNCTION_ARGS)
Definition: date.c:2259
record_lt
Datum record_lt(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1237
text_gt
Datum text_gt(PG_FUNCTION_ARGS)
Definition: varlena.c:1693
textregexne
Datum textregexne(PG_FUNCTION_ARGS)
Definition: regexp.c:478
float8mul
Datum float8mul(PG_FUNCTION_ARGS)
Definition: float.c:898
int48lt
Datum int48lt(PG_FUNCTION_ARGS)
Definition: int8.c:335
contjoinsel
Datum contjoinsel(PG_FUNCTION_ARGS)
Definition: geo_selfuncs.c:92
pg_lsn_eq
Datum pg_lsn_eq(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:104
inetmi_int8
Datum inetmi_int8(PG_FUNCTION_ARGS)
Definition: network.c:1458
int8um
Datum int8um(PG_FUNCTION_ARGS)
Definition: int8.c:490
dist_sb
Datum dist_sb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2524
macaddr_or
Datum macaddr_or(PG_FUNCTION_ARGS)
Definition: mac.c:284
on_pb
Datum on_pb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3153
float4mul
Datum float4mul(PG_FUNCTION_ARGS)
Definition: float.c:835
cash_pl
Datum cash_pl(PG_FUNCTION_ARGS)
Definition: cash.c:566
timestamp_ge
Datum timestamp_ge(PG_FUNCTION_ARGS)
Definition: timestamp.c:2288
int42mul
Datum int42mul(PG_FUNCTION_ARGS)
Definition: int.c:1021
int4shl
Datum int4shl(PG_FUNCTION_ARGS)
Definition: int.c:1253
numeric_ne
Datum numeric_ne(PG_FUNCTION_ARGS)
Definition: numeric.c:2005
network_gt
Datum network_gt(PG_FUNCTION_ARGS)
Definition: network.c:457
record_image_le
Datum record_image_le(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1805
range_ne
Datum range_ne(PG_FUNCTION_ARGS)
Definition: rangetypes.c:608
network_eq
Datum network_eq(PG_FUNCTION_ARGS)
Definition: network.c:439
tidge
Datum tidge(PG_FUNCTION_ARGS)
Definition: tid.c:213
textcat
Datum textcat(PG_FUNCTION_ARGS)
Definition: varlena.c:680
dist_sl
Datum dist_sl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2499
network_ge
Datum network_ge(PG_FUNCTION_ARGS)
Definition: network.c:448
date_le_timestamptz
Datum date_le_timestamptz(PG_FUNCTION_ARGS)
Definition: date.c:743
int84le
Datum int84le(PG_FUNCTION_ARGS)
Definition: int8.c:296
float8lt
Datum float8lt(PG_FUNCTION_ARGS)
Definition: float.c:1102
interval_eq
Datum interval_eq(PG_FUNCTION_ARGS)
Definition: timestamp.c:2542
date_mii
Datum date_mii(PG_FUNCTION_ARGS)
Definition: date.c:464
path_div_pt
Datum path_div_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4328
int84mul
Datum int84mul(PG_FUNCTION_ARGS)
Definition: int8.c:860
date_lt_timestamp
Datum date_lt_timestamp(PG_FUNCTION_ARGS)
Definition: date.c:635
nameicregexeq
Datum nameicregexeq(PG_FUNCTION_ARGS)
Definition: regexp.c:499
oidvectorgt
Datum oidvectorgt(PG_FUNCTION_ARGS)
Definition: oid.c:449
bpcharne
Datum bpcharne(PG_FUNCTION_ARGS)
Definition: varchar.c:738
jsonb_concat
Datum jsonb_concat(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:3361
int24lt
Datum int24lt(PG_FUNCTION_ARGS)
Definition: int.c:516
tintervalov
Datum tintervalov(PG_FUNCTION_ARGS)
Definition: nabstime.c:1379
tidle
Datum tidle(PG_FUNCTION_ARGS)
Definition: tid.c:195
int4um
Datum int4um(PG_FUNCTION_ARGS)
Definition: int.c:613
namegt
Datum namegt(PG_FUNCTION_ARGS)
Definition: name.c:170
bitshiftright
Datum bitshiftright(PG_FUNCTION_ARGS)
Definition: varbit.c:1437
tintervallengt
Datum tintervallengt(PG_FUNCTION_ARGS)
Definition: nabstime.c:1313
scalarltjoinsel
Datum scalarltjoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2715
record_gt
Datum record_gt(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1243
pg_lsn_gt
Datum pg_lsn_gt(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:131
box_mul
Datum box_mul(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4134
int48pl
Datum int48pl(PG_FUNCTION_ARGS)
Definition: int8.c:927
iclikejoinsel
Datum iclikejoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2770
jsonb_array_element
Datum jsonb_array_element(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:600
float48ne
Datum float48ne(PG_FUNCTION_ARGS)
Definition: float.c:3407
circle_left
Datum circle_left(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4691
jsonb_contains
Datum jsonb_contains(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:112
cash_mi
Datum cash_mi(PG_FUNCTION_ARGS)
Definition: cash.c:582
numeric_mul
Datum numeric_mul(PG_FUNCTION_ARGS)
Definition: numeric.c:2278
text_le
Datum text_le(PG_FUNCTION_ARGS)
Definition: varlena.c:1678
cash_div_flt4
Datum cash_div_flt4(PG_FUNCTION_ARGS)
Definition: cash.c:699
lseg_intersect
Datum lseg_intersect(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2051
interval_um
Datum interval_um(PG_FUNCTION_ARGS)
Definition: timestamp.c:3208
jsonb_delete_path
Datum jsonb_delete_path(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:3568
close_ls
Datum close_ls(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3016
int8ne
Datum int8ne(PG_FUNCTION_ARGS)
Definition: int8.c:212
oidvectorlt
Datum oidvectorlt(PG_FUNCTION_ARGS)
Definition: oid.c:425
int84ne
Datum int84ne(PG_FUNCTION_ARGS)
Definition: int8.c:269
texticlike
Datum texticlike(PG_FUNCTION_ARGS)
Definition: like.c:391
bitgt
Datum bitgt(PG_FUNCTION_ARGS)
Definition: varbit.c:898
macaddr_eq
Datum macaddr_eq(PG_FUNCTION_ARGS)
Definition: mac.c:201
path_sub_pt
Datum path_sub_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4289
int82div
Datum int82div(PG_FUNCTION_ARGS)
Definition: int8.c:1084
float4ne
Datum float4ne(PG_FUNCTION_ARGS)
Definition: float.c:979
int4or
Datum int4or(PG_FUNCTION_ARGS)
Definition: int.c:1235
circle_contain_pt
Datum circle_contain_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:5005
point_sub
Datum point_sub(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4041
numeric_sub
Datum numeric_sub(PG_FUNCTION_ARGS)
Definition: numeric.c:2240
elem_contained_by_range
Datum elem_contained_by_range(PG_FUNCTION_ARGS)
Definition: rangetypes.c:540
tsq_mcontained
Datum tsq_mcontained(PG_FUNCTION_ARGS)
Definition: tsquery_op.c:374
int82lt
Datum int82lt(PG_FUNCTION_ARGS)
Definition: int8.c:392
line_intersect
Datum line_intersect(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1095
jsonb_exists
Datum jsonb_exists(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:21
json_object_field
Datum json_object_field(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:482
int4le
Datum int4le(PG_FUNCTION_ARGS)
Definition: int.c:417
int4xor
Datum int4xor(PG_FUNCTION_ARGS)
Definition: int.c:1244
mul_d_interval
Datum mul_d_interval(PG_FUNCTION_ARGS)
Definition: timestamp.c:3421
point_vert
Datum point_vert(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1857
bitcat
Datum bitcat(PG_FUNCTION_ARGS)
Definition: varbit.c:947
arraycontains
Datum arraycontains(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:4200
float84lt
Datum float84lt(PG_FUNCTION_ARGS)
Definition: float.c:3473
network_subeq
Datum network_subeq(PG_FUNCTION_ARGS)
Definition: network.c:533
box_overbelow
Datum box_overbelow(PG_FUNCTION_ARGS)
Definition: geo_ops.c:602
biteq
Datum biteq(PG_FUNCTION_ARGS)
Definition: varbit.c:820
aclremove
Datum aclremove(PG_FUNCTION_ARGS)
Definition: acl.c:1543
int84gt
Datum int84gt(PG_FUNCTION_ARGS)
Definition: int8.c:287
text_ge
Datum text_ge(PG_FUNCTION_ARGS)
Definition: varlena.c:1708
range_le
Datum range_le(PG_FUNCTION_ARGS)
Definition: rangetypes.c:1195
arraycontained
Datum arraycontained(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:4218
int28ne
Datum int28ne(PG_FUNCTION_ARGS)
Definition: int8.c:440
circle_overbelow
Datum circle_overbelow(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4776
macaddr_ne
Datum macaddr_ne(PG_FUNCTION_ARGS)
Definition: mac.c:228
numeric_lt
Datum numeric_lt(PG_FUNCTION_ARGS)
Definition: numeric.c:2050
float84mi
Datum float84mi(PG_FUNCTION_ARGS)
Definition: float.c:3344
point_ne
Datum point_ne(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1884
int8shr
Datum int8shr(PG_FUNCTION_ARGS)
Definition: int8.c:1266
time_ne
Datum time_ne(PG_FUNCTION_ARGS)
Definition: date.c:1449
positionjoinsel
Datum positionjoinsel(PG_FUNCTION_ARGS)
Definition: geo_selfuncs.c:73
circle_overabove
Datum circle_overabove(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4789
record_le
Datum record_le(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1249
cash_eq
Datum cash_eq(PG_FUNCTION_ARGS)
Definition: cash.c:494
boolle
Datum boolle(PG_FUNCTION_ARGS)
Definition: bool.c:265
circle_eq
Datum circle_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4803
range_contained_by
Datum range_contained_by(PG_FUNCTION_ARGS)
Definition: rangetypes.c:634
circle_right
Datum circle_right(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4703
numeric_power
Datum numeric_power(PG_FUNCTION_ARGS)
Definition: numeric.c:2771
tintervalct
Datum tintervalct(PG_FUNCTION_ARGS)
Definition: nabstime.c:1358
int28le
Datum int28le(PG_FUNCTION_ARGS)
Definition: int8.c:467
int24le
Datum int24le(PG_FUNCTION_ARGS)
Definition: int.c:525
range_lt
Datum range_lt(PG_FUNCTION_ARGS)
Definition: rangetypes.c:1187
icregexnesel
Datum icregexnesel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1422
timestamp_le_timestamptz
Datum timestamp_le_timestamptz(PG_FUNCTION_ARGS)
Definition: timestamp.c:2389
uuid_gt
Datum uuid_gt(PG_FUNCTION_ARGS)
Definition: uuid.c:215
date_gt_timestamptz
Datum date_gt_timestamptz(PG_FUNCTION_ARGS)
Definition: date.c:731
bitshiftleft
Datum bitshiftleft(PG_FUNCTION_ARGS)
Definition: varbit.c:1377
array_eq
Datum array_eq(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:3589
tsquery_not
Datum tsquery_not(PG_FUNCTION_ARGS)
Definition: tsquery_op.c:157
boolge
Datum boolge(PG_FUNCTION_ARGS)
Definition: bool.c:274
timestamptz_mi_interval
Datum timestamptz_mi_interval(PG_FUNCTION_ARGS)
Definition: timestamp.c:3191
circle_lt
Datum circle_lt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4821
inetmi
Datum inetmi(PG_FUNCTION_ARGS)
Definition: network.c:1468
int4div
Datum int4div(PG_FUNCTION_ARGS)
Definition: int.c:709
dist_ppath
Datum dist_ppath(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2423
json_object_field_text
Datum json_object_field_text(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:518
byteanlike
Datum byteanlike(PG_FUNCTION_ARGS)
Definition: like.c:336
close_sl
Datum close_sl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2982
timestamptz_ge_date
Datum timestamptz_ge_date(PG_FUNCTION_ARGS)
Definition: date.c:923
box_below
Datum box_below(PG_FUNCTION_ARGS)
Definition: geo_ops.c:590
array_le
Datum array_le(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:3736
int84pl
Datum int84pl(PG_FUNCTION_ARGS)
Definition: int8.c:818
timestamptz_lt_date
Datum timestamptz_lt_date(PG_FUNCTION_ARGS)
Definition: date.c:887
array_lt
Datum array_lt(PG_FUNCTION_ARGS)
Definition: arrayfuncs.c:3724
int8shl
Datum int8shl(PG_FUNCTION_ARGS)
Definition: int8.c:1257
jsonb_object_field_text
Datum jsonb_object_field_text(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:534
circle_overright
Datum circle_overright(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4716
int48mul
Datum int48mul(PG_FUNCTION_ARGS)
Definition: int8.c:969
int2div
Datum int2div(PG_FUNCTION_ARGS)
Definition: int.c:851
dist_pc
Datum dist_pc(PG_FUNCTION_ARGS)
Definition: geo_ops.c:5032
on_sb
Datum on_sb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3228
int42div
Datum int42div(PG_FUNCTION_ARGS)
Definition: int.c:1048
network_overlap
Datum network_overlap(PG_FUNCTION_ARGS)
Definition: network.c:578
icnlikesel
Datum icnlikesel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1440
int2mi
Datum int2mi(PG_FUNCTION_ARGS)
Definition: int.c:809
dist_pl
Datum dist_pl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2339
inter_sl
Datum inter_sl(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3247
poly_overabove
Datum poly_overabove(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3686
int2ne
Datum int2ne(PG_FUNCTION_ARGS)
Definition: int.c:453
box_div
Datum box_div(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4155
tsquery_eq
Datum tsquery_eq(PG_FUNCTION_ARGS)
tsvector_eq
Datum tsvector_eq(PG_FUNCTION_ARGS)
icnlikejoinsel
Datum icnlikejoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2806
poly_overlap
Datum poly_overlap(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3736
range_ge
Datum range_ge(PG_FUNCTION_ARGS)
Definition: rangetypes.c:1203
range_union
Datum range_union(PG_FUNCTION_ARGS)
Definition: rangetypes.c:1069
tsquery_ge
Datum tsquery_ge(PG_FUNCTION_ARGS)
bpchar_pattern_le
Datum bpchar_pattern_le(PG_FUNCTION_ARGS)
Definition: varchar.c:998
cash_mul_flt8
Datum cash_mul_flt8(PG_FUNCTION_ARGS)
Definition: cash.c:618
timetz_eq
Datum timetz_eq(PG_FUNCTION_ARGS)
Definition: date.c:2232
tsquery_and
Datum tsquery_and(PG_FUNCTION_ARGS)
Definition: tsquery_op.c:51
box_overleft
Datum box_overleft(PG_FUNCTION_ARGS)
Definition: geo_ops.c:553
int82ne
Datum int82ne(PG_FUNCTION_ARGS)
Definition: int8.c:383
pg_lsn_lt
Datum pg_lsn_lt(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:122
int2shl
Datum int2shl(PG_FUNCTION_ARGS)
Definition: int.c:1315
int4mul
Datum int4mul(PG_FUNCTION_ARGS)
Definition: int.c:678
text_pattern_lt
Datum text_pattern_lt(PG_FUNCTION_ARGS)
Definition: varlena.c:2496
int28mul
Datum int28mul(PG_FUNCTION_ARGS)
Definition: int8.c:1166
timestamptz_pl_interval
Datum timestamptz_pl_interval(PG_FUNCTION_ARGS)
Definition: timestamp.c:3107
float4lt
Datum float4lt(PG_FUNCTION_ARGS)
Definition: float.c:988
int2or
Datum int2or(PG_FUNCTION_ARGS)
Definition: int.c:1288
numeric_fac
Datum numeric_fac(PG_FUNCTION_ARGS)
Definition: numeric.c:2527
network_sup
Datum network_sup(PG_FUNCTION_ARGS)
Definition: network.c:548
abstimelt
Datum abstimelt(PG_FUNCTION_ARGS)
Definition: nabstime.c:384
byteane
Datum byteane(PG_FUNCTION_ARGS)
Definition: varlena.c:3383
line_vertical
Datum line_vertical(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1132
float84gt
Datum float84gt(PG_FUNCTION_ARGS)
Definition: float.c:3491
jsonb_exists_any
Datum jsonb_exists_any(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:46
record_image_gt
Datum record_image_gt(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1799
interval_div
Datum interval_div(PG_FUNCTION_ARGS)
Definition: timestamp.c:3431
circle_sub_pt
Datum circle_sub_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4894
macaddr_and
Datum macaddr_and(PG_FUNCTION_ARGS)
Definition: mac.c:267
int84eq
Datum int84eq(PG_FUNCTION_ARGS)
Definition: int8.c:260
tintervalleneq
Datum tintervalleneq(PG_FUNCTION_ARGS)
Definition: nabstime.c:1271
iclikesel
Datum iclikesel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:1404
cash_ge
Datum cash_ge(PG_FUNCTION_ARGS)
Definition: cash.c:539
float48mul
Datum float48mul(PG_FUNCTION_ARGS)
Definition: float.c:3295
circle_center
Datum circle_center(PG_FUNCTION_ARGS)
Definition: geo_ops.c:5063
tintervallenne
Datum tintervallenne(PG_FUNCTION_ARGS)
Definition: nabstime.c:1285
Form_pg_operator
FormData_pg_operator* Form_pg_operator
Definition: pg_operator.h:57
dist_polyp
Datum dist_polyp(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2596
xidneq
Datum xidneq(PG_FUNCTION_ARGS)
Definition: xid.c:94
point_horiz
Datum point_horiz(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1866
circle_distance
Datum circle_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4990
date_ge_timestamptz
Datum date_ge_timestamptz(PG_FUNCTION_ARGS)
Definition: date.c:755
circle_ne
Datum circle_ne(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4812
intinterval
Datum intinterval(PG_FUNCTION_ARGS)
Definition: nabstime.c:963
circle_overlap
Datum circle_overlap(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4666
lseg_parallel
Datum lseg_parallel(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2077
poly_npoints
Datum poly_npoints(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4405
charne
Datum charne(PG_FUNCTION_ARGS)
Definition: char.c:108
int28lt
Datum int28lt(PG_FUNCTION_ARGS)
Definition: int8.c:449
json_extract_path
Datum json_extract_path(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:702
date_ne_timestamp
Datum date_ne_timestamp(PG_FUNCTION_ARGS)
Definition: date.c:623
regproc
Oid regproc
Definition: c.h:390
int8abs
Datum int8abs(PG_FUNCTION_ARGS)
Definition: int8.c:630
bpchar_pattern_ge
Datum bpchar_pattern_ge(PG_FUNCTION_ARGS)
Definition: varchar.c:1014
jsonb_extract_path_text
Datum jsonb_extract_path_text(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:1164
uuid_ge
Datum uuid_ge(PG_FUNCTION_ARGS)
Definition: uuid.c:206
tintervallenge
Datum tintervallenge(PG_FUNCTION_ARGS)
Definition: nabstime.c:1341
tintervalge
Datum tintervalge(PG_FUNCTION_ARGS)
Definition: nabstime.c:1238
line_distance
Datum line_distance(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1177
int42ne
Datum int42ne(PG_FUNCTION_ARGS)
Definition: int.c:561
namele
Datum namele(PG_FUNCTION_ARGS)
Definition: name.c:161
date_le_timestamp
Datum date_le_timestamp(PG_FUNCTION_ARGS)
Definition: date.c:659
regexnejoinsel
Datum regexnejoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2779
dsqrt
Datum dsqrt(PG_FUNCTION_ARGS)
Definition: float.c:1424
tintervaleq
Datum tintervaleq(PG_FUNCTION_ARGS)
Definition: nabstime.c:1193
uuid_le
Datum uuid_le(PG_FUNCTION_ARGS)
Definition: uuid.c:188
inetor
Datum inetor(PG_FUNCTION_ARGS)
Definition: network.c:1364
oidne
Datum oidne(PG_FUNCTION_ARGS)
Definition: oid.c:346
timepl
Datum timepl(PG_FUNCTION_ARGS)
Definition: nabstime.c:925
nameregexne
Datum nameregexne(PG_FUNCTION_ARGS)
Definition: regexp.c:450
float4gt
Datum float4gt(PG_FUNCTION_ARGS)
Definition: float.c:1006
inetnot
Datum inetnot(PG_FUNCTION_ARGS)
Definition: network.c:1307
int2um
Datum int2um(PG_FUNCTION_ARGS)
Definition: int.c:765
int4gt
Datum int4gt(PG_FUNCTION_ARGS)
Definition: int.c:426
timestamp_lt_timestamptz
Datum timestamp_lt_timestamptz(PG_FUNCTION_ARGS)
Definition: timestamp.c:2365
close_ps
Datum close_ps(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2758
int84mi
Datum int84mi(PG_FUNCTION_ARGS)
Definition: int8.c:839
range_contains_elem
Datum range_contains_elem(PG_FUNCTION_ARGS)
Definition: rangetypes.c:527
interval_mul
Datum interval_mul(PG_FUNCTION_ARGS)
Definition: timestamp.c:3340
int8or
Datum int8or(PG_FUNCTION_ARGS)
Definition: int8.c:1231
lseg_lt
Datum lseg_lt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2159
jsonb_eq
Datum jsonb_eq(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:222
range_intersect
Datum range_intersect(PG_FUNCTION_ARGS)
Definition: rangetypes.c:1098
tintervalgt
Datum tintervalgt(PG_FUNCTION_ARGS)
Definition: nabstime.c:1229
time_mi_time
Datum time_mi_time(PG_FUNCTION_ARGS)
Definition: date.c:1813
point_eq
Datum point_eq(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1875
areajoinsel
Datum areajoinsel(PG_FUNCTION_ARGS)
Definition: geo_selfuncs.c:54
cash_div_flt8
Datum cash_div_flt8(PG_FUNCTION_ARGS)
Definition: cash.c:648
int2abs
Datum int2abs(PG_FUNCTION_ARGS)
Definition: int.c:1164
timestamptz_gt_date
Datum timestamptz_gt_date(PG_FUNCTION_ARGS)
Definition: date.c:899
timestamptz_gt_timestamp
Datum timestamptz_gt_timestamp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2461
int4_mul_cash
Datum int4_mul_cash(PG_FUNCTION_ARGS)
Definition: cash.c:784
positionsel
Datum positionsel(PG_FUNCTION_ARGS)
Definition: geo_selfuncs.c:67
record_ne
Datum record_ne(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1231
path_n_gt
Datum path_n_gt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1464
timestamptz_eq_date
Datum timestamptz_eq_date(PG_FUNCTION_ARGS)
Definition: date.c:863
timestamp_le
Datum timestamp_le(PG_FUNCTION_ARGS)
Definition: timestamp.c:2279
int28pl
Datum int28pl(PG_FUNCTION_ARGS)
Definition: int8.c:1124
uuid_ne
Datum uuid_ne(PG_FUNCTION_ARGS)
Definition: uuid.c:224
float84le
Datum float84le(PG_FUNCTION_ARGS)
Definition: float.c:3482
int42ge
Datum int42ge(PG_FUNCTION_ARGS)
Definition: int.c:597
point_above
Datum point_above(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1839
date_ge_timestamp
Datum date_ge_timestamp(PG_FUNCTION_ARGS)
Definition: date.c:671
date_mi_interval
Datum date_mi_interval(PG_FUNCTION_ARGS)
Definition: date.c:974
int2pl
Datum int2pl(PG_FUNCTION_ARGS)
Definition: int.c:788
tidgt
Datum tidgt(PG_FUNCTION_ARGS)
Definition: tid.c:204
jsonb_ge
Datum jsonb_ge(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:208
timestamp_lt_date
Datum timestamp_lt_date(PG_FUNCTION_ARGS)
Definition: date.c:803
bitnot
Datum bitnot(PG_FUNCTION_ARGS)
Definition: varbit.c:1344
oidlt
Datum oidlt(PG_FUNCTION_ARGS)
Definition: oid.c:355
float48div
Datum float48div(PG_FUNCTION_ARGS)
Definition: float.c:3308
tidne
Datum tidne(PG_FUNCTION_ARGS)
Definition: tid.c:177
close_lseg
Datum close_lseg(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2872
tsvector_lt
Datum tsvector_lt(PG_FUNCTION_ARGS)
interval_gt
Datum interval_gt(PG_FUNCTION_ARGS)
Definition: timestamp.c:2569
dist_ppoly
Datum dist_ppoly(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2584
network_sub
Datum network_sub(PG_FUNCTION_ARGS)
Definition: network.c:518
box_overabove
Datum box_overabove(PG_FUNCTION_ARGS)
Definition: geo_ops.c:625
int42pl
Datum int42pl(PG_FUNCTION_ARGS)
Definition: int.c:979
tsquery_lt
Datum tsquery_lt(PG_FUNCTION_ARGS)
tintervalne
Datum tintervalne(PG_FUNCTION_ARGS)
Definition: nabstime.c:1202
jsonb_ne
Datum jsonb_ne(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:149
network_supeq
Datum network_supeq(PG_FUNCTION_ARGS)
Definition: network.c:563
record_eq
Datum record_eq(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1018
path_mul_pt
Datum path_mul_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4308
box_ge
Datum box_ge(PG_FUNCTION_ARGS)
Definition: geo_ops.c:729
poly_center
Datum poly_center(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4414
abstimege
Datum abstimege(PG_FUNCTION_ARGS)
Definition: nabstime.c:411
int48ne
Datum int48ne(PG_FUNCTION_ARGS)
Definition: int8.c:326
int2_mul_cash
Datum int2_mul_cash(PG_FUNCTION_ARGS)
Definition: cash.c:835
record_image_ge
Datum record_image_ge(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1811
int8not
Datum int8not(PG_FUNCTION_ARGS)
Definition: int8.c:1249
oidge
#define oidge(x, y)
Definition: pg_dump.h:23
array_append
Datum array_append(PG_FUNCTION_ARGS)
Definition: array_userfuncs.c:88
int4shr
Datum int4shr(PG_FUNCTION_ARGS)
Definition: int.c:1262
time_ge
Datum time_ge(PG_FUNCTION_ARGS)
Definition: date.c:1485
array_prepend
Datum array_prepend(PG_FUNCTION_ARGS)
Definition: array_userfuncs.c:145
numeric_ge
Datum numeric_ge(PG_FUNCTION_ARGS)
Definition: numeric.c:2035
uuid_lt
Datum uuid_lt(PG_FUNCTION_ARGS)
Definition: uuid.c:179
oidvectoreq
Datum oidvectoreq(PG_FUNCTION_ARGS)
Definition: oid.c:409
int28mi
Datum int28mi(PG_FUNCTION_ARGS)
Definition: int8.c:1145
float8le
Datum float8le(PG_FUNCTION_ARGS)
Definition: float.c:1111
timestamptz_le_timestamp
Datum timestamptz_le_timestamp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2473
date_mi
Datum date_mi(PG_FUNCTION_ARGS)
Definition: date.c:423
int48le
Datum int48le(PG_FUNCTION_ARGS)
Definition: int8.c:353
jsonb_extract_path
Datum jsonb_extract_path(PG_FUNCTION_ARGS)
Definition: jsonfuncs.c:1158
path_length
Datum path_length(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1697
byteale
Datum byteale(PG_FUNCTION_ARGS)
Definition: varlena.c:3435
cash_mul_int2
Datum cash_mul_int2(PG_FUNCTION_ARGS)
Definition: cash.c:821
float84eq
Datum float84eq(PG_FUNCTION_ARGS)
Definition: float.c:3455
jsonb_contained
Datum jsonb_contained(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:130
nlikejoinsel
Datum nlikejoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2797
networksel
Datum networksel(PG_FUNCTION_ARGS)
Definition: network_selfuncs.c:78
int4eq
Datum int4eq(PG_FUNCTION_ARGS)
Definition: int.c:390
jsonb_le
Datum jsonb_le(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:194
float48gt
Datum float48gt(PG_FUNCTION_ARGS)
Definition: float.c:3434
int42mi
Datum int42mi(PG_FUNCTION_ARGS)
Definition: int.c:1000
numeric_add
Datum numeric_add(PG_FUNCTION_ARGS)
Definition: numeric.c:2202
jsonb_exists_all
Datum jsonb_exists_all(PG_FUNCTION_ARGS)
Definition: jsonb_op.c:79
int24pl
Datum int24pl(PG_FUNCTION_ARGS)
Definition: int.c:891
tideq
Datum tideq(PG_FUNCTION_ARGS)
Definition: tid.c:168
neqjoinsel
Datum neqjoinsel(PG_FUNCTION_ARGS)
Definition: selfuncs.c:2678
close_sb
Datum close_sb(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3042
on_ps
Datum on_ps(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3137
oidle
#define oidle(x, y)
Definition: pg_dump.h:22
float4um
Datum float4um(PG_FUNCTION_ARGS)
Definition: float.c:677
int8up
Datum int8up(PG_FUNCTION_ARGS)
Definition: int8.c:505
bitne
Datum bitne(PG_FUNCTION_ARGS)
Definition: varbit.c:844
line_horizontal
Datum line_horizontal(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1140
ts_match_tt
Datum ts_match_tt(PG_FUNCTION_ARGS)
Definition: tsvector_op.c:1617
circle_add_pt
Datum circle_add_pt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:4879
int8mod
Datum int8mod(PG_FUNCTION_ARGS)
Definition: int8.c:648
reltimelt
Datum reltimelt(PG_FUNCTION_ARGS)
Definition: nabstime.c:1062
int2gt
Datum int2gt(PG_FUNCTION_ARGS)
Definition: int.c:480
path_npoints
Datum path_npoints(PG_FUNCTION_ARGS)
Definition: geo_ops.c:1520
cash_gt
Datum cash_gt(PG_FUNCTION_ARGS)
Definition: cash.c:530
record_image_eq
Datum record_image_eq(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1556
DATA
DATA(insert OID=15("="PGNSP PGUID b t t 23 20 16 416 36 int48eq eqsel eqjoinsel))
ts_match_tq
Datum ts_match_tq(PG_FUNCTION_ARGS)
Definition: tsvector_op.c:1639
int42le
Datum int42le(PG_FUNCTION_ARGS)
Definition: int.c:579
poly_above
Datum poly_above(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3663
pg_lsn_ne
Datum pg_lsn_ne(PG_FUNCTION_ARGS)
Definition: pg_lsn.c:113
text_pattern_ge
Datum text_pattern_ge(PG_FUNCTION_ARGS)
Definition: varlena.c:2528
dist_cpoint
Datum dist_cpoint(PG_FUNCTION_ARGS)
Definition: geo_ops.c:5048
date_pl_interval
Datum date_pl_interval(PG_FUNCTION_ARGS)
Definition: date.c:954
arraycontjoinsel
Datum arraycontjoinsel(PG_FUNCTION_ARGS)
Definition: array_selfuncs.c:330
date_ge
Datum date_ge(PG_FUNCTION_ARGS)
Definition: date.c:351
inetand
Datum inetand(PG_FUNCTION_ARGS)
Definition: network.c:1332
uuid_eq
Datum uuid_eq(PG_FUNCTION_ARGS)
Definition: uuid.c:197
nameeq
Datum nameeq(PG_FUNCTION_ARGS)
Definition: name.c:134
int2le
Datum int2le(PG_FUNCTION_ARGS)
Definition: int.c:471
record_image_lt
Datum record_image_lt(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1793
lseg_gt
Datum lseg_gt(PG_FUNCTION_ARGS)
Definition: geo_ops.c:2179
tsquery_or
Datum tsquery_or(PG_FUNCTION_ARGS)
Definition: tsquery_op.c:81
timestamp_eq_date
Datum timestamp_eq_date(PG_FUNCTION_ARGS)
Definition: date.c:779
range_adjacent
Datum range_adjacent(PG_FUNCTION_ARGS)
Definition: rangetypes.c:811
macaddr_gt
Datum macaddr_gt(PG_FUNCTION_ARGS)
Definition: mac.c:219
poly_same
Datum poly_same(PG_FUNCTION_ARGS)
Definition: geo_ops.c:3712
record_image_ne
Datum record_image_ne(PG_FUNCTION_ARGS)
Definition: rowtypes.c:1787
byteacat
Datum byteacat(PG_FUNCTION_ARGS)
Definition: varlena.c:2615
booleq
Datum booleq(PG_FUNCTION_ARGS)
Definition: bool.c:229
date_pli
Datum date_pli(PG_FUNCTION_ARGS)
Definition: date.c:440
tsmatchjoinsel
Datum tsmatchjoinsel(PG_FUNCTION_ARGS)
Definition: ts_selfuncs.c:139