1 /*-------------------------------------------------------------------------
4 * definition of the system "operator" relation (pg_operator)
5 * along with the relation's initial contents.
8 * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
9 * Portions Copyright (c) 1994, Regents of the University of California
11 * $Id: pg_operator.h,v 1.102 2002/04/16 23:08:11 tgl Exp $
14 * the genbki.sh script reads this file and generates .bki
15 * information from the DATA() statements.
17 * XXX do NOT break up DATA() statements into multiple lines!
18 * the scripts are not as smart as you might think...
20 *-------------------------------------------------------------------------
25 #include "nodes/pg_list.h"
28 * postgres.h contains the system type definintions and the
29 * CATALOG(), BOOTSTRAP and DATA() sugar words so this file
30 * can be read by both genbki.sh and the C compiler.
35 * pg_operator definition. cpp turns this into
36 * typedef struct FormData_pg_operator
41 NameData oprname; /* name of operator */
42 Oid oprnamespace; /* OID of namespace containing this oper */
43 int4 oprowner; /* oper owner */
44 int2 oprprec; /* precedence (not currently used) */
45 char oprkind; /* 'l', 'r', or 'b' */
46 bool oprisleft; /* left associative (not currently used) */
47 bool oprcanhash; /* can be used in hash join? */
48 Oid oprleft; /* left arg type, or 0 if 'l' oprkind */
49 Oid oprright; /* right arg type, or 0 if 'r' oprkind */
50 Oid oprresult; /* result datatype */
51 Oid oprcom; /* OID of commutator oper, or 0 if none */
52 Oid oprnegate; /* OID of negator oper, or 0 if none */
53 Oid oprlsortop; /* OID of left sortop, if mergejoinable */
54 Oid oprrsortop; /* OID of right sortop, if mergejoinable */
55 Oid oprltcmpop; /* OID of "l<r" oper, if mergejoinable */
56 Oid oprgtcmpop; /* OID of "l>r" oper, if mergejoinable */
57 regproc oprcode; /* OID of underlying function */
58 regproc oprrest; /* OID of restriction estimator, or 0 */
59 regproc oprjoin; /* OID of join estimator, or 0 */
60 } FormData_pg_operator;
63 * Form_pg_operator corresponds to a pointer to a tuple with
64 * the format of pg_operator relation.
67 typedef FormData_pg_operator *Form_pg_operator;
70 * compiler constants for pg_operator
74 #define Natts_pg_operator 19
75 #define Anum_pg_operator_oprname 1
76 #define Anum_pg_operator_oprnamespace 2
77 #define Anum_pg_operator_oprowner 3
78 #define Anum_pg_operator_oprprec 4
79 #define Anum_pg_operator_oprkind 5
80 #define Anum_pg_operator_oprisleft 6
81 #define Anum_pg_operator_oprcanhash 7
82 #define Anum_pg_operator_oprleft 8
83 #define Anum_pg_operator_oprright 9
84 #define Anum_pg_operator_oprresult 10
85 #define Anum_pg_operator_oprcom 11
86 #define Anum_pg_operator_oprnegate 12
87 #define Anum_pg_operator_oprlsortop 13
88 #define Anum_pg_operator_oprrsortop 14
89 #define Anum_pg_operator_oprltcmpop 15
90 #define Anum_pg_operator_oprgtcmpop 16
91 #define Anum_pg_operator_oprcode 17
92 #define Anum_pg_operator_oprrest 18
93 #define Anum_pg_operator_oprjoin 19
96 * initial contents of pg_operator
100 DATA(insert OID = 15 ( "=" PGNSP PGUID 0 b t f 23 20 16 416 36 97 412 37 76 int48eq eqsel eqjoinsel ));
101 DATA(insert OID = 36 ( "<>" PGNSP PGUID 0 b t f 23 20 16 417 15 0 0 0 0 int48ne neqsel neqjoinsel ));
102 DATA(insert OID = 37 ( "<" PGNSP PGUID 0 b t f 23 20 16 419 82 0 0 0 0 int48lt scalarltsel scalarltjoinsel ));
103 DATA(insert OID = 76 ( ">" PGNSP PGUID 0 b t f 23 20 16 418 80 0 0 0 0 int48gt scalargtsel scalargtjoinsel ));
104 DATA(insert OID = 80 ( "<=" PGNSP PGUID 0 b t f 23 20 16 430 76 0 0 0 0 int48le scalarltsel scalarltjoinsel ));
105 DATA(insert OID = 82 ( ">=" PGNSP PGUID 0 b t f 23 20 16 420 37 0 0 0 0 int48ge scalargtsel scalargtjoinsel ));
107 DATA(insert OID = 58 ( "<" PGNSP PGUID 0 b t f 16 16 16 59 1695 0 0 0 0 boollt scalarltsel scalarltjoinsel ));
108 DATA(insert OID = 59 ( ">" PGNSP PGUID 0 b t f 16 16 16 58 1694 0 0 0 0 boolgt scalargtsel scalargtjoinsel ));
109 DATA(insert OID = 85 ( "<>" PGNSP PGUID 0 b t f 16 16 16 85 91 0 0 0 0 boolne neqsel neqjoinsel ));
110 DATA(insert OID = 91 ( "=" PGNSP PGUID 0 b t t 16 16 16 91 85 58 58 58 59 booleq eqsel eqjoinsel ));
111 #define BooleanEqualOperator 91
112 DATA(insert OID = 1694 ( "<=" PGNSP PGUID 0 b t f 16 16 16 1695 59 0 0 0 0 boolle scalarltsel scalarltjoinsel ));
113 DATA(insert OID = 1695 ( ">=" PGNSP PGUID 0 b t f 16 16 16 1694 58 0 0 0 0 boolge scalargtsel scalargtjoinsel ));
115 DATA(insert OID = 92 ( "=" PGNSP PGUID 0 b t t 18 18 16 92 630 631 631 631 633 chareq eqsel eqjoinsel ));
116 DATA(insert OID = 93 ( "=" PGNSP PGUID 0 b t t 19 19 16 93 643 660 660 660 662 nameeq eqsel eqjoinsel ));
117 DATA(insert OID = 94 ( "=" PGNSP PGUID 0 b t t 21 21 16 94 519 95 95 95 520 int2eq eqsel eqjoinsel ));
118 DATA(insert OID = 95 ( "<" PGNSP PGUID 0 b t f 21 21 16 520 524 0 0 0 0 int2lt scalarltsel scalarltjoinsel ));
119 DATA(insert OID = 96 ( "=" PGNSP PGUID 0 b t t 23 23 16 96 518 97 97 97 521 int4eq eqsel eqjoinsel ));
120 DATA(insert OID = 97 ( "<" PGNSP PGUID 0 b t f 23 23 16 521 525 0 0 0 0 int4lt scalarltsel scalarltjoinsel ));
121 DATA(insert OID = 98 ( "=" PGNSP PGUID 0 b t t 25 25 16 98 531 664 664 664 666 texteq eqsel eqjoinsel ));
123 DATA(insert OID = 329 ( "=" PGNSP PGUID 0 b t f 1000 1000 16 329 0 0 0 0 0 array_eq eqsel eqjoinsel ));
124 DATA(insert OID = 349 ( "=" PGNSP PGUID 0 b t f 1001 1001 16 349 0 0 0 0 0 array_eq eqsel eqjoinsel ));
125 DATA(insert OID = 374 ( "=" PGNSP PGUID 0 b t f 1002 1002 16 374 0 0 0 0 0 array_eq eqsel eqjoinsel ));
126 DATA(insert OID = 375 ( "=" PGNSP PGUID 0 b t f 1003 1003 16 375 0 0 0 0 0 array_eq eqsel eqjoinsel ));
127 DATA(insert OID = 377 ( "=" PGNSP PGUID 0 b t f 1005 1005 16 377 0 0 0 0 0 array_eq eqsel eqjoinsel ));
128 DATA(insert OID = 378 ( "=" PGNSP PGUID 0 b t f 1006 1006 16 378 0 0 0 0 0 array_eq eqsel eqjoinsel ));
129 DATA(insert OID = 379 ( "=" PGNSP PGUID 0 b t f 1007 1007 16 379 0 0 0 0 0 array_eq eqsel eqjoinsel ));
130 DATA(insert OID = 380 ( "=" PGNSP PGUID 0 b t f 1008 1008 16 380 0 0 0 0 0 array_eq eqsel eqjoinsel ));
131 DATA(insert OID = 381 ( "=" PGNSP PGUID 0 b t f 1009 1009 16 381 0 0 0 0 0 array_eq eqsel eqjoinsel ));
132 DATA(insert OID = 382 ( "=" PGNSP PGUID 0 b t f 1028 1028 16 382 0 0 0 0 0 array_eq eqsel eqjoinsel ));
133 DATA(insert OID = 383 ( "=" PGNSP PGUID 0 b t f 1010 1010 16 383 0 0 0 0 0 array_eq eqsel eqjoinsel ));
134 DATA(insert OID = 384 ( "=" PGNSP PGUID 0 b t f 1011 1011 16 384 0 0 0 0 0 array_eq eqsel eqjoinsel ));
135 DATA(insert OID = 385 ( "=" PGNSP PGUID 0 b t f 1012 1012 16 385 0 0 0 0 0 array_eq eqsel eqjoinsel ));
136 DATA(insert OID = 386 ( "=" PGNSP PGUID 0 b t f 1013 1013 16 386 0 0 0 0 0 array_eq eqsel eqjoinsel ));
137 DATA(insert OID = 390 ( "=" PGNSP PGUID 0 b t f 1017 1017 16 390 0 0 0 0 0 array_eq eqsel eqjoinsel ));
138 DATA(insert OID = 391 ( "=" PGNSP PGUID 0 b t f 1018 1018 16 391 0 0 0 0 0 array_eq eqsel eqjoinsel ));
139 DATA(insert OID = 392 ( "=" PGNSP PGUID 0 b t f 1019 1019 16 392 0 0 0 0 0 array_eq eqsel eqjoinsel ));
140 DATA(insert OID = 393 ( "=" PGNSP PGUID 0 b t f 1020 1020 16 393 0 0 0 0 0 array_eq eqsel eqjoinsel ));
141 DATA(insert OID = 394 ( "=" PGNSP PGUID 0 b t f 1021 1021 16 394 0 0 0 0 0 array_eq eqsel eqjoinsel ));
142 DATA(insert OID = 395 ( "=" PGNSP PGUID 0 b t f 1022 1022 16 395 0 0 0 0 0 array_eq eqsel eqjoinsel ));
143 DATA(insert OID = 396 ( "=" PGNSP PGUID 0 b t f 1023 1023 16 396 0 0 0 0 0 array_eq eqsel eqjoinsel ));
144 DATA(insert OID = 397 ( "=" PGNSP PGUID 0 b t f 1024 1024 16 397 0 0 0 0 0 array_eq eqsel eqjoinsel ));
145 DATA(insert OID = 398 ( "=" PGNSP PGUID 0 b t f 1025 1025 16 398 0 0 0 0 0 array_eq eqsel eqjoinsel ));
146 DATA(insert OID = 400 ( "=" PGNSP PGUID 0 b t f 1027 1027 16 400 0 0 0 0 0 array_eq eqsel eqjoinsel ));
147 DATA(insert OID = 401 ( "=" PGNSP PGUID 0 b t f 1034 1034 16 401 0 0 0 0 0 array_eq eqsel eqjoinsel ));
149 DATA(insert OID = 352 ( "=" PGNSP PGUID 0 b t t 28 28 16 352 0 0 0 0 0 xideq eqsel eqjoinsel ));
150 DATA(insert OID = 353 ( "=" PGNSP PGUID 0 b t t 28 23 16 0 0 0 0 0 0 xideq eqsel eqjoinsel ));
151 DATA(insert OID = 387 ( "=" PGNSP PGUID 0 b t t 27 27 16 387 0 0 0 0 0 tideq eqsel eqjoinsel ));
152 #define TIDEqualOperator 387
153 DATA(insert OID = 388 ( "!" PGNSP PGUID 0 r t f 20 0 20 0 0 0 0 0 0 int8fac - - ));
154 DATA(insert OID = 389 ( "!!" PGNSP PGUID 0 l t f 0 20 20 0 0 0 0 0 0 int8fac - - ));
156 DATA(insert OID = 410 ( "=" PGNSP PGUID 0 b t t 20 20 16 410 411 412 412 412 413 int8eq eqsel eqjoinsel ));
157 DATA(insert OID = 411 ( "<>" PGNSP PGUID 0 b t f 20 20 16 411 410 0 0 0 0 int8ne neqsel neqjoinsel ));
158 DATA(insert OID = 412 ( "<" PGNSP PGUID 0 b t f 20 20 16 413 415 0 0 0 0 int8lt scalarltsel scalarltjoinsel ));
159 DATA(insert OID = 413 ( ">" PGNSP PGUID 0 b t f 20 20 16 412 414 0 0 0 0 int8gt scalargtsel scalargtjoinsel ));
160 DATA(insert OID = 414 ( "<=" PGNSP PGUID 0 b t f 20 20 16 415 413 0 0 0 0 int8le scalarltsel scalarltjoinsel ));
161 DATA(insert OID = 415 ( ">=" PGNSP PGUID 0 b t f 20 20 16 414 412 0 0 0 0 int8ge scalargtsel scalargtjoinsel ));
163 DATA(insert OID = 416 ( "=" PGNSP PGUID 0 b t f 20 23 16 15 417 412 97 418 419 int84eq eqsel eqjoinsel ));
164 DATA(insert OID = 417 ( "<>" PGNSP PGUID 0 b t f 20 23 16 36 416 0 0 0 0 int84ne neqsel neqjoinsel ));
165 DATA(insert OID = 418 ( "<" PGNSP PGUID 0 b t f 20 23 16 76 430 0 0 0 0 int84lt scalarltsel scalarltjoinsel ));
166 DATA(insert OID = 419 ( ">" PGNSP PGUID 0 b t f 20 23 16 37 420 0 0 0 0 int84gt scalargtsel scalargtjoinsel ));
167 DATA(insert OID = 420 ( "<=" PGNSP PGUID 0 b t f 20 23 16 82 419 0 0 0 0 int84le scalarltsel scalarltjoinsel ));
168 DATA(insert OID = 430 ( ">=" PGNSP PGUID 0 b t f 20 23 16 80 418 0 0 0 0 int84ge scalargtsel scalargtjoinsel ));
169 DATA(insert OID = 439 ( "%" PGNSP PGUID 0 b t f 20 20 20 0 0 0 0 0 0 int8mod - - ));
170 DATA(insert OID = 473 ( "@" PGNSP PGUID 0 l t f 0 20 20 0 0 0 0 0 0 int8abs - - ));
172 DATA(insert OID = 484 ( "-" PGNSP PGUID 0 l t f 0 20 20 0 0 0 0 0 0 int8um - - ));
173 DATA(insert OID = 485 ( "<<" PGNSP PGUID 0 b t f 604 604 16 0 0 0 0 0 0 poly_left positionsel positionjoinsel ));
174 DATA(insert OID = 486 ( "&<" PGNSP PGUID 0 b t f 604 604 16 0 0 0 0 0 0 poly_overleft positionsel positionjoinsel ));
175 DATA(insert OID = 487 ( "&>" PGNSP PGUID 0 b t f 604 604 16 0 0 0 0 0 0 poly_overright positionsel positionjoinsel ));
176 DATA(insert OID = 488 ( ">>" PGNSP PGUID 0 b t f 604 604 16 0 0 0 0 0 0 poly_right positionsel positionjoinsel ));
177 DATA(insert OID = 489 ( "@" PGNSP PGUID 0 b t f 604 604 16 490 0 0 0 0 0 poly_contained contsel contjoinsel ));
178 DATA(insert OID = 490 ( "~" PGNSP PGUID 0 b t f 604 604 16 489 0 0 0 0 0 poly_contain contsel contjoinsel ));
179 DATA(insert OID = 491 ( "~=" PGNSP PGUID 0 b t f 604 604 16 491 0 0 0 0 0 poly_same eqsel eqjoinsel ));
180 DATA(insert OID = 492 ( "&&" PGNSP PGUID 0 b t f 604 604 16 492 0 0 0 0 0 poly_overlap areasel areajoinsel ));
181 DATA(insert OID = 493 ( "<<" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_left positionsel positionjoinsel ));
182 DATA(insert OID = 494 ( "&<" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_overleft positionsel positionjoinsel ));
183 DATA(insert OID = 495 ( "&>" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_overright positionsel positionjoinsel ));
184 DATA(insert OID = 496 ( ">>" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_right positionsel positionjoinsel ));
185 DATA(insert OID = 497 ( "@" PGNSP PGUID 0 b t f 603 603 16 498 0 0 0 0 0 box_contained contsel contjoinsel ));
186 DATA(insert OID = 498 ( "~" PGNSP PGUID 0 b t f 603 603 16 497 0 0 0 0 0 box_contain contsel contjoinsel ));
187 DATA(insert OID = 499 ( "~=" PGNSP PGUID 0 b t f 603 603 16 499 0 0 0 0 0 box_same eqsel eqjoinsel ));
188 DATA(insert OID = 500 ( "&&" PGNSP PGUID 0 b t f 603 603 16 500 0 0 0 0 0 box_overlap areasel areajoinsel ));
189 DATA(insert OID = 501 ( ">=" PGNSP PGUID 0 b t f 603 603 16 505 504 0 0 0 0 box_ge areasel areajoinsel ));
190 DATA(insert OID = 502 ( ">" PGNSP PGUID 0 b t f 603 603 16 504 505 0 0 0 0 box_gt areasel areajoinsel ));
191 DATA(insert OID = 503 ( "=" PGNSP PGUID 0 b t f 603 603 16 503 0 504 504 504 502 box_eq eqsel eqjoinsel ));
192 DATA(insert OID = 504 ( "<" PGNSP PGUID 0 b t f 603 603 16 502 501 0 0 0 0 box_lt areasel areajoinsel ));
193 DATA(insert OID = 505 ( "<=" PGNSP PGUID 0 b t f 603 603 16 501 502 0 0 0 0 box_le areasel areajoinsel ));
194 DATA(insert OID = 506 ( ">^" PGNSP PGUID 0 b t f 600 600 16 0 0 0 0 0 0 point_above positionsel positionjoinsel ));
195 DATA(insert OID = 507 ( "<<" PGNSP PGUID 0 b t f 600 600 16 0 0 0 0 0 0 point_left positionsel positionjoinsel ));
196 DATA(insert OID = 508 ( ">>" PGNSP PGUID 0 b t f 600 600 16 0 0 0 0 0 0 point_right positionsel positionjoinsel ));
197 DATA(insert OID = 509 ( "<^" PGNSP PGUID 0 b t f 600 600 16 0 0 0 0 0 0 point_below positionsel positionjoinsel ));
198 DATA(insert OID = 510 ( "~=" PGNSP PGUID 0 b t f 600 600 16 510 0 0 0 0 0 point_eq eqsel eqjoinsel ));
199 DATA(insert OID = 511 ( "@" PGNSP PGUID 0 b t f 600 603 16 0 0 0 0 0 0 on_pb - - ));
200 DATA(insert OID = 512 ( "@" PGNSP PGUID 0 b t f 600 602 16 755 0 0 0 0 0 on_ppath - - ));
201 DATA(insert OID = 513 ( "@@" PGNSP PGUID 0 l t f 0 603 600 0 0 0 0 0 0 box_center - - ));
202 DATA(insert OID = 514 ( "*" PGNSP PGUID 0 b t f 23 23 23 514 0 0 0 0 0 int4mul - - ));
203 DATA(insert OID = 515 ( "!" PGNSP PGUID 0 r t f 23 0 23 0 0 0 0 0 0 int4fac - - ));
204 DATA(insert OID = 516 ( "!!" PGNSP PGUID 0 l t f 0 23 23 0 0 0 0 0 0 int4fac - - ));
205 DATA(insert OID = 517 ( "<->" PGNSP PGUID 0 b t f 600 600 701 517 0 0 0 0 0 point_distance - - ));
206 DATA(insert OID = 518 ( "<>" PGNSP PGUID 0 b t f 23 23 16 518 96 0 0 0 0 int4ne neqsel neqjoinsel ));
207 DATA(insert OID = 519 ( "<>" PGNSP PGUID 0 b t f 21 21 16 519 94 0 0 0 0 int2ne neqsel neqjoinsel ));
208 DATA(insert OID = 520 ( ">" PGNSP PGUID 0 b t f 21 21 16 95 522 0 0 0 0 int2gt scalargtsel scalargtjoinsel ));
209 DATA(insert OID = 521 ( ">" PGNSP PGUID 0 b t f 23 23 16 97 523 0 0 0 0 int4gt scalargtsel scalargtjoinsel ));
210 DATA(insert OID = 522 ( "<=" PGNSP PGUID 0 b t f 21 21 16 524 520 0 0 0 0 int2le scalarltsel scalarltjoinsel ));
211 DATA(insert OID = 523 ( "<=" PGNSP PGUID 0 b t f 23 23 16 525 521 0 0 0 0 int4le scalarltsel scalarltjoinsel ));
212 DATA(insert OID = 524 ( ">=" PGNSP PGUID 0 b t f 21 21 16 522 95 0 0 0 0 int2ge scalargtsel scalargtjoinsel ));
213 DATA(insert OID = 525 ( ">=" PGNSP PGUID 0 b t f 23 23 16 523 97 0 0 0 0 int4ge scalargtsel scalargtjoinsel ));
214 DATA(insert OID = 526 ( "*" PGNSP PGUID 0 b t f 21 21 21 526 0 0 0 0 0 int2mul - - ));
215 DATA(insert OID = 527 ( "/" PGNSP PGUID 0 b t f 21 21 21 0 0 0 0 0 0 int2div - - ));
216 DATA(insert OID = 528 ( "/" PGNSP PGUID 0 b t f 23 23 23 0 0 0 0 0 0 int4div - - ));
217 DATA(insert OID = 529 ( "%" PGNSP PGUID 0 b t f 21 21 21 0 0 0 0 0 0 int2mod - - ));
218 DATA(insert OID = 530 ( "%" PGNSP PGUID 0 b t f 23 23 23 0 0 0 0 0 0 int4mod - - ));
219 DATA(insert OID = 531 ( "<>" PGNSP PGUID 0 b t f 25 25 16 531 98 0 0 0 0 textne neqsel neqjoinsel ));
220 DATA(insert OID = 532 ( "=" PGNSP PGUID 0 b t f 21 23 16 533 538 95 97 534 536 int24eq eqsel eqjoinsel ));
221 DATA(insert OID = 533 ( "=" PGNSP PGUID 0 b t f 23 21 16 532 539 97 95 535 537 int42eq eqsel eqjoinsel ));
222 DATA(insert OID = 534 ( "<" PGNSP PGUID 0 b t f 21 23 16 537 542 0 0 0 0 int24lt scalarltsel scalarltjoinsel ));
223 DATA(insert OID = 535 ( "<" PGNSP PGUID 0 b t f 23 21 16 536 543 0 0 0 0 int42lt scalarltsel scalarltjoinsel ));
224 DATA(insert OID = 536 ( ">" PGNSP PGUID 0 b t f 21 23 16 535 540 0 0 0 0 int24gt scalargtsel scalargtjoinsel ));
225 DATA(insert OID = 537 ( ">" PGNSP PGUID 0 b t f 23 21 16 534 541 0 0 0 0 int42gt scalargtsel scalargtjoinsel ));
226 DATA(insert OID = 538 ( "<>" PGNSP PGUID 0 b t f 21 23 16 539 532 0 0 0 0 int24ne neqsel neqjoinsel ));
227 DATA(insert OID = 539 ( "<>" PGNSP PGUID 0 b t f 23 21 16 538 533 0 0 0 0 int42ne neqsel neqjoinsel ));
228 DATA(insert OID = 540 ( "<=" PGNSP PGUID 0 b t f 21 23 16 543 536 0 0 0 0 int24le scalarltsel scalarltjoinsel ));
229 DATA(insert OID = 541 ( "<=" PGNSP PGUID 0 b t f 23 21 16 542 537 0 0 0 0 int42le scalarltsel scalarltjoinsel ));
230 DATA(insert OID = 542 ( ">=" PGNSP PGUID 0 b t f 21 23 16 541 534 0 0 0 0 int24ge scalargtsel scalargtjoinsel ));
231 DATA(insert OID = 543 ( ">=" PGNSP PGUID 0 b t f 23 21 16 540 535 0 0 0 0 int42ge scalargtsel scalargtjoinsel ));
232 DATA(insert OID = 544 ( "*" PGNSP PGUID 0 b t f 21 23 23 545 0 0 0 0 0 int24mul - - ));
233 DATA(insert OID = 545 ( "*" PGNSP PGUID 0 b t f 23 21 23 544 0 0 0 0 0 int42mul - - ));
234 DATA(insert OID = 546 ( "/" PGNSP PGUID 0 b t f 21 23 23 0 0 0 0 0 0 int24div - - ));
235 DATA(insert OID = 547 ( "/" PGNSP PGUID 0 b t f 23 21 23 0 0 0 0 0 0 int42div - - ));
236 DATA(insert OID = 548 ( "%" PGNSP PGUID 0 b t f 21 23 23 0 0 0 0 0 0 int24mod - - ));
237 DATA(insert OID = 549 ( "%" PGNSP PGUID 0 b t f 23 21 23 0 0 0 0 0 0 int42mod - - ));
238 DATA(insert OID = 550 ( "+" PGNSP PGUID 0 b t f 21 21 21 550 0 0 0 0 0 int2pl - - ));
239 DATA(insert OID = 551 ( "+" PGNSP PGUID 0 b t f 23 23 23 551 0 0 0 0 0 int4pl - - ));
240 DATA(insert OID = 552 ( "+" PGNSP PGUID 0 b t f 21 23 23 553 0 0 0 0 0 int24pl - - ));
241 DATA(insert OID = 553 ( "+" PGNSP PGUID 0 b t f 23 21 23 552 0 0 0 0 0 int42pl - - ));
242 DATA(insert OID = 554 ( "-" PGNSP PGUID 0 b t f 21 21 21 0 0 0 0 0 0 int2mi - - ));
243 DATA(insert OID = 555 ( "-" PGNSP PGUID 0 b t f 23 23 23 0 0 0 0 0 0 int4mi - - ));
244 DATA(insert OID = 556 ( "-" PGNSP PGUID 0 b t f 21 23 23 0 0 0 0 0 0 int24mi - - ));
245 DATA(insert OID = 557 ( "-" PGNSP PGUID 0 b t f 23 21 23 0 0 0 0 0 0 int42mi - - ));
246 DATA(insert OID = 558 ( "-" PGNSP PGUID 0 l t f 0 23 23 0 0 0 0 0 0 int4um - - ));
247 DATA(insert OID = 559 ( "-" PGNSP PGUID 0 l t f 0 21 21 0 0 0 0 0 0 int2um - - ));
248 DATA(insert OID = 560 ( "=" PGNSP PGUID 0 b t t 702 702 16 560 561 562 562 562 563 abstimeeq eqsel eqjoinsel ));
249 DATA(insert OID = 561 ( "<>" PGNSP PGUID 0 b t f 702 702 16 561 560 0 0 0 0 abstimene neqsel neqjoinsel ));
250 DATA(insert OID = 562 ( "<" PGNSP PGUID 0 b t f 702 702 16 563 565 0 0 0 0 abstimelt scalarltsel scalarltjoinsel ));
251 DATA(insert OID = 563 ( ">" PGNSP PGUID 0 b t f 702 702 16 562 564 0 0 0 0 abstimegt scalargtsel scalargtjoinsel ));
252 DATA(insert OID = 564 ( "<=" PGNSP PGUID 0 b t f 702 702 16 565 563 0 0 0 0 abstimele scalarltsel scalarltjoinsel ));
253 DATA(insert OID = 565 ( ">=" PGNSP PGUID 0 b t f 702 702 16 564 562 0 0 0 0 abstimege scalargtsel scalargtjoinsel ));
254 DATA(insert OID = 566 ( "=" PGNSP PGUID 0 b t t 703 703 16 566 567 568 568 568 569 reltimeeq eqsel eqjoinsel ));
255 DATA(insert OID = 567 ( "<>" PGNSP PGUID 0 b t f 703 703 16 567 566 0 0 0 0 reltimene neqsel neqjoinsel ));
256 DATA(insert OID = 568 ( "<" PGNSP PGUID 0 b t f 703 703 16 569 571 0 0 0 0 reltimelt scalarltsel scalarltjoinsel ));
257 DATA(insert OID = 569 ( ">" PGNSP PGUID 0 b t f 703 703 16 568 570 0 0 0 0 reltimegt scalargtsel scalargtjoinsel ));
258 DATA(insert OID = 570 ( "<=" PGNSP PGUID 0 b t f 703 703 16 571 569 0 0 0 0 reltimele scalarltsel scalarltjoinsel ));
259 DATA(insert OID = 571 ( ">=" PGNSP PGUID 0 b t f 703 703 16 570 568 0 0 0 0 reltimege scalargtsel scalargtjoinsel ));
260 DATA(insert OID = 572 ( "~=" PGNSP PGUID 0 b t f 704 704 16 572 0 0 0 0 0 tintervalsame eqsel eqjoinsel ));
261 DATA(insert OID = 573 ( "<<" PGNSP PGUID 0 b t f 704 704 16 0 0 0 0 0 0 tintervalct - - ));
262 DATA(insert OID = 574 ( "&&" PGNSP PGUID 0 b t f 704 704 16 574 0 0 0 0 0 tintervalov - - ));
263 DATA(insert OID = 575 ( "#=" PGNSP PGUID 0 b t f 704 703 16 0 576 0 0 0 0 tintervalleneq - - ));
264 DATA(insert OID = 576 ( "#<>" PGNSP PGUID 0 b t f 704 703 16 0 575 0 0 0 0 tintervallenne - - ));
265 DATA(insert OID = 577 ( "#<" PGNSP PGUID 0 b t f 704 703 16 0 580 0 0 0 0 tintervallenlt - - ));
266 DATA(insert OID = 578 ( "#>" PGNSP PGUID 0 b t f 704 703 16 0 579 0 0 0 0 tintervallengt - - ));
267 DATA(insert OID = 579 ( "#<=" PGNSP PGUID 0 b t f 704 703 16 0 578 0 0 0 0 tintervallenle - - ));
268 DATA(insert OID = 580 ( "#>=" PGNSP PGUID 0 b t f 704 703 16 0 577 0 0 0 0 tintervallenge - - ));
269 DATA(insert OID = 581 ( "+" PGNSP PGUID 0 b t f 702 703 702 0 0 0 0 0 0 timepl - - ));
270 DATA(insert OID = 582 ( "-" PGNSP PGUID 0 b t f 702 703 702 0 0 0 0 0 0 timemi - - ));
271 DATA(insert OID = 583 ( "<?>" PGNSP PGUID 0 b t f 702 704 16 0 0 0 0 0 0 intinterval - - ));
272 DATA(insert OID = 584 ( "-" PGNSP PGUID 0 l t f 0 700 700 0 0 0 0 0 0 float4um - - ));
273 DATA(insert OID = 585 ( "-" PGNSP PGUID 0 l t f 0 701 701 0 0 0 0 0 0 float8um - - ));
274 DATA(insert OID = 586 ( "+" PGNSP PGUID 0 b t f 700 700 700 586 0 0 0 0 0 float4pl - - ));
275 DATA(insert OID = 587 ( "-" PGNSP PGUID 0 b t f 700 700 700 0 0 0 0 0 0 float4mi - - ));
276 DATA(insert OID = 588 ( "/" PGNSP PGUID 0 b t f 700 700 700 0 0 0 0 0 0 float4div - - ));
277 DATA(insert OID = 589 ( "*" PGNSP PGUID 0 b t f 700 700 700 589 0 0 0 0 0 float4mul - - ));
278 DATA(insert OID = 590 ( "@" PGNSP PGUID 0 l t f 0 700 700 0 0 0 0 0 0 float4abs - - ));
279 DATA(insert OID = 591 ( "+" PGNSP PGUID 0 b t f 701 701 701 591 0 0 0 0 0 float8pl - - ));
280 DATA(insert OID = 592 ( "-" PGNSP PGUID 0 b t f 701 701 701 0 0 0 0 0 0 float8mi - - ));
281 DATA(insert OID = 593 ( "/" PGNSP PGUID 0 b t f 701 701 701 0 0 0 0 0 0 float8div - - ));
282 DATA(insert OID = 594 ( "*" PGNSP PGUID 0 b t f 701 701 701 594 0 0 0 0 0 float8mul - - ));
283 DATA(insert OID = 595 ( "@" PGNSP PGUID 0 l t f 0 701 701 0 0 0 0 0 0 float8abs - - ));
284 DATA(insert OID = 596 ( "|/" PGNSP PGUID 0 l t f 0 701 701 0 0 0 0 0 0 dsqrt - - ));
285 DATA(insert OID = 597 ( "||/" PGNSP PGUID 0 l t f 0 701 701 0 0 0 0 0 0 dcbrt - - ));
286 DATA(insert OID = 598 ( "%" PGNSP PGUID 0 l t f 0 701 701 0 0 0 0 0 0 dtrunc - - ));
287 DATA(insert OID = 599 ( "%" PGNSP PGUID 0 r t f 701 0 701 0 0 0 0 0 0 dround - - ));
288 DATA(insert OID = 1284 ( "|" PGNSP PGUID 0 l t f 0 704 702 0 0 0 0 0 0 tintervalstart - - ));
289 DATA(insert OID = 606 ( "<#>" PGNSP PGUID 0 b t f 702 702 704 0 0 0 0 0 0 mktinterval - - ));
290 DATA(insert OID = 607 ( "=" PGNSP PGUID 0 b t t 26 26 16 607 608 609 609 609 610 oideq eqsel eqjoinsel ));
291 #define MIN_OIDCMP 607 /* used by cache code */
292 DATA(insert OID = 608 ( "<>" PGNSP PGUID 0 b t f 26 26 16 608 607 0 0 0 0 oidne neqsel neqjoinsel ));
293 DATA(insert OID = 609 ( "<" PGNSP PGUID 0 b t f 26 26 16 610 612 0 0 0 0 oidlt scalarltsel scalarltjoinsel ));
294 DATA(insert OID = 610 ( ">" PGNSP PGUID 0 b t f 26 26 16 609 611 0 0 0 0 oidgt scalargtsel scalargtjoinsel ));
295 DATA(insert OID = 611 ( "<=" PGNSP PGUID 0 b t f 26 26 16 612 610 0 0 0 0 oidle scalarltsel scalarltjoinsel ));
296 DATA(insert OID = 612 ( ">=" PGNSP PGUID 0 b t f 26 26 16 611 609 0 0 0 0 oidge scalargtsel scalargtjoinsel ));
297 #define MAX_OIDCMP 612 /* used by cache code */
299 DATA(insert OID = 644 ( "<>" PGNSP PGUID 0 b t f 30 30 16 644 649 0 0 0 0 oidvectorne neqsel neqjoinsel ));
300 DATA(insert OID = 645 ( "<" PGNSP PGUID 0 b t f 30 30 16 646 648 0 0 0 0 oidvectorlt scalarltsel scalarltjoinsel ));
301 DATA(insert OID = 646 ( ">" PGNSP PGUID 0 b t f 30 30 16 645 647 0 0 0 0 oidvectorgt scalargtsel scalargtjoinsel ));
302 DATA(insert OID = 647 ( "<=" PGNSP PGUID 0 b t f 30 30 16 648 646 0 0 0 0 oidvectorle scalarltsel scalarltjoinsel ));
303 DATA(insert OID = 648 ( ">=" PGNSP PGUID 0 b t f 30 30 16 647 645 0 0 0 0 oidvectorge scalargtsel scalargtjoinsel ));
304 DATA(insert OID = 649 ( "=" PGNSP PGUID 0 b t t 30 30 16 649 644 645 645 645 646 oidvectoreq eqsel eqjoinsel ));
306 DATA(insert OID = 613 ( "<->" PGNSP PGUID 0 b t f 600 628 701 0 0 0 0 0 0 dist_pl - - ));
307 DATA(insert OID = 614 ( "<->" PGNSP PGUID 0 b t f 600 601 701 0 0 0 0 0 0 dist_ps - - ));
308 DATA(insert OID = 615 ( "<->" PGNSP PGUID 0 b t f 600 603 701 0 0 0 0 0 0 dist_pb - - ));
309 DATA(insert OID = 616 ( "<->" PGNSP PGUID 0 b t f 601 628 701 0 0 0 0 0 0 dist_sl - - ));
310 DATA(insert OID = 617 ( "<->" PGNSP PGUID 0 b t f 601 603 701 0 0 0 0 0 0 dist_sb - - ));
311 DATA(insert OID = 618 ( "<->" PGNSP PGUID 0 b t f 600 602 701 0 0 0 0 0 0 dist_ppath - - ));
313 DATA(insert OID = 620 ( "=" PGNSP PGUID 0 b t f 700 700 16 620 621 622 622 622 623 float4eq eqsel eqjoinsel ));
314 DATA(insert OID = 621 ( "<>" PGNSP PGUID 0 b t f 700 700 16 621 620 0 0 0 0 float4ne neqsel neqjoinsel ));
315 DATA(insert OID = 622 ( "<" PGNSP PGUID 0 b t f 700 700 16 623 625 0 0 0 0 float4lt scalarltsel scalarltjoinsel ));
316 DATA(insert OID = 623 ( ">" PGNSP PGUID 0 b t f 700 700 16 622 624 0 0 0 0 float4gt scalargtsel scalargtjoinsel ));
317 DATA(insert OID = 624 ( "<=" PGNSP PGUID 0 b t f 700 700 16 625 623 0 0 0 0 float4le scalarltsel scalarltjoinsel ));
318 DATA(insert OID = 625 ( ">=" PGNSP PGUID 0 b t f 700 700 16 624 622 0 0 0 0 float4ge scalargtsel scalargtjoinsel ));
319 DATA(insert OID = 626 ( "!!=" PGNSP PGUID 0 b t f 23 25 16 0 0 0 0 0 0 int4notin - - ));
320 DATA(insert OID = 627 ( "!!=" PGNSP PGUID 0 b t f 26 25 16 0 0 0 0 0 0 oidnotin - - ));
321 DATA(insert OID = 630 ( "<>" PGNSP PGUID 0 b t f 18 18 16 630 92 0 0 0 0 charne neqsel neqjoinsel ));
323 DATA(insert OID = 631 ( "<" PGNSP PGUID 0 b t f 18 18 16 633 634 0 0 0 0 charlt scalarltsel scalarltjoinsel ));
324 DATA(insert OID = 632 ( "<=" PGNSP PGUID 0 b t f 18 18 16 634 633 0 0 0 0 charle scalarltsel scalarltjoinsel ));
325 DATA(insert OID = 633 ( ">" PGNSP PGUID 0 b t f 18 18 16 631 632 0 0 0 0 chargt scalargtsel scalargtjoinsel ));
326 DATA(insert OID = 634 ( ">=" PGNSP PGUID 0 b t f 18 18 16 632 631 0 0 0 0 charge scalargtsel scalargtjoinsel ));
328 DATA(insert OID = 635 ( "+" PGNSP PGUID 0 b t f 18 18 18 0 0 0 0 0 0 charpl - - ));
329 DATA(insert OID = 636 ( "-" PGNSP PGUID 0 b t f 18 18 18 0 0 0 0 0 0 charmi - - ));
330 DATA(insert OID = 637 ( "*" PGNSP PGUID 0 b t f 18 18 18 0 0 0 0 0 0 charmul - - ));
331 DATA(insert OID = 638 ( "/" PGNSP PGUID 0 b t f 18 18 18 0 0 0 0 0 0 chardiv - - ));
333 DATA(insert OID = 639 ( "~" PGNSP PGUID 0 b t f 19 25 16 0 640 0 0 0 0 nameregexeq regexeqsel regexeqjoinsel ));
334 #define OID_NAME_REGEXEQ_OP 639
335 DATA(insert OID = 640 ( "!~" PGNSP PGUID 0 b t f 19 25 16 0 639 0 0 0 0 nameregexne regexnesel regexnejoinsel ));
336 DATA(insert OID = 641 ( "~" PGNSP PGUID 0 b t f 25 25 16 0 642 0 0 0 0 textregexeq regexeqsel regexeqjoinsel ));
337 #define OID_TEXT_REGEXEQ_OP 641
338 DATA(insert OID = 642 ( "!~" PGNSP PGUID 0 b t f 25 25 16 0 641 0 0 0 0 textregexne regexnesel regexnejoinsel ));
339 DATA(insert OID = 643 ( "<>" PGNSP PGUID 0 b t f 19 19 16 643 93 0 0 0 0 namene neqsel neqjoinsel ));
340 DATA(insert OID = 654 ( "||" PGNSP PGUID 0 b t f 25 25 25 0 0 0 0 0 0 textcat - - ));
342 DATA(insert OID = 660 ( "<" PGNSP PGUID 0 b t f 19 19 16 662 663 0 0 0 0 namelt scalarltsel scalarltjoinsel ));
343 DATA(insert OID = 661 ( "<=" PGNSP PGUID 0 b t f 19 19 16 663 662 0 0 0 0 namele scalarltsel scalarltjoinsel ));
344 DATA(insert OID = 662 ( ">" PGNSP PGUID 0 b t f 19 19 16 660 661 0 0 0 0 namegt scalargtsel scalargtjoinsel ));
345 DATA(insert OID = 663 ( ">=" PGNSP PGUID 0 b t f 19 19 16 661 660 0 0 0 0 namege scalargtsel scalargtjoinsel ));
346 DATA(insert OID = 664 ( "<" PGNSP PGUID 0 b t f 25 25 16 666 667 0 0 0 0 text_lt scalarltsel scalarltjoinsel ));
347 DATA(insert OID = 665 ( "<=" PGNSP PGUID 0 b t f 25 25 16 667 666 0 0 0 0 text_le scalarltsel scalarltjoinsel ));
348 DATA(insert OID = 666 ( ">" PGNSP PGUID 0 b t f 25 25 16 664 665 0 0 0 0 text_gt scalargtsel scalargtjoinsel ));
349 DATA(insert OID = 667 ( ">=" PGNSP PGUID 0 b t f 25 25 16 665 664 0 0 0 0 text_ge scalargtsel scalargtjoinsel ));
351 DATA(insert OID = 670 ( "=" PGNSP PGUID 0 b t f 701 701 16 670 671 672 672 672 674 float8eq eqsel eqjoinsel ));
352 DATA(insert OID = 671 ( "<>" PGNSP PGUID 0 b t f 701 701 16 671 670 0 0 0 0 float8ne neqsel neqjoinsel ));
353 DATA(insert OID = 672 ( "<" PGNSP PGUID 0 b t f 701 701 16 674 675 0 0 0 0 float8lt scalarltsel scalarltjoinsel ));
354 DATA(insert OID = 673 ( "<=" PGNSP PGUID 0 b t f 701 701 16 675 674 0 0 0 0 float8le scalarltsel scalarltjoinsel ));
355 DATA(insert OID = 674 ( ">" PGNSP PGUID 0 b t f 701 701 16 672 673 0 0 0 0 float8gt scalargtsel scalargtjoinsel ));
356 DATA(insert OID = 675 ( ">=" PGNSP PGUID 0 b t f 701 701 16 673 672 0 0 0 0 float8ge scalargtsel scalargtjoinsel ));
358 DATA(insert OID = 682 ( "@" PGNSP PGUID 0 l t f 0 21 21 0 0 0 0 0 0 int2abs - - ));
359 DATA(insert OID = 684 ( "+" PGNSP PGUID 0 b t f 20 20 20 684 0 0 0 0 0 int8pl - - ));
360 DATA(insert OID = 685 ( "-" PGNSP PGUID 0 b t f 20 20 20 0 0 0 0 0 0 int8mi - - ));
361 DATA(insert OID = 686 ( "*" PGNSP PGUID 0 b t f 20 20 20 686 0 0 0 0 0 int8mul - - ));
362 DATA(insert OID = 687 ( "/" PGNSP PGUID 0 b t f 20 20 20 0 0 0 0 0 0 int8div - - ));
363 DATA(insert OID = 688 ( "+" PGNSP PGUID 0 b t f 20 23 20 692 0 0 0 0 0 int84pl - - ));
364 DATA(insert OID = 689 ( "-" PGNSP PGUID 0 b t f 20 23 20 0 0 0 0 0 0 int84mi - - ));
365 DATA(insert OID = 690 ( "*" PGNSP PGUID 0 b t f 20 23 20 694 0 0 0 0 0 int84mul - - ));
366 DATA(insert OID = 691 ( "/" PGNSP PGUID 0 b t f 20 23 20 0 0 0 0 0 0 int84div - - ));
367 DATA(insert OID = 692 ( "+" PGNSP PGUID 0 b t f 23 20 20 688 0 0 0 0 0 int48pl - - ));
368 DATA(insert OID = 693 ( "-" PGNSP PGUID 0 b t f 23 20 20 0 0 0 0 0 0 int48mi - - ));
369 DATA(insert OID = 694 ( "*" PGNSP PGUID 0 b t f 23 20 20 690 0 0 0 0 0 int48mul - - ));
370 DATA(insert OID = 695 ( "/" PGNSP PGUID 0 b t f 23 20 20 0 0 0 0 0 0 int48div - - ));
372 DATA(insert OID = 706 ( "<->" PGNSP PGUID 0 b t f 603 603 701 706 0 0 0 0 0 box_distance - - ));
373 DATA(insert OID = 707 ( "<->" PGNSP PGUID 0 b t f 602 602 701 707 0 0 0 0 0 path_distance - - ));
374 DATA(insert OID = 708 ( "<->" PGNSP PGUID 0 b t f 628 628 701 708 0 0 0 0 0 line_distance - - ));
375 DATA(insert OID = 709 ( "<->" PGNSP PGUID 0 b t f 601 601 701 709 0 0 0 0 0 lseg_distance - - ));
376 DATA(insert OID = 712 ( "<->" PGNSP PGUID 0 b t f 604 604 701 712 0 0 0 0 0 poly_distance - - ));
378 /* add translation/rotation/scaling operators for geometric types. - thomas 97/05/10 */
379 DATA(insert OID = 731 ( "+" PGNSP PGUID 0 b t f 600 600 600 731 0 0 0 0 0 point_add - - ));
380 DATA(insert OID = 732 ( "-" PGNSP PGUID 0 b t f 600 600 600 0 0 0 0 0 0 point_sub - - ));
381 DATA(insert OID = 733 ( "*" PGNSP PGUID 0 b t f 600 600 600 733 0 0 0 0 0 point_mul - - ));
382 DATA(insert OID = 734 ( "/" PGNSP PGUID 0 b t f 600 600 600 0 0 0 0 0 0 point_div - - ));
383 DATA(insert OID = 735 ( "+" PGNSP PGUID 0 b t f 602 602 602 735 0 0 0 0 0 path_add - - ));
384 DATA(insert OID = 736 ( "+" PGNSP PGUID 0 b t f 602 600 602 0 0 0 0 0 0 path_add_pt - - ));
385 DATA(insert OID = 737 ( "-" PGNSP PGUID 0 b t f 602 600 602 0 0 0 0 0 0 path_sub_pt - - ));
386 DATA(insert OID = 738 ( "*" PGNSP PGUID 0 b t f 602 600 602 0 0 0 0 0 0 path_mul_pt - - ));
387 DATA(insert OID = 739 ( "/" PGNSP PGUID 0 b t f 602 600 602 0 0 0 0 0 0 path_div_pt - - ));
388 DATA(insert OID = 755 ( "~" PGNSP PGUID 0 b t f 602 600 16 512 0 0 0 0 0 path_contain_pt - - ));
389 DATA(insert OID = 756 ( "@" PGNSP PGUID 0 b t f 600 604 16 757 0 0 0 0 0 pt_contained_poly - - ));
390 DATA(insert OID = 757 ( "~" PGNSP PGUID 0 b t f 604 600 16 756 0 0 0 0 0 poly_contain_pt - - ));
391 DATA(insert OID = 758 ( "@" PGNSP PGUID 0 b t f 600 718 16 759 0 0 0 0 0 pt_contained_circle - - ));
392 DATA(insert OID = 759 ( "~" PGNSP PGUID 0 b t f 718 600 16 758 0 0 0 0 0 circle_contain_pt - - ));
394 DATA(insert OID = 773 ( "@" PGNSP PGUID 0 l t f 0 23 23 0 0 0 0 0 0 int4abs - - ));
396 /* additional operators for geometric types - thomas 1997-07-09 */
397 DATA(insert OID = 792 ( "=" PGNSP PGUID 0 b t f 602 602 16 792 0 0 0 0 0 path_n_eq eqsel eqjoinsel ));
398 DATA(insert OID = 793 ( "<" PGNSP PGUID 0 b t f 602 602 16 794 0 0 0 0 0 path_n_lt - - ));
399 DATA(insert OID = 794 ( ">" PGNSP PGUID 0 b t f 602 602 16 793 0 0 0 0 0 path_n_gt - - ));
400 DATA(insert OID = 795 ( "<=" PGNSP PGUID 0 b t f 602 602 16 796 0 0 0 0 0 path_n_le - - ));
401 DATA(insert OID = 796 ( ">=" PGNSP PGUID 0 b t f 602 602 16 795 0 0 0 0 0 path_n_ge - - ));
402 DATA(insert OID = 797 ( "#" PGNSP PGUID 0 l t f 0 602 23 0 0 0 0 0 0 path_npoints - - ));
403 DATA(insert OID = 798 ( "?#" PGNSP PGUID 0 b t f 602 602 16 0 0 0 0 0 0 path_inter - - ));
404 DATA(insert OID = 799 ( "@-@" PGNSP PGUID 0 l t f 0 602 701 0 0 0 0 0 0 path_length - - ));
405 DATA(insert OID = 800 ( ">^" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_above positionsel positionjoinsel ));
406 DATA(insert OID = 801 ( "<^" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_below positionsel positionjoinsel ));
407 DATA(insert OID = 802 ( "?#" PGNSP PGUID 0 b t f 603 603 16 0 0 0 0 0 0 box_overlap areasel areajoinsel ));
408 DATA(insert OID = 803 ( "#" PGNSP PGUID 0 b t f 603 603 603 0 0 0 0 0 0 box_intersect - - ));
409 DATA(insert OID = 804 ( "+" PGNSP PGUID 0 b t f 603 600 603 0 0 0 0 0 0 box_add - - ));
410 DATA(insert OID = 805 ( "-" PGNSP PGUID 0 b t f 603 600 603 0 0 0 0 0 0 box_sub - - ));
411 DATA(insert OID = 806 ( "*" PGNSP PGUID 0 b t f 603 600 603 0 0 0 0 0 0 box_mul - - ));
412 DATA(insert OID = 807 ( "/" PGNSP PGUID 0 b t f 603 600 603 0 0 0 0 0 0 box_div - - ));
413 DATA(insert OID = 808 ( "?-" PGNSP PGUID 0 b t f 600 600 16 808 0 0 0 0 0 point_horiz - - ));
414 DATA(insert OID = 809 ( "?|" PGNSP PGUID 0 b t f 600 600 16 809 0 0 0 0 0 point_vert - - ));
416 DATA(insert OID = 811 ( "=" PGNSP PGUID 0 b t f 704 704 16 811 812 0 0 0 0 tintervaleq eqsel eqjoinsel ));
417 DATA(insert OID = 812 ( "<>" PGNSP PGUID 0 b t f 704 704 16 812 811 0 0 0 0 tintervalne neqsel neqjoinsel ));
418 DATA(insert OID = 813 ( "<" PGNSP PGUID 0 b t f 704 704 16 814 816 0 0 0 0 tintervallt scalarltsel scalarltjoinsel ));
419 DATA(insert OID = 814 ( ">" PGNSP PGUID 0 b t f 704 704 16 813 815 0 0 0 0 tintervalgt scalargtsel scalargtjoinsel ));
420 DATA(insert OID = 815 ( "<=" PGNSP PGUID 0 b t f 704 704 16 816 814 0 0 0 0 tintervalle scalarltsel scalarltjoinsel ));
421 DATA(insert OID = 816 ( ">=" PGNSP PGUID 0 b t f 704 704 16 815 813 0 0 0 0 tintervalge scalargtsel scalargtjoinsel ));
423 DATA(insert OID = 843 ( "*" PGNSP PGUID 0 b t f 790 700 790 845 0 0 0 0 0 cash_mul_flt4 - - ));
424 DATA(insert OID = 844 ( "/" PGNSP PGUID 0 b t f 790 700 790 0 0 0 0 0 0 cash_div_flt4 - - ));
425 DATA(insert OID = 845 ( "*" PGNSP PGUID 0 b t f 700 790 790 843 0 0 0 0 0 flt4_mul_cash - - ));
427 DATA(insert OID = 900 ( "=" PGNSP PGUID 0 b t t 790 790 16 900 901 902 902 902 903 cash_eq eqsel eqjoinsel ));
428 DATA(insert OID = 901 ( "<>" PGNSP PGUID 0 b t f 790 790 16 901 900 0 0 0 0 cash_ne neqsel neqjoinsel ));
429 DATA(insert OID = 902 ( "<" PGNSP PGUID 0 b t f 790 790 16 903 905 0 0 0 0 cash_lt scalarltsel scalarltjoinsel ));
430 DATA(insert OID = 903 ( ">" PGNSP PGUID 0 b t f 790 790 16 902 904 0 0 0 0 cash_gt scalargtsel scalargtjoinsel ));
431 DATA(insert OID = 904 ( "<=" PGNSP PGUID 0 b t f 790 790 16 905 903 0 0 0 0 cash_le scalarltsel scalarltjoinsel ));
432 DATA(insert OID = 905 ( ">=" PGNSP PGUID 0 b t f 790 790 16 904 902 0 0 0 0 cash_ge scalargtsel scalargtjoinsel ));
433 DATA(insert OID = 906 ( "+" PGNSP PGUID 0 b t f 790 790 790 906 0 0 0 0 0 cash_pl - - ));
434 DATA(insert OID = 907 ( "-" PGNSP PGUID 0 b t f 790 790 790 0 0 0 0 0 0 cash_mi - - ));
435 DATA(insert OID = 908 ( "*" PGNSP PGUID 0 b t f 790 701 790 916 0 0 0 0 0 cash_mul_flt8 - - ));
436 DATA(insert OID = 909 ( "/" PGNSP PGUID 0 b t f 790 701 790 0 0 0 0 0 0 cash_div_flt8 - - ));
437 DATA(insert OID = 912 ( "*" PGNSP PGUID 0 b t f 790 23 790 917 0 0 0 0 0 cash_mul_int4 - - ));
438 DATA(insert OID = 913 ( "/" PGNSP PGUID 0 b t f 790 23 790 0 0 0 0 0 0 cash_div_int4 - - ));
439 DATA(insert OID = 914 ( "*" PGNSP PGUID 0 b t f 790 21 790 918 0 0 0 0 0 cash_mul_int2 - - ));
440 DATA(insert OID = 915 ( "/" PGNSP PGUID 0 b t f 790 21 790 0 0 0 0 0 0 cash_div_int2 - - ));
441 DATA(insert OID = 916 ( "*" PGNSP PGUID 0 b t f 701 790 790 908 0 0 0 0 0 flt8_mul_cash - - ));
442 DATA(insert OID = 917 ( "*" PGNSP PGUID 0 b t f 23 790 790 912 0 0 0 0 0 int4_mul_cash - - ));
443 DATA(insert OID = 918 ( "*" PGNSP PGUID 0 b t f 21 790 790 914 0 0 0 0 0 int2_mul_cash - - ));
445 DATA(insert OID = 965 ( "^" PGNSP PGUID 0 b t f 701 701 701 0 0 0 0 0 0 dpow - - ));
446 DATA(insert OID = 966 ( "+" PGNSP PGUID 0 b t f 1034 1033 1034 0 0 0 0 0 0 aclinsert - - ));
447 DATA(insert OID = 967 ( "-" PGNSP PGUID 0 b t f 1034 1033 1034 0 0 0 0 0 0 aclremove - - ));
448 DATA(insert OID = 968 ( "~" PGNSP PGUID 0 b t f 1034 1033 16 0 0 0 0 0 0 aclcontains - - ));
450 /* additional geometric operators - thomas 1997-07-09 */
451 DATA(insert OID = 969 ( "@@" PGNSP PGUID 0 l t f 0 601 600 0 0 0 0 0 0 lseg_center - - ));
452 DATA(insert OID = 970 ( "@@" PGNSP PGUID 0 l t f 0 602 600 0 0 0 0 0 0 path_center - - ));
453 DATA(insert OID = 971 ( "@@" PGNSP PGUID 0 l t f 0 604 600 0 0 0 0 0 0 poly_center - - ));
455 DATA(insert OID = 974 ( "||" PGNSP PGUID 0 b t f 1042 1042 1042 0 0 0 0 0 0 textcat - - ));
456 DATA(insert OID = 979 ( "||" PGNSP PGUID 0 b t f 1043 1043 1043 0 0 0 0 0 0 textcat - - ));
458 DATA(insert OID = 1054 ( "=" PGNSP PGUID 0 b t f 1042 1042 16 1054 1057 1058 1058 1058 1060 bpchareq eqsel eqjoinsel ));
459 DATA(insert OID = 1055 ( "~" PGNSP PGUID 0 b t f 1042 25 16 0 1056 0 0 0 0 textregexeq regexeqsel regexeqjoinsel ));
460 #define OID_BPCHAR_REGEXEQ_OP 1055
461 DATA(insert OID = 1056 ( "!~" PGNSP PGUID 0 b t f 1042 25 16 0 1055 0 0 0 0 textregexne regexnesel regexnejoinsel ));
462 DATA(insert OID = 1057 ( "<>" PGNSP PGUID 0 b t f 1042 1042 16 1057 1054 0 0 0 0 bpcharne neqsel neqjoinsel ));
463 DATA(insert OID = 1058 ( "<" PGNSP PGUID 0 b t f 1042 1042 16 1060 1061 0 0 0 0 bpcharlt scalarltsel scalarltjoinsel ));
464 DATA(insert OID = 1059 ( "<=" PGNSP PGUID 0 b t f 1042 1042 16 1061 1060 0 0 0 0 bpcharle scalarltsel scalarltjoinsel ));
465 DATA(insert OID = 1060 ( ">" PGNSP PGUID 0 b t f 1042 1042 16 1058 1059 0 0 0 0 bpchargt scalargtsel scalargtjoinsel ));
466 DATA(insert OID = 1061 ( ">=" PGNSP PGUID 0 b t f 1042 1042 16 1059 1058 0 0 0 0 bpcharge scalargtsel scalargtjoinsel ));
468 DATA(insert OID = 1062 ( "=" PGNSP PGUID 0 b t t 1043 1043 16 1062 1065 1066 1066 1066 1068 varchareq eqsel eqjoinsel ));
469 DATA(insert OID = 1063 ( "~" PGNSP PGUID 0 b t f 1043 25 16 0 1064 0 0 0 0 textregexeq regexeqsel regexeqjoinsel ));
470 #define OID_VARCHAR_REGEXEQ_OP 1063
471 DATA(insert OID = 1064 ( "!~" PGNSP PGUID 0 b t f 1043 25 16 0 1063 0 0 0 0 textregexne regexnesel regexnejoinsel ));
472 DATA(insert OID = 1065 ( "<>" PGNSP PGUID 0 b t f 1043 1043 16 1065 1062 0 0 0 0 varcharne neqsel neqjoinsel ));
473 DATA(insert OID = 1066 ( "<" PGNSP PGUID 0 b t f 1043 1043 16 1068 1069 0 0 0 0 varcharlt scalarltsel scalarltjoinsel ));
474 DATA(insert OID = 1067 ( "<=" PGNSP PGUID 0 b t f 1043 1043 16 1069 1068 0 0 0 0 varcharle scalarltsel scalarltjoinsel ));
475 DATA(insert OID = 1068 ( ">" PGNSP PGUID 0 b t f 1043 1043 16 1066 1067 0 0 0 0 varchargt scalargtsel scalargtjoinsel ));
476 DATA(insert OID = 1069 ( ">=" PGNSP PGUID 0 b t f 1043 1043 16 1067 1066 0 0 0 0 varcharge scalargtsel scalargtjoinsel ));
479 DATA(insert OID = 1093 ( "=" PGNSP PGUID 0 b t t 1082 1082 16 1093 1094 1095 1095 1095 1097 date_eq eqsel eqjoinsel ));
480 DATA(insert OID = 1094 ( "<>" PGNSP PGUID 0 b t f 1082 1082 16 1094 1093 0 0 0 0 date_ne neqsel neqjoinsel ));
481 DATA(insert OID = 1095 ( "<" PGNSP PGUID 0 b t f 1082 1082 16 1097 1098 0 0 0 0 date_lt scalarltsel scalarltjoinsel ));
482 DATA(insert OID = 1096 ( "<=" PGNSP PGUID 0 b t f 1082 1082 16 1098 1097 0 0 0 0 date_le scalarltsel scalarltjoinsel ));
483 DATA(insert OID = 1097 ( ">" PGNSP PGUID 0 b t f 1082 1082 16 1095 1096 0 0 0 0 date_gt scalargtsel scalargtjoinsel ));
484 DATA(insert OID = 1098 ( ">=" PGNSP PGUID 0 b t f 1082 1082 16 1096 1095 0 0 0 0 date_ge scalargtsel scalargtjoinsel ));
485 DATA(insert OID = 1099 ( "-" PGNSP PGUID 0 b t f 1082 1082 23 0 0 0 0 0 0 date_mi - - ));
486 DATA(insert OID = 1100 ( "+" PGNSP PGUID 0 b t f 1082 23 1082 0 0 0 0 0 0 date_pli - - ));
487 DATA(insert OID = 1101 ( "-" PGNSP PGUID 0 b t f 1082 23 1082 0 0 0 0 0 0 date_mii - - ));
490 DATA(insert OID = 1108 ( "=" PGNSP PGUID 0 b t f 1083 1083 16 1108 1109 1110 1110 1110 1112 time_eq eqsel eqjoinsel ));
491 DATA(insert OID = 1109 ( "<>" PGNSP PGUID 0 b t f 1083 1083 16 1109 1108 0 0 0 0 time_ne neqsel neqjoinsel ));
492 DATA(insert OID = 1110 ( "<" PGNSP PGUID 0 b t f 1083 1083 16 1112 1113 0 0 0 0 time_lt scalarltsel scalarltjoinsel ));
493 DATA(insert OID = 1111 ( "<=" PGNSP PGUID 0 b t f 1083 1083 16 1113 1112 0 0 0 0 time_le scalarltsel scalarltjoinsel ));
494 DATA(insert OID = 1112 ( ">" PGNSP PGUID 0 b t f 1083 1083 16 1110 1111 0 0 0 0 time_gt scalargtsel scalargtjoinsel ));
495 DATA(insert OID = 1113 ( ">=" PGNSP PGUID 0 b t f 1083 1083 16 1111 1110 0 0 0 0 time_ge scalargtsel scalargtjoinsel ));
496 DATA(insert OID = 1269 ( "-" PGNSP PGUID 0 b t f 1186 1083 1083 0 0 0 0 0 0 interval_mi_time - - ));
498 /* timetz operators */
499 DATA(insert OID = 1295 ( "-" PGNSP PGUID 0 b t f 1186 1266 1266 0 0 0 0 0 0 interval_mi_timetz - - ));
500 DATA(insert OID = 1550 ( "=" PGNSP PGUID 0 b t f 1266 1266 16 1550 1551 1552 1552 1552 1554 timetz_eq eqsel eqjoinsel ));
501 DATA(insert OID = 1551 ( "<>" PGNSP PGUID 0 b t f 1266 1266 16 1551 1550 0 0 0 0 timetz_ne neqsel neqjoinsel ));
502 DATA(insert OID = 1552 ( "<" PGNSP PGUID 0 b t f 1266 1266 16 1554 1555 0 0 0 0 timetz_lt scalarltsel scalarltjoinsel ));
503 DATA(insert OID = 1553 ( "<=" PGNSP PGUID 0 b t f 1266 1266 16 1555 1554 0 0 0 0 timetz_le scalarltsel scalarltjoinsel ));
504 DATA(insert OID = 1554 ( ">" PGNSP PGUID 0 b t f 1266 1266 16 1552 1553 0 0 0 0 timetz_gt scalargtsel scalargtjoinsel ));
505 DATA(insert OID = 1555 ( ">=" PGNSP PGUID 0 b t f 1266 1266 16 1553 1552 0 0 0 0 timetz_ge scalargtsel scalargtjoinsel ));
507 /* float48 operators */
508 DATA(insert OID = 1116 ( "+" PGNSP PGUID 0 b t f 700 701 701 1126 0 0 0 0 0 float48pl - - ));
509 DATA(insert OID = 1117 ( "-" PGNSP PGUID 0 b t f 700 701 701 0 0 0 0 0 0 float48mi - - ));
510 DATA(insert OID = 1118 ( "/" PGNSP PGUID 0 b t f 700 701 701 0 0 0 0 0 0 float48div - - ));
511 DATA(insert OID = 1119 ( "*" PGNSP PGUID 0 b t f 700 701 701 1129 0 0 0 0 0 float48mul - - ));
512 DATA(insert OID = 1120 ( "=" PGNSP PGUID 0 b t f 700 701 16 1130 1121 622 672 1122 1123 float48eq eqsel eqjoinsel ));
513 DATA(insert OID = 1121 ( "<>" PGNSP PGUID 0 b t f 700 701 16 1131 1120 0 0 0 0 float48ne neqsel neqjoinsel ));
514 DATA(insert OID = 1122 ( "<" PGNSP PGUID 0 b t f 700 701 16 1133 1125 0 0 0 0 float48lt scalarltsel scalarltjoinsel ));
515 DATA(insert OID = 1123 ( ">" PGNSP PGUID 0 b t f 700 701 16 1132 1124 0 0 0 0 float48gt scalargtsel scalargtjoinsel ));
516 DATA(insert OID = 1124 ( "<=" PGNSP PGUID 0 b t f 700 701 16 1135 1123 0 0 0 0 float48le scalarltsel scalarltjoinsel ));
517 DATA(insert OID = 1125 ( ">=" PGNSP PGUID 0 b t f 700 701 16 1134 1122 0 0 0 0 float48ge scalargtsel scalargtjoinsel ));
519 /* float84 operators */
520 DATA(insert OID = 1126 ( "+" PGNSP PGUID 0 b t f 701 700 701 1116 0 0 0 0 0 float84pl - - ));
521 DATA(insert OID = 1127 ( "-" PGNSP PGUID 0 b t f 701 700 701 0 0 0 0 0 0 float84mi - - ));
522 DATA(insert OID = 1128 ( "/" PGNSP PGUID 0 b t f 701 700 701 0 0 0 0 0 0 float84div - - ));
523 DATA(insert OID = 1129 ( "*" PGNSP PGUID 0 b t f 701 700 701 1119 0 0 0 0 0 float84mul - - ));
524 DATA(insert OID = 1130 ( "=" PGNSP PGUID 0 b t f 701 700 16 1120 1131 672 622 1132 1133 float84eq eqsel eqjoinsel ));
525 DATA(insert OID = 1131 ( "<>" PGNSP PGUID 0 b t f 701 700 16 1121 1130 0 0 0 0 float84ne neqsel neqjoinsel ));
526 DATA(insert OID = 1132 ( "<" PGNSP PGUID 0 b t f 701 700 16 1123 1135 0 0 0 0 float84lt scalarltsel scalarltjoinsel ));
527 DATA(insert OID = 1133 ( ">" PGNSP PGUID 0 b t f 701 700 16 1122 1134 0 0 0 0 float84gt scalargtsel scalargtjoinsel ));
528 DATA(insert OID = 1134 ( "<=" PGNSP PGUID 0 b t f 701 700 16 1125 1133 0 0 0 0 float84le scalarltsel scalarltjoinsel ));
529 DATA(insert OID = 1135 ( ">=" PGNSP PGUID 0 b t f 701 700 16 1124 1132 0 0 0 0 float84ge scalargtsel scalargtjoinsel ));
531 /* int4 vs oid equality --- use oid (unsigned) comparison */
532 DATA(insert OID = 1136 ( "=" PGNSP PGUID 0 b t t 23 26 16 1137 1656 0 0 0 0 oideq eqsel eqjoinsel ));
533 DATA(insert OID = 1137 ( "=" PGNSP PGUID 0 b t t 26 23 16 1136 1661 0 0 0 0 oideq eqsel eqjoinsel ));
535 DATA(insert OID = 1158 ( "!" PGNSP PGUID 0 r t f 21 0 23 0 0 0 0 0 0 int2fac - - ));
536 DATA(insert OID = 1175 ( "!!" PGNSP PGUID 0 l t f 0 21 23 0 0 0 0 0 0 int2fac - - ));
538 /* LIKE hacks by Keith Parks. */
539 DATA(insert OID = 1207 ( "~~" PGNSP PGUID 0 b t f 19 25 16 0 1208 0 0 0 0 namelike likesel likejoinsel ));
540 #define OID_NAME_LIKE_OP 1207
541 DATA(insert OID = 1208 ( "!~~" PGNSP PGUID 0 b t f 19 25 16 0 1207 0 0 0 0 namenlike nlikesel nlikejoinsel ));
542 DATA(insert OID = 1209 ( "~~" PGNSP PGUID 0 b t f 25 25 16 0 1210 0 0 0 0 textlike likesel likejoinsel ));
543 #define OID_TEXT_LIKE_OP 1209
544 DATA(insert OID = 1210 ( "!~~" PGNSP PGUID 0 b t f 25 25 16 0 1209 0 0 0 0 textnlike nlikesel nlikejoinsel ));
545 DATA(insert OID = 1211 ( "~~" PGNSP PGUID 0 b t f 1042 25 16 0 1212 0 0 0 0 textlike likesel likejoinsel ));
546 #define OID_BPCHAR_LIKE_OP 1211
547 DATA(insert OID = 1212 ( "!~~" PGNSP PGUID 0 b t f 1042 25 16 0 1211 0 0 0 0 textnlike nlikesel nlikejoinsel ));
548 DATA(insert OID = 1213 ( "~~" PGNSP PGUID 0 b t f 1043 25 16 0 1214 0 0 0 0 textlike likesel likejoinsel ));
549 #define OID_VARCHAR_LIKE_OP 1213
550 DATA(insert OID = 1214 ( "!~~" PGNSP PGUID 0 b t f 1043 25 16 0 1213 0 0 0 0 textnlike nlikesel nlikejoinsel ));
552 /* case-insensitive regex hacks */
553 DATA(insert OID = 1226 ( "~*" PGNSP PGUID 0 b t f 19 25 16 0 1227 0 0 0 0 nameicregexeq icregexeqsel icregexeqjoinsel ));
554 #define OID_NAME_ICREGEXEQ_OP 1226
555 DATA(insert OID = 1227 ( "!~*" PGNSP PGUID 0 b t f 19 25 16 0 1226 0 0 0 0 nameicregexne icregexnesel icregexnejoinsel ));
556 DATA(insert OID = 1228 ( "~*" PGNSP PGUID 0 b t f 25 25 16 0 1229 0 0 0 0 texticregexeq icregexeqsel icregexeqjoinsel ));
557 #define OID_TEXT_ICREGEXEQ_OP 1228
558 DATA(insert OID = 1229 ( "!~*" PGNSP PGUID 0 b t f 25 25 16 0 1228 0 0 0 0 texticregexne icregexnesel icregexnejoinsel ));
559 DATA(insert OID = 1232 ( "~*" PGNSP PGUID 0 b t f 1043 25 16 0 1233 0 0 0 0 texticregexeq icregexeqsel icregexeqjoinsel ));
560 #define OID_VARCHAR_ICREGEXEQ_OP 1232
561 DATA(insert OID = 1233 ( "!~*" PGNSP PGUID 0 b t f 1043 25 16 0 1232 0 0 0 0 texticregexne icregexnesel icregexnejoinsel ));
562 DATA(insert OID = 1234 ( "~*" PGNSP PGUID 0 b t f 1042 25 16 0 1235 0 0 0 0 texticregexeq icregexeqsel icregexeqjoinsel ));
563 #define OID_BPCHAR_ICREGEXEQ_OP 1234
564 DATA(insert OID = 1235 ( "!~*" PGNSP PGUID 0 b t f 1042 25 16 0 1234 0 0 0 0 texticregexne icregexnesel icregexnejoinsel ));
566 /* timestamptz operators */
567 DATA(insert OID = 1320 ( "=" PGNSP PGUID 0 b t f 1184 1184 16 1320 1321 1322 1322 1322 1324 timestamp_eq eqsel eqjoinsel ));
568 DATA(insert OID = 1321 ( "<>" PGNSP PGUID 0 b t f 1184 1184 16 1321 1320 0 0 0 0 timestamp_ne neqsel neqjoinsel ));
569 DATA(insert OID = 1322 ( "<" PGNSP PGUID 0 b t f 1184 1184 16 1324 1325 0 0 0 0 timestamp_lt scalarltsel scalarltjoinsel ));
570 DATA(insert OID = 1323 ( "<=" PGNSP PGUID 0 b t f 1184 1184 16 1325 1324 0 0 0 0 timestamp_le scalarltsel scalarltjoinsel ));
571 DATA(insert OID = 1324 ( ">" PGNSP PGUID 0 b t f 1184 1184 16 1322 1323 0 0 0 0 timestamp_gt scalargtsel scalargtjoinsel ));
572 DATA(insert OID = 1325 ( ">=" PGNSP PGUID 0 b t f 1184 1184 16 1323 1322 0 0 0 0 timestamp_ge scalargtsel scalargtjoinsel ));
573 DATA(insert OID = 1327 ( "+" PGNSP PGUID 0 b t f 1184 1186 1184 0 0 0 0 0 0 timestamptz_pl_span - - ));
574 DATA(insert OID = 1328 ( "-" PGNSP PGUID 0 b t f 1184 1184 1186 0 0 0 0 0 0 timestamptz_mi - - ));
575 DATA(insert OID = 1329 ( "-" PGNSP PGUID 0 b t f 1184 1186 1184 0 0 0 0 0 0 timestamptz_mi_span - - ));
577 /* interval operators */
578 DATA(insert OID = 1330 ( "=" PGNSP PGUID 0 b t f 1186 1186 16 1330 1331 1332 1332 1332 1334 interval_eq eqsel eqjoinsel ));
579 DATA(insert OID = 1331 ( "<>" PGNSP PGUID 0 b t f 1186 1186 16 1331 1330 0 0 0 0 interval_ne neqsel neqjoinsel ));
580 DATA(insert OID = 1332 ( "<" PGNSP PGUID 0 b t f 1186 1186 16 1334 1335 0 0 0 0 interval_lt scalarltsel scalarltjoinsel ));
581 DATA(insert OID = 1333 ( "<=" PGNSP PGUID 0 b t f 1186 1186 16 1335 1334 0 0 0 0 interval_le scalarltsel scalarltjoinsel ));
582 DATA(insert OID = 1334 ( ">" PGNSP PGUID 0 b t f 1186 1186 16 1332 1333 0 0 0 0 interval_gt scalargtsel scalargtjoinsel ));
583 DATA(insert OID = 1335 ( ">=" PGNSP PGUID 0 b t f 1186 1186 16 1333 1332 0 0 0 0 interval_ge scalargtsel scalargtjoinsel ));
585 DATA(insert OID = 1336 ( "-" PGNSP PGUID 0 l t f 0 1186 1186 0 0 0 0 0 0 interval_um - - ));
586 DATA(insert OID = 1337 ( "+" PGNSP PGUID 0 b t f 1186 1186 1186 1337 0 0 0 0 0 interval_pl - - ));
587 DATA(insert OID = 1338 ( "-" PGNSP PGUID 0 b t f 1186 1186 1186 0 0 0 0 0 0 interval_mi - - ));
589 DATA(insert OID = 1360 ( "+" PGNSP PGUID 0 b t f 1082 1083 1114 0 0 0 0 0 0 datetime_pl - - ));
590 DATA(insert OID = 1361 ( "+" PGNSP PGUID 0 b t f 1082 1266 1184 0 0 0 0 0 0 datetimetz_pl - - ));
591 DATA(insert OID = 1363 ( "+" PGNSP PGUID 0 b t f 1083 1082 1114 0 0 0 0 0 0 timedate_pl - - ));
592 DATA(insert OID = 1366 ( "+" PGNSP PGUID 0 b t f 1266 1082 1184 0 0 0 0 0 0 timetzdate_pl - - ));
594 DATA(insert OID = 1399 ( "-" PGNSP PGUID 0 b t f 1083 1083 1186 0 0 0 0 0 0 time_mi_time - - ));
596 /* additional geometric operators - thomas 97/04/18 */
597 DATA(insert OID = 1420 ( "@@" PGNSP PGUID 0 l t f 0 718 600 0 0 0 0 0 0 circle_center - - ));
598 DATA(insert OID = 1500 ( "=" PGNSP PGUID 0 b t f 718 718 16 1500 1501 1502 1502 1502 1503 circle_eq eqsel eqjoinsel ));
599 DATA(insert OID = 1501 ( "<>" PGNSP PGUID 0 b t f 718 718 16 1501 1500 0 0 0 0 circle_ne neqsel neqjoinsel ));
600 DATA(insert OID = 1502 ( "<" PGNSP PGUID 0 b t f 718 718 16 1503 1505 0 0 0 0 circle_lt areasel areajoinsel ));
601 DATA(insert OID = 1503 ( ">" PGNSP PGUID 0 b t f 718 718 16 1502 1504 0 0 0 0 circle_gt areasel areajoinsel ));
602 DATA(insert OID = 1504 ( "<=" PGNSP PGUID 0 b t f 718 718 16 1505 1503 0 0 0 0 circle_le areasel areajoinsel ));
603 DATA(insert OID = 1505 ( ">=" PGNSP PGUID 0 b t f 718 718 16 1504 1502 0 0 0 0 circle_ge areasel areajoinsel ));
605 DATA(insert OID = 1506 ( "<<" PGNSP PGUID 0 b t f 718 718 16 0 0 0 0 0 0 circle_left positionsel positionjoinsel ));
606 DATA(insert OID = 1507 ( "&<" PGNSP PGUID 0 b t f 718 718 16 0 0 0 0 0 0 circle_overleft positionsel positionjoinsel ));
607 DATA(insert OID = 1508 ( "&>" PGNSP PGUID 0 b t f 718 718 16 0 0 0 0 0 0 circle_overright positionsel positionjoinsel ));
608 DATA(insert OID = 1509 ( ">>" PGNSP PGUID 0 b t f 718 718 16 0 0 0 0 0 0 circle_right positionsel positionjoinsel ));
609 DATA(insert OID = 1510 ( "@" PGNSP PGUID 0 b t f 718 718 16 1511 0 0 0 0 0 circle_contained contsel contjoinsel ));
610 DATA(insert OID = 1511 ( "~" PGNSP PGUID 0 b t f 718 718 16 1510 0 0 0 0 0 circle_contain contsel contjoinsel ));
611 DATA(insert OID = 1512 ( "~=" PGNSP PGUID 0 b t f 718 718 16 1512 0 0 0 0 0 circle_same eqsel eqjoinsel ));
612 DATA(insert OID = 1513 ( "&&" PGNSP PGUID 0 b t f 718 718 16 1513 0 0 0 0 0 circle_overlap areasel areajoinsel ));
613 DATA(insert OID = 1514 ( ">^" PGNSP PGUID 0 b t f 718 718 16 0 0 0 0 0 0 circle_above positionsel positionjoinsel ));
614 DATA(insert OID = 1515 ( "<^" PGNSP PGUID 0 b t f 718 718 16 0 0 0 0 0 0 circle_below positionsel positionjoinsel ));
616 DATA(insert OID = 1516 ( "+" PGNSP PGUID 0 b t f 718 600 718 0 0 0 0 0 0 circle_add_pt - - ));
617 DATA(insert OID = 1517 ( "-" PGNSP PGUID 0 b t f 718 600 718 0 0 0 0 0 0 circle_sub_pt - - ));
618 DATA(insert OID = 1518 ( "*" PGNSP PGUID 0 b t f 718 600 718 0 0 0 0 0 0 circle_mul_pt - - ));
619 DATA(insert OID = 1519 ( "/" PGNSP PGUID 0 b t f 718 600 718 0 0 0 0 0 0 circle_div_pt - - ));
621 DATA(insert OID = 1520 ( "<->" PGNSP PGUID 0 b t f 718 718 701 1520 0 0 0 0 0 circle_distance - - ));
622 DATA(insert OID = 1521 ( "#" PGNSP PGUID 0 l t f 0 604 23 0 0 0 0 0 0 poly_npoints - - ));
623 DATA(insert OID = 1522 ( "<->" PGNSP PGUID 0 b t f 600 718 701 0 0 0 0 0 0 dist_pc - - ));
624 DATA(insert OID = 1523 ( "<->" PGNSP PGUID 0 b t f 718 604 701 0 0 0 0 0 0 dist_cpoly - - ));
626 /* additional geometric operators - thomas 1997-07-09 */
627 DATA(insert OID = 1524 ( "<->" PGNSP PGUID 0 b t f 628 603 701 0 0 0 0 0 0 dist_lb - - ));
629 DATA(insert OID = 1525 ( "?#" PGNSP PGUID 0 b t f 601 601 16 1525 0 0 0 0 0 lseg_intersect - - ));
630 DATA(insert OID = 1526 ( "?||" PGNSP PGUID 0 b t f 601 601 16 1526 0 0 0 0 0 lseg_parallel - - ));
631 DATA(insert OID = 1527 ( "?-|" PGNSP PGUID 0 b t f 601 601 16 1527 0 0 0 0 0 lseg_perp - - ));
632 DATA(insert OID = 1528 ( "?-" PGNSP PGUID 0 l t f 0 601 16 0 0 0 0 0 0 lseg_horizontal - - ));
633 DATA(insert OID = 1529 ( "?|" PGNSP PGUID 0 l t f 0 601 16 0 0 0 0 0 0 lseg_vertical - - ));
634 DATA(insert OID = 1535 ( "=" PGNSP PGUID 0 b t f 601 601 16 1535 1586 0 0 0 0 lseg_eq eqsel eqjoinsel ));
635 DATA(insert OID = 1536 ( "#" PGNSP PGUID 0 b t f 601 601 600 1536 0 0 0 0 0 lseg_interpt - - ));
636 DATA(insert OID = 1537 ( "?#" PGNSP PGUID 0 b t f 601 628 16 0 0 0 0 0 0 inter_sl - - ));
637 DATA(insert OID = 1538 ( "?#" PGNSP PGUID 0 b t f 601 603 16 0 0 0 0 0 0 inter_sb - - ));
638 DATA(insert OID = 1539 ( "?#" PGNSP PGUID 0 b t f 628 603 16 0 0 0 0 0 0 inter_lb - - ));
640 DATA(insert OID = 1546 ( "@" PGNSP PGUID 0 b t f 600 628 16 0 0 0 0 0 0 on_pl - - ));
641 DATA(insert OID = 1547 ( "@" PGNSP PGUID 0 b t f 600 601 16 0 0 0 0 0 0 on_ps - - ));
642 DATA(insert OID = 1548 ( "@" PGNSP PGUID 0 b t f 601 628 16 0 0 0 0 0 0 on_sl - - ));
643 DATA(insert OID = 1549 ( "@" PGNSP PGUID 0 b t f 601 603 16 0 0 0 0 0 0 on_sb - - ));
645 DATA(insert OID = 1557 ( "##" PGNSP PGUID 0 b t f 600 628 600 0 0 0 0 0 0 close_pl - - ));
646 DATA(insert OID = 1558 ( "##" PGNSP PGUID 0 b t f 600 601 600 0 0 0 0 0 0 close_ps - - ));
647 DATA(insert OID = 1559 ( "##" PGNSP PGUID 0 b t f 600 603 600 0 0 0 0 0 0 close_pb - - ));
649 DATA(insert OID = 1566 ( "##" PGNSP PGUID 0 b t f 601 628 600 0 0 0 0 0 0 close_sl - - ));
650 DATA(insert OID = 1567 ( "##" PGNSP PGUID 0 b t f 601 603 600 0 0 0 0 0 0 close_sb - - ));
651 DATA(insert OID = 1568 ( "##" PGNSP PGUID 0 b t f 628 603 600 0 0 0 0 0 0 close_lb - - ));
652 DATA(insert OID = 1577 ( "##" PGNSP PGUID 0 b t f 628 601 600 0 0 0 0 0 0 close_ls - - ));
653 DATA(insert OID = 1578 ( "##" PGNSP PGUID 0 b t f 601 601 600 0 0 0 0 0 0 close_lseg - - ));
654 DATA(insert OID = 1583 ( "*" PGNSP PGUID 0 b t f 1186 701 1186 0 0 0 0 0 0 interval_mul - - ));
655 DATA(insert OID = 1584 ( "*" PGNSP PGUID 0 b t f 701 1186 1186 0 0 0 0 0 0 mul_d_interval - - ));
656 DATA(insert OID = 1585 ( "/" PGNSP PGUID 0 b t f 1186 701 1186 0 0 0 0 0 0 interval_div - - ));
658 DATA(insert OID = 1586 ( "<>" PGNSP PGUID 0 b t f 601 601 16 1586 1535 0 0 0 0 lseg_ne neqsel neqjoinsel ));
659 DATA(insert OID = 1587 ( "<" PGNSP PGUID 0 b t f 601 601 16 1589 1590 0 0 0 0 lseg_lt - - ));
660 DATA(insert OID = 1588 ( "<=" PGNSP PGUID 0 b t f 601 601 16 1590 1589 0 0 0 0 lseg_le - - ));
661 DATA(insert OID = 1589 ( ">" PGNSP PGUID 0 b t f 601 601 16 1587 1588 0 0 0 0 lseg_gt - - ));
662 DATA(insert OID = 1590 ( ">=" PGNSP PGUID 0 b t f 601 601 16 1588 1587 0 0 0 0 lseg_ge - - ));
664 DATA(insert OID = 1591 ( "@-@" PGNSP PGUID 0 l t f 0 601 701 0 0 0 0 0 0 lseg_length - - ));
666 DATA(insert OID = 1611 ( "?#" PGNSP PGUID 0 b t f 628 628 16 1611 0 0 0 0 0 line_intersect - - ));
667 DATA(insert OID = 1612 ( "?||" PGNSP PGUID 0 b t f 628 628 16 1612 0 0 0 0 0 line_parallel - - ));
668 DATA(insert OID = 1613 ( "?-|" PGNSP PGUID 0 b t f 628 628 16 1613 0 0 0 0 0 line_perp - - ));
669 DATA(insert OID = 1614 ( "?-" PGNSP PGUID 0 l t f 0 628 16 0 0 0 0 0 0 line_horizontal - - ));
670 DATA(insert OID = 1615 ( "?|" PGNSP PGUID 0 l t f 0 628 16 0 0 0 0 0 0 line_vertical - - ));
671 DATA(insert OID = 1616 ( "=" PGNSP PGUID 0 b t f 628 628 16 1616 0 0 0 0 0 line_eq eqsel eqjoinsel ));
672 DATA(insert OID = 1617 ( "#" PGNSP PGUID 0 b t f 628 628 600 1617 0 0 0 0 0 line_interpt - - ));
675 DATA(insert OID = 1220 ( "=" PGNSP PGUID 0 b t f 829 829 16 1220 1221 1222 1222 1222 1224 macaddr_eq eqsel eqjoinsel ));
676 DATA(insert OID = 1221 ( "<>" PGNSP PGUID 0 b t f 829 829 16 1221 1220 0 0 0 0 macaddr_ne neqsel neqjoinsel ));
677 DATA(insert OID = 1222 ( "<" PGNSP PGUID 0 b t f 829 829 16 1224 1225 0 0 0 0 macaddr_lt scalarltsel scalarltjoinsel ));
678 DATA(insert OID = 1223 ( "<=" PGNSP PGUID 0 b t f 829 829 16 1225 1224 0 0 0 0 macaddr_le scalarltsel scalarltjoinsel ));
679 DATA(insert OID = 1224 ( ">" PGNSP PGUID 0 b t f 829 829 16 1222 1223 0 0 0 0 macaddr_gt scalargtsel scalargtjoinsel ));
680 DATA(insert OID = 1225 ( ">=" PGNSP PGUID 0 b t f 829 829 16 1223 1222 0 0 0 0 macaddr_ge scalargtsel scalargtjoinsel ));
683 DATA(insert OID = 1201 ( "=" PGNSP PGUID 0 b t f 869 869 16 1201 1202 1203 1203 1203 1205 network_eq eqsel eqjoinsel ));
684 DATA(insert OID = 1202 ( "<>" PGNSP PGUID 0 b t f 869 869 16 1202 1201 0 0 0 0 network_ne neqsel neqjoinsel ));
685 DATA(insert OID = 1203 ( "<" PGNSP PGUID 0 b t f 869 869 16 1205 1206 0 0 0 0 network_lt scalarltsel scalarltjoinsel ));
686 DATA(insert OID = 1204 ( "<=" PGNSP PGUID 0 b t f 869 869 16 1206 1205 0 0 0 0 network_le scalarltsel scalarltjoinsel ));
687 DATA(insert OID = 1205 ( ">" PGNSP PGUID 0 b t f 869 869 16 1203 1204 0 0 0 0 network_gt scalargtsel scalargtjoinsel ));
688 DATA(insert OID = 1206 ( ">=" PGNSP PGUID 0 b t f 869 869 16 1204 1203 0 0 0 0 network_ge scalargtsel scalargtjoinsel ));
689 DATA(insert OID = 931 ( "<<" PGNSP PGUID 0 b t f 869 869 16 933 0 0 0 0 0 network_sub - - ));
690 #define OID_INET_SUB_OP 931
691 DATA(insert OID = 932 ( "<<=" PGNSP PGUID 0 b t f 869 869 16 934 0 0 0 0 0 network_subeq - - ));
692 #define OID_INET_SUBEQ_OP 932
693 DATA(insert OID = 933 ( ">>" PGNSP PGUID 0 b t f 869 869 16 931 0 0 0 0 0 network_sup - - ));
694 #define OID_INET_SUP_OP 933
695 DATA(insert OID = 934 ( ">>=" PGNSP PGUID 0 b t f 869 869 16 932 0 0 0 0 0 network_supeq - - ));
696 #define OID_INET_SUPEQ_OP 934
699 DATA(insert OID = 820 ( "=" PGNSP PGUID 0 b t f 650 650 16 820 821 822 822 822 824 network_eq eqsel eqjoinsel ));
700 DATA(insert OID = 821 ( "<>" PGNSP PGUID 0 b t f 650 650 16 821 820 0 0 0 0 network_ne neqsel neqjoinsel ));
701 DATA(insert OID = 822 ( "<" PGNSP PGUID 0 b t f 650 650 16 824 825 0 0 0 0 network_lt scalarltsel scalarltjoinsel ));
702 DATA(insert OID = 823 ( "<=" PGNSP PGUID 0 b t f 650 650 16 825 824 0 0 0 0 network_le scalarltsel scalarltjoinsel ));
703 DATA(insert OID = 824 ( ">" PGNSP PGUID 0 b t f 650 650 16 822 823 0 0 0 0 network_gt scalargtsel scalargtjoinsel ));
704 DATA(insert OID = 825 ( ">=" PGNSP PGUID 0 b t f 650 650 16 823 822 0 0 0 0 network_ge scalargtsel scalargtjoinsel ));
705 DATA(insert OID = 826 ( "<<" PGNSP PGUID 0 b t f 650 650 16 828 0 0 0 0 0 network_sub - - ));
706 #define OID_CIDR_SUB_OP 826
707 DATA(insert OID = 827 ( "<<=" PGNSP PGUID 0 b t f 650 650 16 1004 0 0 0 0 0 network_subeq - - ));
708 #define OID_CIDR_SUBEQ_OP 827
709 DATA(insert OID = 828 ( ">>" PGNSP PGUID 0 b t f 650 650 16 826 0 0 0 0 0 network_sup - - ));
710 #define OID_CIDR_SUP_OP 828
711 DATA(insert OID = 1004 ( ">>=" PGNSP PGUID 0 b t f 650 650 16 827 0 0 0 0 0 network_supeq - - ));
712 #define OID_CIDR_SUPEQ_OP 1004
714 /* case-insensitive LIKE hacks */
715 DATA(insert OID = 1625 ( "~~*" PGNSP PGUID 0 b t f 19 25 16 0 1626 0 0 0 0 nameiclike iclikesel iclikejoinsel ));
716 #define OID_NAME_ICLIKE_OP 1625
717 DATA(insert OID = 1626 ( "!~~*" PGNSP PGUID 0 b t f 19 25 16 0 1625 0 0 0 0 nameicnlike icnlikesel icnlikejoinsel ));
718 DATA(insert OID = 1627 ( "~~*" PGNSP PGUID 0 b t f 25 25 16 0 1628 0 0 0 0 texticlike iclikesel iclikejoinsel ));
719 #define OID_TEXT_ICLIKE_OP 1627
720 DATA(insert OID = 1628 ( "!~~*" PGNSP PGUID 0 b t f 25 25 16 0 1627 0 0 0 0 texticnlike icnlikesel icnlikejoinsel ));
721 DATA(insert OID = 1629 ( "~~*" PGNSP PGUID 0 b t f 1042 25 16 0 1630 0 0 0 0 texticlike iclikesel iclikejoinsel ));
722 #define OID_BPCHAR_ICLIKE_OP 1629
723 DATA(insert OID = 1630 ( "!~~*" PGNSP PGUID 0 b t f 1042 25 16 0 1629 0 0 0 0 texticnlike icnlikesel icnlikejoinsel ));
724 DATA(insert OID = 1631 ( "~~*" PGNSP PGUID 0 b t f 1043 25 16 0 1632 0 0 0 0 texticlike iclikesel iclikejoinsel ));
725 #define OID_VARCHAR_ICLIKE_OP 1631
726 DATA(insert OID = 1632 ( "!~~*" PGNSP PGUID 0 b t f 1043 25 16 0 1631 0 0 0 0 texticnlike icnlikesel icnlikejoinsel ));
728 /* int4 vs oid comparisons --- use oid (unsigned) comparison */
729 DATA(insert OID = 1656 ( "<>" PGNSP PGUID 0 b t f 23 26 16 1661 1136 0 0 0 0 oidne neqsel neqjoinsel ));
730 DATA(insert OID = 1657 ( "<" PGNSP PGUID 0 b t f 23 26 16 1663 1660 0 0 0 0 oidlt scalarltsel scalarltjoinsel ));
731 DATA(insert OID = 1658 ( ">" PGNSP PGUID 0 b t f 23 26 16 1662 1659 0 0 0 0 oidgt scalargtsel scalargtjoinsel ));
732 DATA(insert OID = 1659 ( "<=" PGNSP PGUID 0 b t f 23 26 16 1665 1658 0 0 0 0 oidle scalarltsel scalarltjoinsel ));
733 DATA(insert OID = 1660 ( ">=" PGNSP PGUID 0 b t f 23 26 16 1664 1657 0 0 0 0 oidge scalargtsel scalargtjoinsel ));
734 DATA(insert OID = 1661 ( "<>" PGNSP PGUID 0 b t f 26 23 16 1656 1137 0 0 0 0 oidne neqsel neqjoinsel ));
735 DATA(insert OID = 1662 ( "<" PGNSP PGUID 0 b t f 26 23 16 1658 1665 0 0 0 0 oidlt scalarltsel scalarltjoinsel ));
736 DATA(insert OID = 1663 ( ">" PGNSP PGUID 0 b t f 26 23 16 1657 1664 0 0 0 0 oidgt scalargtsel scalargtjoinsel ));
737 DATA(insert OID = 1664 ( "<=" PGNSP PGUID 0 b t f 26 23 16 1660 1663 0 0 0 0 oidle scalarltsel scalarltjoinsel ));
738 DATA(insert OID = 1665 ( ">=" PGNSP PGUID 0 b t f 26 23 16 1659 1662 0 0 0 0 oidge scalargtsel scalargtjoinsel ));
740 /* NUMERIC type - OID's 1700-1799 */
741 DATA(insert OID = 1751 ( "-" PGNSP PGUID 0 l t f 0 1700 1700 0 0 0 0 0 0 numeric_uminus - - ));
742 DATA(insert OID = 1752 ( "=" PGNSP PGUID 0 b t f 1700 1700 16 1752 1753 1754 1754 1754 1756 numeric_eq eqsel eqjoinsel ));
743 DATA(insert OID = 1753 ( "<>" PGNSP PGUID 0 b t f 1700 1700 16 1753 1752 0 0 0 0 numeric_ne neqsel neqjoinsel ));
744 DATA(insert OID = 1754 ( "<" PGNSP PGUID 0 b t f 1700 1700 16 1756 1757 0 0 0 0 numeric_lt scalarltsel scalarltjoinsel ));
745 DATA(insert OID = 1755 ( "<=" PGNSP PGUID 0 b t f 1700 1700 16 1757 1756 0 0 0 0 numeric_le scalarltsel scalarltjoinsel ));
746 DATA(insert OID = 1756 ( ">" PGNSP PGUID 0 b t f 1700 1700 16 1754 1755 0 0 0 0 numeric_gt scalargtsel scalargtjoinsel ));
747 DATA(insert OID = 1757 ( ">=" PGNSP PGUID 0 b t f 1700 1700 16 1755 1754 0 0 0 0 numeric_ge scalargtsel scalargtjoinsel ));
748 DATA(insert OID = 1758 ( "+" PGNSP PGUID 0 b t f 1700 1700 1700 1758 0 0 0 0 0 numeric_add - - ));
749 DATA(insert OID = 1759 ( "-" PGNSP PGUID 0 b t f 1700 1700 1700 0 0 0 0 0 0 numeric_sub - - ));
750 DATA(insert OID = 1760 ( "*" PGNSP PGUID 0 b t f 1700 1700 1700 1760 0 0 0 0 0 numeric_mul - - ));
751 DATA(insert OID = 1761 ( "/" PGNSP PGUID 0 b t f 1700 1700 1700 0 0 0 0 0 0 numeric_div - - ));
752 DATA(insert OID = 1762 ( "%" PGNSP PGUID 0 b t f 1700 1700 1700 0 0 0 0 0 0 numeric_mod - - ));
753 DATA(insert OID = 1763 ( "@" PGNSP PGUID 0 l t f 0 1700 1700 0 0 0 0 0 0 numeric_abs - - ));
755 DATA(insert OID = 1784 ( "=" PGNSP PGUID 0 b t f 1560 1560 16 1784 1785 1786 1786 1786 1787 biteq eqsel eqjoinsel ));
756 DATA(insert OID = 1785 ( "<>" PGNSP PGUID 0 b t f 1560 1560 16 1785 1784 0 0 0 0 bitne neqsel neqjoinsel ));
757 DATA(insert OID = 1786 ( "<" PGNSP PGUID 0 b t f 1560 1560 16 1787 1789 0 0 0 0 bitlt scalarltsel scalarltjoinsel ));
758 DATA(insert OID = 1787 ( ">" PGNSP PGUID 0 b t f 1560 1560 16 1786 1788 0 0 0 0 bitgt scalargtsel scalargtjoinsel ));
759 DATA(insert OID = 1788 ( "<=" PGNSP PGUID 0 b t f 1560 1560 16 1789 1787 0 0 0 0 bitle scalarltsel scalarltjoinsel ));
760 DATA(insert OID = 1789 ( ">=" PGNSP PGUID 0 b t f 1560 1560 16 1788 1786 0 0 0 0 bitge scalargtsel scalargtjoinsel ));
761 DATA(insert OID = 1791 ( "&" PGNSP PGUID 0 b t f 1560 1560 1560 1791 0 0 0 0 0 bitand - - ));
762 DATA(insert OID = 1792 ( "|" PGNSP PGUID 0 b t f 1560 1560 1560 1792 0 0 0 0 0 bitor - - ));
763 DATA(insert OID = 1793 ( "#" PGNSP PGUID 0 b t f 1560 1560 1560 1793 0 0 0 0 0 bitxor - - ));
764 DATA(insert OID = 1794 ( "~" PGNSP PGUID 0 l t f 0 1560 1560 0 0 0 0 0 0 bitnot - - ));
765 DATA(insert OID = 1795 ( "<<" PGNSP PGUID 0 b t f 1560 23 1560 0 0 0 0 0 0 bitshiftleft - - ));
766 DATA(insert OID = 1796 ( ">>" PGNSP PGUID 0 b t f 1560 23 1560 0 0 0 0 0 0 bitshiftright - - ));
767 DATA(insert OID = 1797 ( "||" PGNSP PGUID 0 b t f 1560 1560 1560 0 0 0 0 0 0 bitcat - - ));
769 DATA(insert OID = 1800 ( "+" PGNSP PGUID 0 b t f 1083 1186 1083 0 0 0 0 0 0 time_pl_interval - - ));
770 DATA(insert OID = 1801 ( "-" PGNSP PGUID 0 b t f 1083 1186 1083 0 0 0 0 0 0 time_mi_interval - - ));
771 DATA(insert OID = 1802 ( "+" PGNSP PGUID 0 b t f 1266 1186 1266 0 0 0 0 0 0 timetz_pl_interval - - ));
772 DATA(insert OID = 1803 ( "-" PGNSP PGUID 0 b t f 1266 1186 1266 0 0 0 0 0 0 timetz_mi_interval - - ));
774 DATA(insert OID = 1804 ( "=" PGNSP PGUID 0 b t f 1562 1562 16 1804 1805 1806 1806 1806 1807 varbiteq eqsel eqjoinsel ));
775 DATA(insert OID = 1805 ( "<>" PGNSP PGUID 0 b t f 1562 1562 16 1805 1804 0 0 0 0 varbitne neqsel neqjoinsel ));
776 DATA(insert OID = 1806 ( "<" PGNSP PGUID 0 b t f 1562 1562 16 1807 1809 0 0 0 0 varbitlt scalarltsel scalarltjoinsel ));
777 DATA(insert OID = 1807 ( ">" PGNSP PGUID 0 b t f 1562 1562 16 1806 1808 0 0 0 0 varbitgt scalargtsel scalargtjoinsel ));
778 DATA(insert OID = 1808 ( "<=" PGNSP PGUID 0 b t f 1562 1562 16 1809 1807 0 0 0 0 varbitle scalarltsel scalarltjoinsel ));
779 DATA(insert OID = 1809 ( ">=" PGNSP PGUID 0 b t f 1562 1562 16 1808 1806 0 0 0 0 varbitge scalargtsel scalargtjoinsel ));
781 DATA(insert OID = 1849 ( "+" PGNSP PGUID 0 b t f 1186 1083 1083 0 0 0 0 0 0 interval_pl_time - - ));
783 DATA(insert OID = 1862 ( "=" PGNSP PGUID 0 b t f 21 20 16 1868 1863 95 412 1864 1865 int28eq eqsel eqjoinsel ));
784 DATA(insert OID = 1863 ( "<>" PGNSP PGUID 0 b t f 21 20 16 1869 1862 0 0 0 0 int28ne neqsel neqjoinsel ));
785 DATA(insert OID = 1864 ( "<" PGNSP PGUID 0 b t f 21 20 16 1871 1867 0 0 0 0 int28lt scalarltsel scalarltjoinsel ));
786 DATA(insert OID = 1865 ( ">" PGNSP PGUID 0 b t f 21 20 16 1870 1866 0 0 0 0 int28gt scalargtsel scalargtjoinsel ));
787 DATA(insert OID = 1866 ( "<=" PGNSP PGUID 0 b t f 21 20 16 1873 1865 0 0 0 0 int28le scalarltsel scalarltjoinsel ));
788 DATA(insert OID = 1867 ( ">=" PGNSP PGUID 0 b t f 21 20 16 1872 1864 0 0 0 0 int28ge scalargtsel scalargtjoinsel ));
790 DATA(insert OID = 1868 ( "=" PGNSP PGUID 0 b t f 20 21 16 1862 1869 412 95 1870 1871 int82eq eqsel eqjoinsel ));
791 DATA(insert OID = 1869 ( "<>" PGNSP PGUID 0 b t f 20 21 16 1863 1868 0 0 0 0 int82ne neqsel neqjoinsel ));
792 DATA(insert OID = 1870 ( "<" PGNSP PGUID 0 b t f 20 21 16 1865 1873 0 0 0 0 int82lt scalarltsel scalarltjoinsel ));
793 DATA(insert OID = 1871 ( ">" PGNSP PGUID 0 b t f 20 21 16 1864 1872 0 0 0 0 int82gt scalargtsel scalargtjoinsel ));
794 DATA(insert OID = 1872 ( "<=" PGNSP PGUID 0 b t f 20 21 16 1867 1871 0 0 0 0 int82le scalarltsel scalarltjoinsel ));
795 DATA(insert OID = 1873 ( ">=" PGNSP PGUID 0 b t f 20 21 16 1866 1870 0 0 0 0 int82ge scalargtsel scalargtjoinsel ));
797 DATA(insert OID = 1874 ( "&" PGNSP PGUID 0 b t f 21 21 21 1874 0 0 0 0 0 int2and - - ));
798 DATA(insert OID = 1875 ( "|" PGNSP PGUID 0 b t f 21 21 21 1875 0 0 0 0 0 int2or - - ));
799 DATA(insert OID = 1876 ( "#" PGNSP PGUID 0 b t f 21 21 21 1876 0 0 0 0 0 int2xor - - ));
800 DATA(insert OID = 1877 ( "~" PGNSP PGUID 0 l t f 0 21 21 0 0 0 0 0 0 int2not - - ));
801 DATA(insert OID = 1878 ( "<<" PGNSP PGUID 0 b t f 21 23 21 0 0 0 0 0 0 int2shl - - ));
802 DATA(insert OID = 1879 ( ">>" PGNSP PGUID 0 b t f 21 23 21 0 0 0 0 0 0 int2shr - - ));
804 DATA(insert OID = 1880 ( "&" PGNSP PGUID 0 b t f 23 23 23 1880 0 0 0 0 0 int4and - - ));
805 DATA(insert OID = 1881 ( "|" PGNSP PGUID 0 b t f 23 23 23 1881 0 0 0 0 0 int4or - - ));
806 DATA(insert OID = 1882 ( "#" PGNSP PGUID 0 b t f 23 23 23 1882 0 0 0 0 0 int4xor - - ));
807 DATA(insert OID = 1883 ( "~" PGNSP PGUID 0 l t f 0 23 23 0 0 0 0 0 0 int4not - - ));
808 DATA(insert OID = 1884 ( "<<" PGNSP PGUID 0 b t f 23 23 23 0 0 0 0 0 0 int4shl - - ));
809 DATA(insert OID = 1885 ( ">>" PGNSP PGUID 0 b t f 23 23 23 0 0 0 0 0 0 int4shr - - ));
811 DATA(insert OID = 1886 ( "&" PGNSP PGUID 0 b t f 20 20 20 1886 0 0 0 0 0 int8and - - ));
812 DATA(insert OID = 1887 ( "|" PGNSP PGUID 0 b t f 20 20 20 1887 0 0 0 0 0 int8or - - ));
813 DATA(insert OID = 1888 ( "#" PGNSP PGUID 0 b t f 20 20 20 1888 0 0 0 0 0 int8xor - - ));
814 DATA(insert OID = 1889 ( "~" PGNSP PGUID 0 l t f 0 20 20 0 0 0 0 0 0 int8not - - ));
815 DATA(insert OID = 1890 ( "<<" PGNSP PGUID 0 b t f 20 23 20 0 0 0 0 0 0 int8shl - - ));
816 DATA(insert OID = 1891 ( ">>" PGNSP PGUID 0 b t f 20 23 20 0 0 0 0 0 0 int8shr - - ));
818 DATA(insert OID = 1916 ( "+" PGNSP PGUID 0 l t f 0 20 20 0 0 0 0 0 0 int8up - - ));
819 DATA(insert OID = 1917 ( "+" PGNSP PGUID 0 l t f 0 21 21 0 0 0 0 0 0 int2up - - ));
820 DATA(insert OID = 1918 ( "+" PGNSP PGUID 0 l t f 0 23 23 0 0 0 0 0 0 int4up - - ));
821 DATA(insert OID = 1919 ( "+" PGNSP PGUID 0 l t f 0 700 700 0 0 0 0 0 0 float4up - - ));
822 DATA(insert OID = 1920 ( "+" PGNSP PGUID 0 l t f 0 701 701 0 0 0 0 0 0 float8up - - ));
823 DATA(insert OID = 1921 ( "+" PGNSP PGUID 0 l t f 0 1700 1700 0 0 0 0 0 0 numeric_uplus - - ));
825 /* bytea operators */
826 DATA(insert OID = 1955 ( "=" PGNSP PGUID 0 b t t 17 17 16 1955 1956 1957 1957 1957 1959 byteaeq eqsel eqjoinsel ));
827 DATA(insert OID = 1956 ( "<>" PGNSP PGUID 0 b t f 17 17 16 1956 1955 0 0 0 0 byteane neqsel neqjoinsel ));
828 DATA(insert OID = 1957 ( "<" PGNSP PGUID 0 b t f 17 17 16 1959 1960 0 0 0 0 bytealt scalarltsel scalarltjoinsel ));
829 DATA(insert OID = 1958 ( "<=" PGNSP PGUID 0 b t f 17 17 16 1960 1959 0 0 0 0 byteale scalarltsel scalarltjoinsel ));
830 DATA(insert OID = 1959 ( ">" PGNSP PGUID 0 b t f 17 17 16 1957 1958 0 0 0 0 byteagt scalargtsel scalargtjoinsel ));
831 DATA(insert OID = 1960 ( ">=" PGNSP PGUID 0 b t f 17 17 16 1958 1957 0 0 0 0 byteage scalargtsel scalargtjoinsel ));
832 DATA(insert OID = 2016 ( "~~" PGNSP PGUID 0 b t f 17 17 16 0 2017 0 0 0 0 bytealike likesel likejoinsel ));
833 #define OID_BYTEA_LIKE_OP 2016
834 DATA(insert OID = 2017 ( "!~~" PGNSP PGUID 0 b t f 17 17 16 0 2016 0 0 0 0 byteanlike nlikesel nlikejoinsel ));
835 DATA(insert OID = 2018 ( "||" PGNSP PGUID 0 b t f 17 17 17 0 0 0 0 0 0 byteacat - - ));
837 /* timestamp operators */
838 DATA(insert OID = 2060 ( "=" PGNSP PGUID 0 b t f 1114 1114 16 2060 2061 2062 2062 2062 2064 timestamp_eq eqsel eqjoinsel ));
839 DATA(insert OID = 2061 ( "<>" PGNSP PGUID 0 b t f 1114 1114 16 2061 2060 0 0 0 0 timestamp_ne neqsel neqjoinsel ));
840 DATA(insert OID = 2062 ( "<" PGNSP PGUID 0 b t f 1114 1114 16 2064 2065 0 0 0 0 timestamp_lt scalarltsel scalarltjoinsel ));
841 DATA(insert OID = 2063 ( "<=" PGNSP PGUID 0 b t f 1114 1114 16 2065 2064 0 0 0 0 timestamp_le scalarltsel scalarltjoinsel ));
842 DATA(insert OID = 2064 ( ">" PGNSP PGUID 0 b t f 1114 1114 16 2062 2063 0 0 0 0 timestamp_gt scalargtsel scalargtjoinsel ));
843 DATA(insert OID = 2065 ( ">=" PGNSP PGUID 0 b t f 1114 1114 16 2063 2062 0 0 0 0 timestamp_ge scalargtsel scalargtjoinsel ));
844 DATA(insert OID = 2066 ( "+" PGNSP PGUID 0 b t f 1114 1186 1114 0 0 0 0 0 0 timestamp_pl_span - - ));
845 DATA(insert OID = 2067 ( "-" PGNSP PGUID 0 b t f 1114 1114 1186 0 0 0 0 0 0 timestamp_mi - - ));
846 DATA(insert OID = 2068 ( "-" PGNSP PGUID 0 b t f 1114 1186 1114 0 0 0 0 0 0 timestamp_mi_span - - ));
850 * function prototypes
852 extern void OperatorCreate(const char *operatorName,
853 Oid operatorNamespace,
858 bool isLeftAssociative,
859 List *commutatorName,
861 List *restrictionName,
867 List *gtCompareName);
869 #endif /* PG_OPERATOR_H */