src/include/catalog/pg_amop.h

   1 /*-------------------------------------------------------------------------
   2  *
   3  * pg_amop.h
   4  *        definition of the system "amop" relation (pg_amop)
   5  *        along with the relation's initial contents.
   6  *
   7  * The amop table identifies the operators associated with each index operator
   8  * family and operator class (classes are subsets of families).
   9  *
  10  * The primary key for this table is <amopfamily, amoplefttype, amoprighttype,
  11  * amopstrategy>.  amoplefttype and amoprighttype are just copies of the
  12  * operator's oprleft/oprright, ie its declared input data types.  The
  13  * "default" operators for a particular opclass within the family are those
  14  * with amoplefttype = amoprighttype = opclass's opcintype.  An opfamily may
  15  * also contain other operators, typically cross-data-type operators.  All the
  16  * operators within a family are supposed to be compatible, in a way that is
  17  * defined by each individual index AM.
  18  *
  19  * We also keep a unique index on <amopfamily, amopopr>, so that we can use a
  20  * syscache to quickly answer questions of the form "is this operator in this
  21  * opfamily, and if so what are its semantics with respect to the family?"
  22  * This implies that the same operator cannot be listed for multiple strategy
  23  * numbers within a single opfamily.
  24  *
  25  * amopmethod is a copy of the owning opfamily's opfmethod field.  This is an
  26  * intentional denormalization of the catalogs to buy lookup speed.
  27  *
  28  *
  29  * Portions Copyright (c) 1996-2009, PostgreSQL Global Development Group
  30  * Portions Copyright (c) 1994, Regents of the University of California
  31  *
  32  * $PostgreSQL$
  33  *
  34  * NOTES
  35  *       the genbki.sh script reads this file and generates .bki
  36  *       information from the DATA() statements.
  37  *
  38  *-------------------------------------------------------------------------
  39  */
  40 #ifndef PG_AMOP_H
  41 #define PG_AMOP_H
  42
  43 #include "catalog/genbki.h"
  44
  45 /* ----------------
  46  *              pg_amop definition.  cpp turns this into
  47  *              typedef struct FormData_pg_amop
  48  * ----------------
  49  */
  50 #define AccessMethodOperatorRelationId  2602
  51
  52 CATALOG(pg_amop,2602)
  53 {
  54         Oid                     amopfamily;             /* the index opfamily this entry is for */
  55         Oid                     amoplefttype;   /* operator's left input data type */
  56         Oid                     amoprighttype;  /* operator's right input data type */
  57         int2            amopstrategy;   /* operator strategy number */
  58         Oid                     amopopr;                /* the operator's pg_operator OID */
  59         Oid                     amopmethod;             /* the index access method this entry is for */
  60 } FormData_pg_amop;
  61
  62 /* ----------------
  63  *              Form_pg_amop corresponds to a pointer to a tuple with
  64  *              the format of pg_amop relation.
  65  * ----------------
  66  */
  67 typedef FormData_pg_amop *Form_pg_amop;
  68
  69 /* ----------------
  70  *              compiler constants for pg_amop
  71  * ----------------
  72  */
  73 #define Natts_pg_amop                                   6
  74 #define Anum_pg_amop_amopfamily                 1
  75 #define Anum_pg_amop_amoplefttype               2
  76 #define Anum_pg_amop_amoprighttype              3
  77 #define Anum_pg_amop_amopstrategy               4
  78 #define Anum_pg_amop_amopopr                    5
  79 #define Anum_pg_amop_amopmethod                 6
  80
  81 /* ----------------
  82  *              initial contents of pg_amop
  83  * ----------------
  84  */
  85
  86 /*
  87  *      btree integer_ops
  88  */
  89
  90 /* default operators int2 */
  91 DATA(insert (   1976   21 21 1  95      403 ));
  92 DATA(insert (   1976   21 21 2  522 403 ));
  93 DATA(insert (   1976   21 21 3  94      403 ));
  94 DATA(insert (   1976   21 21 4  524 403 ));
  95 DATA(insert (   1976   21 21 5  520 403 ));
  96 /* crosstype operators int24 */
  97 DATA(insert (   1976   21 23 1  534 403 ));
  98 DATA(insert (   1976   21 23 2  540 403 ));
  99 DATA(insert (   1976   21 23 3  532 403 ));
 100 DATA(insert (   1976   21 23 4  542 403 ));
 101 DATA(insert (   1976   21 23 5  536 403 ));
 102 /* crosstype operators int28 */
 103 DATA(insert (   1976   21 20 1  1864    403 ));
 104 DATA(insert (   1976   21 20 2  1866    403 ));
 105 DATA(insert (   1976   21 20 3  1862    403 ));
 106 DATA(insert (   1976   21 20 4  1867    403 ));
 107 DATA(insert (   1976   21 20 5  1865    403 ));
 108 /* default operators int4 */
 109 DATA(insert (   1976   23 23 1  97      403 ));
 110 DATA(insert (   1976   23 23 2  523 403 ));
 111 DATA(insert (   1976   23 23 3  96      403 ));
 112 DATA(insert (   1976   23 23 4  525 403 ));
 113 DATA(insert (   1976   23 23 5  521 403 ));
 114 /* crosstype operators int42 */
 115 DATA(insert (   1976   23 21 1  535 403 ));
 116 DATA(insert (   1976   23 21 2  541 403 ));
 117 DATA(insert (   1976   23 21 3  533 403 ));
 118 DATA(insert (   1976   23 21 4  543 403 ));
 119 DATA(insert (   1976   23 21 5  537 403 ));
 120 /* crosstype operators int48 */
 121 DATA(insert (   1976   23 20 1  37      403 ));
 122 DATA(insert (   1976   23 20 2  80      403 ));
 123 DATA(insert (   1976   23 20 3  15      403 ));
 124 DATA(insert (   1976   23 20 4  82      403 ));
 125 DATA(insert (   1976   23 20 5  76      403 ));
 126 /* default operators int8 */
 127 DATA(insert (   1976   20 20 1  412 403 ));
 128 DATA(insert (   1976   20 20 2  414 403 ));
 129 DATA(insert (   1976   20 20 3  410 403 ));
 130 DATA(insert (   1976   20 20 4  415 403 ));
 131 DATA(insert (   1976   20 20 5  413 403 ));
 132 /* crosstype operators int82 */
 133 DATA(insert (   1976   20 21 1  1870    403 ));
 134 DATA(insert (   1976   20 21 2  1872    403 ));
 135 DATA(insert (   1976   20 21 3  1868    403 ));
 136 DATA(insert (   1976   20 21 4  1873    403 ));
 137 DATA(insert (   1976   20 21 5  1871    403 ));
 138 /* crosstype operators int84 */
 139 DATA(insert (   1976   20 23 1  418 403 ));
 140 DATA(insert (   1976   20 23 2  420 403 ));
 141 DATA(insert (   1976   20 23 3  416 403 ));
 142 DATA(insert (   1976   20 23 4  430 403 ));
 143 DATA(insert (   1976   20 23 5  419 403 ));
 144
 145 /*
 146  *      btree oid_ops
 147  */
 148
 149 DATA(insert (   1989   26 26 1  609 403 ));
 150 DATA(insert (   1989   26 26 2  611 403 ));
 151 DATA(insert (   1989   26 26 3  607 403 ));
 152 DATA(insert (   1989   26 26 4  612 403 ));
 153 DATA(insert (   1989   26 26 5  610 403 ));
 154
 155 /*
 156  * btree tid_ops
 157  */
 158
 159 DATA(insert (   2789   27 27 1 2799 403 ));
 160 DATA(insert (   2789   27 27 2 2801 403 ));
 161 DATA(insert (   2789   27 27 3 387      403 ));
 162 DATA(insert (   2789   27 27 4 2802 403 ));
 163 DATA(insert (   2789   27 27 5 2800 403 ));
 164
 165 /*
 166  *      btree oidvector_ops
 167  */
 168
 169 DATA(insert (   1991   30 30 1  645 403 ));
 170 DATA(insert (   1991   30 30 2  647 403 ));
 171 DATA(insert (   1991   30 30 3  649 403 ));
 172 DATA(insert (   1991   30 30 4  648 403 ));
 173 DATA(insert (   1991   30 30 5  646 403 ));
 174
 175 /*
 176  *      btree float_ops
 177  */
 178
 179 /* default operators float4 */
 180 DATA(insert (   1970   700 700 1        622 403 ));
 181 DATA(insert (   1970   700 700 2        624 403 ));
 182 DATA(insert (   1970   700 700 3        620 403 ));
 183 DATA(insert (   1970   700 700 4        625 403 ));
 184 DATA(insert (   1970   700 700 5        623 403 ));
 185 /* crosstype operators float48 */
 186 DATA(insert (   1970   700 701 1        1122 403 ));
 187 DATA(insert (   1970   700 701 2        1124 403 ));
 188 DATA(insert (   1970   700 701 3        1120 403 ));
 189 DATA(insert (   1970   700 701 4        1125 403 ));
 190 DATA(insert (   1970   700 701 5        1123 403 ));
 191 /* default operators float8 */
 192 DATA(insert (   1970   701 701 1        672 403 ));
 193 DATA(insert (   1970   701 701 2        673 403 ));
 194 DATA(insert (   1970   701 701 3        670 403 ));
 195 DATA(insert (   1970   701 701 4        675 403 ));
 196 DATA(insert (   1970   701 701 5        674 403 ));
 197 /* crosstype operators float84 */
 198 DATA(insert (   1970   701 700 1        1132 403 ));
 199 DATA(insert (   1970   701 700 2        1134 403 ));
 200 DATA(insert (   1970   701 700 3        1130 403 ));
 201 DATA(insert (   1970   701 700 4        1135 403 ));
 202 DATA(insert (   1970   701 700 5        1133 403 ));
 203
 204 /*
 205  *      btree char_ops
 206  */
 207
 208 DATA(insert (   429   18 18 1  631      403 ));
 209 DATA(insert (   429   18 18 2  632      403 ));
 210 DATA(insert (   429   18 18 3 92        403 ));
 211 DATA(insert (   429   18 18 4  634      403 ));
 212 DATA(insert (   429   18 18 5  633      403 ));
 213
 214 /*
 215  *      btree name_ops
 216  */
 217
 218 DATA(insert (   1986   19 19 1  660 403 ));
 219 DATA(insert (   1986   19 19 2  661 403 ));
 220 DATA(insert (   1986   19 19 3  93      403 ));
 221 DATA(insert (   1986   19 19 4  663 403 ));
 222 DATA(insert (   1986   19 19 5  662 403 ));
 223
 224 /*
 225  *      btree text_ops
 226  */
 227
 228 DATA(insert (   1994   25 25 1  664 403 ));
 229 DATA(insert (   1994   25 25 2  665 403 ));
 230 DATA(insert (   1994   25 25 3  98      403 ));
 231 DATA(insert (   1994   25 25 4  667 403 ));
 232 DATA(insert (   1994   25 25 5  666 403 ));
 233
 234 /*
 235  *      btree bpchar_ops
 236  */
 237
 238 DATA(insert (   426   1042 1042 1 1058  403 ));
 239 DATA(insert (   426   1042 1042 2 1059  403 ));
 240 DATA(insert (   426   1042 1042 3 1054  403 ));
 241 DATA(insert (   426   1042 1042 4 1061  403 ));
 242 DATA(insert (   426   1042 1042 5 1060  403 ));
 243
 244 /*
 245  *      btree bytea_ops
 246  */
 247
 248 DATA(insert (   428   17 17 1 1957      403 ));
 249 DATA(insert (   428   17 17 2 1958      403 ));
 250 DATA(insert (   428   17 17 3 1955      403 ));
 251 DATA(insert (   428   17 17 4 1960      403 ));
 252 DATA(insert (   428   17 17 5 1959      403 ));
 253
 254 /*
 255  *      btree abstime_ops
 256  */
 257
 258 DATA(insert (   421   702 702 1  562    403 ));
 259 DATA(insert (   421   702 702 2  564    403 ));
 260 DATA(insert (   421   702 702 3  560    403 ));
 261 DATA(insert (   421   702 702 4  565    403 ));
 262 DATA(insert (   421   702 702 5  563    403 ));
 263
 264 /*
 265  *      btree datetime_ops
 266  */
 267
 268 /* default operators date */
 269 DATA(insert (   434   1082 1082 1 1095  403 ));
 270 DATA(insert (   434   1082 1082 2 1096  403 ));
 271 DATA(insert (   434   1082 1082 3 1093  403 ));
 272 DATA(insert (   434   1082 1082 4 1098  403 ));
 273 DATA(insert (   434   1082 1082 5 1097  403 ));
 274 /* crosstype operators vs timestamp */
 275 DATA(insert (   434   1082 1114 1 2345  403 ));
 276 DATA(insert (   434   1082 1114 2 2346  403 ));
 277 DATA(insert (   434   1082 1114 3 2347  403 ));
 278 DATA(insert (   434   1082 1114 4 2348  403 ));
 279 DATA(insert (   434   1082 1114 5 2349  403 ));
 280 /* crosstype operators vs timestamptz */
 281 DATA(insert (   434   1082 1184 1 2358  403 ));
 282 DATA(insert (   434   1082 1184 2 2359  403 ));
 283 DATA(insert (   434   1082 1184 3 2360  403 ));
 284 DATA(insert (   434   1082 1184 4 2361  403 ));
 285 DATA(insert (   434   1082 1184 5 2362  403 ));
 286 /* default operators timestamp */
 287 DATA(insert (   434   1114 1114 1 2062  403 ));
 288 DATA(insert (   434   1114 1114 2 2063  403 ));
 289 DATA(insert (   434   1114 1114 3 2060  403 ));
 290 DATA(insert (   434   1114 1114 4 2065  403 ));
 291 DATA(insert (   434   1114 1114 5 2064  403 ));
 292 /* crosstype operators vs date */
 293 DATA(insert (   434   1114 1082 1 2371  403 ));
 294 DATA(insert (   434   1114 1082 2 2372  403 ));
 295 DATA(insert (   434   1114 1082 3 2373  403 ));
 296 DATA(insert (   434   1114 1082 4 2374  403 ));
 297 DATA(insert (   434   1114 1082 5 2375  403 ));
 298 /* crosstype operators vs timestamptz */
 299 DATA(insert (   434   1114 1184 1 2534  403 ));
 300 DATA(insert (   434   1114 1184 2 2535  403 ));
 301 DATA(insert (   434   1114 1184 3 2536  403 ));
 302 DATA(insert (   434   1114 1184 4 2537  403 ));
 303 DATA(insert (   434   1114 1184 5 2538  403 ));
 304 /* default operators timestamptz */
 305 DATA(insert (   434   1184 1184 1 1322  403 ));
 306 DATA(insert (   434   1184 1184 2 1323  403 ));
 307 DATA(insert (   434   1184 1184 3 1320  403 ));
 308 DATA(insert (   434   1184 1184 4 1325  403 ));
 309 DATA(insert (   434   1184 1184 5 1324  403 ));
 310 /* crosstype operators vs date */
 311 DATA(insert (   434   1184 1082 1 2384  403 ));
 312 DATA(insert (   434   1184 1082 2 2385  403 ));
 313 DATA(insert (   434   1184 1082 3 2386  403 ));
 314 DATA(insert (   434   1184 1082 4 2387  403 ));
 315 DATA(insert (   434   1184 1082 5 2388  403 ));
 316 /* crosstype operators vs timestamp */
 317 DATA(insert (   434   1184 1114 1 2540  403 ));
 318 DATA(insert (   434   1184 1114 2 2541  403 ));
 319 DATA(insert (   434   1184 1114 3 2542  403 ));
 320 DATA(insert (   434   1184 1114 4 2543  403 ));
 321 DATA(insert (   434   1184 1114 5 2544  403 ));
 322
 323 /*
 324  *      btree time_ops
 325  */
 326
 327 DATA(insert (   1996   1083 1083 1 1110 403 ));
 328 DATA(insert (   1996   1083 1083 2 1111 403 ));
 329 DATA(insert (   1996   1083 1083 3 1108 403 ));
 330 DATA(insert (   1996   1083 1083 4 1113 403 ));
 331 DATA(insert (   1996   1083 1083 5 1112 403 ));
 332
 333 /*
 334  *      btree timetz_ops
 335  */
 336
 337 DATA(insert (   2000   1266 1266 1 1552 403 ));
 338 DATA(insert (   2000   1266 1266 2 1553 403 ));
 339 DATA(insert (   2000   1266 1266 3 1550 403 ));
 340 DATA(insert (   2000   1266 1266 4 1555 403 ));
 341 DATA(insert (   2000   1266 1266 5 1554 403 ));
 342
 343 /*
 344  *      btree interval_ops
 345  */
 346
 347 DATA(insert (   1982   1186 1186 1 1332 403 ));
 348 DATA(insert (   1982   1186 1186 2 1333 403 ));
 349 DATA(insert (   1982   1186 1186 3 1330 403 ));
 350 DATA(insert (   1982   1186 1186 4 1335 403 ));
 351 DATA(insert (   1982   1186 1186 5 1334 403 ));
 352
 353 /*
 354  *      btree macaddr
 355  */
 356
 357 DATA(insert (   1984   829 829 1 1222 403 ));
 358 DATA(insert (   1984   829 829 2 1223 403 ));
 359 DATA(insert (   1984   829 829 3 1220 403 ));
 360 DATA(insert (   1984   829 829 4 1225 403 ));
 361 DATA(insert (   1984   829 829 5 1224 403 ));
 362
 363 /*
 364  *      btree network
 365  */
 366
 367 DATA(insert (   1974   869 869 1 1203 403 ));
 368 DATA(insert (   1974   869 869 2 1204 403 ));
 369 DATA(insert (   1974   869 869 3 1201 403 ));
 370 DATA(insert (   1974   869 869 4 1206 403 ));
 371 DATA(insert (   1974   869 869 5 1205 403 ));
 372
 373 /*
 374  *      btree numeric
 375  */
 376
 377 DATA(insert (   1988   1700 1700 1 1754 403 ));
 378 DATA(insert (   1988   1700 1700 2 1755 403 ));
 379 DATA(insert (   1988   1700 1700 3 1752 403 ));
 380 DATA(insert (   1988   1700 1700 4 1757 403 ));
 381 DATA(insert (   1988   1700 1700 5 1756 403 ));
 382
 383 /*
 384  *      btree bool
 385  */
 386
 387 DATA(insert (   424   16 16 1 58        403 ));
 388 DATA(insert (   424   16 16 2 1694      403 ));
 389 DATA(insert (   424   16 16 3 91        403 ));
 390 DATA(insert (   424   16 16 4 1695      403 ));
 391 DATA(insert (   424   16 16 5 59        403 ));
 392
 393 /*
 394  *      btree bit
 395  */
 396
 397 DATA(insert (   423   1560 1560 1 1786  403 ));
 398 DATA(insert (   423   1560 1560 2 1788  403 ));
 399 DATA(insert (   423   1560 1560 3 1784  403 ));
 400 DATA(insert (   423   1560 1560 4 1789  403 ));
 401 DATA(insert (   423   1560 1560 5 1787  403 ));
 402
 403 /*
 404  *      btree varbit
 405  */
 406
 407 DATA(insert (   2002   1562 1562 1 1806 403 ));
 408 DATA(insert (   2002   1562 1562 2 1808 403 ));
 409 DATA(insert (   2002   1562 1562 3 1804 403 ));
 410 DATA(insert (   2002   1562 1562 4 1809 403 ));
 411 DATA(insert (   2002   1562 1562 5 1807 403 ));
 412
 413 /*
 414  *      btree text pattern
 415  */
 416
 417 DATA(insert (   2095   25 25 1 2314 403 ));
 418 DATA(insert (   2095   25 25 2 2315 403 ));
 419 DATA(insert (   2095   25 25 3 98       403 ));
 420 DATA(insert (   2095   25 25 4 2317 403 ));
 421 DATA(insert (   2095   25 25 5 2318 403 ));
 422
 423 /*
 424  *      btree bpchar pattern
 425  */
 426
 427 DATA(insert (   2097   1042 1042 1 2326 403 ));
 428 DATA(insert (   2097   1042 1042 2 2327 403 ));
 429 DATA(insert (   2097   1042 1042 3 1054 403 ));
 430 DATA(insert (   2097   1042 1042 4 2329 403 ));
 431 DATA(insert (   2097   1042 1042 5 2330 403 ));
 432
 433 /*
 434  *      btree money_ops
 435  */
 436
 437 DATA(insert (   2099   790 790 1        902 403 ));
 438 DATA(insert (   2099   790 790 2        904 403 ));
 439 DATA(insert (   2099   790 790 3        900 403 ));
 440 DATA(insert (   2099   790 790 4        905 403 ));
 441 DATA(insert (   2099   790 790 5        903 403 ));
 442
 443 /*
 444  *      btree reltime_ops
 445  */
 446
 447 DATA(insert (   2233   703 703 1        568 403 ));
 448 DATA(insert (   2233   703 703 2        570 403 ));
 449 DATA(insert (   2233   703 703 3        566 403 ));
 450 DATA(insert (   2233   703 703 4        571 403 ));
 451 DATA(insert (   2233   703 703 5        569 403 ));
 452
 453 /*
 454  *      btree tinterval_ops
 455  */
 456
 457 DATA(insert (   2234   704 704 1        813 403 ));
 458 DATA(insert (   2234   704 704 2        815 403 ));
 459 DATA(insert (   2234   704 704 3        811 403 ));
 460 DATA(insert (   2234   704 704 4        816 403 ));
 461 DATA(insert (   2234   704 704 5        814 403 ));
 462
 463 /*
 464  *      btree array_ops
 465  */
 466
 467 DATA(insert (   397   2277 2277 1 1072  403 ));
 468 DATA(insert (   397   2277 2277 2 1074  403 ));
 469 DATA(insert (   397   2277 2277 3 1070  403 ));
 470 DATA(insert (   397   2277 2277 4 1075  403 ));
 471 DATA(insert (   397   2277 2277 5 1073  403 ));
 472
 473 /*
 474  *      btree record_ops
 475  */
 476
 477 DATA(insert (   2994  2249 2249 1 2990  403 ));
 478 DATA(insert (   2994  2249 2249 2 2992  403 ));
 479 DATA(insert (   2994  2249 2249 3 2988  403 ));
 480 DATA(insert (   2994  2249 2249 4 2993  403 ));
 481 DATA(insert (   2994  2249 2249 5 2991  403 ));
 482
 483 /*
 484  * btree uuid_ops
 485  */
 486
 487 DATA(insert (   2968  2950 2950 1 2974  403 ));
 488 DATA(insert (   2968  2950 2950 2 2976  403 ));
 489 DATA(insert (   2968  2950 2950 3 2972  403 ));
 490 DATA(insert (   2968  2950 2950 4 2977  403 ));
 491 DATA(insert (   2968  2950 2950 5 2975  403 ));
 492
 493 /*
 494  *      hash index _ops
 495  */
 496
 497 /* bpchar_ops */
 498 DATA(insert (   427   1042 1042 1 1054  405 ));
 499 /* char_ops */
 500 DATA(insert (   431   18 18 1 92        405 ));
 501 /* date_ops */
 502 DATA(insert (   435   1082 1082 1 1093  405 ));
 503 /* float_ops */
 504 DATA(insert (   1971   700 700 1        620 405 ));
 505 DATA(insert (   1971   701 701 1        670 405 ));
 506 DATA(insert (   1971   700 701 1 1120 405 ));
 507 DATA(insert (   1971   701 700 1 1130 405 ));
 508 /* network_ops */
 509 DATA(insert (   1975   869 869 1 1201 405 ));
 510 /* integer_ops */
 511 DATA(insert (   1977   21 21 1  94      405 ));
 512 DATA(insert (   1977   23 23 1  96      405 ));
 513 DATA(insert (   1977   20 20 1  410 405 ));
 514 DATA(insert (   1977   21 23 1  532 405 ));
 515 DATA(insert (   1977   21 20 1   1862 405 ));
 516 DATA(insert (   1977   23 21 1  533 405 ));
 517 DATA(insert (   1977   23 20 1  15      405 ));
 518 DATA(insert (   1977   20 21 1   1868 405 ));
 519 DATA(insert (   1977   20 23 1  416 405 ));
 520 /* interval_ops */
 521 DATA(insert (   1983   1186 1186 1 1330 405 ));
 522 /* macaddr_ops */
 523 DATA(insert (   1985   829 829 1 1220 405 ));
 524 /* name_ops */
 525 DATA(insert (   1987   19 19 1  93      405 ));
 526 /* oid_ops */
 527 DATA(insert (   1990   26 26 1  607 405 ));
 528 /* oidvector_ops */
 529 DATA(insert (   1992   30 30 1  649 405 ));
 530 /* text_ops */
 531 DATA(insert (   1995   25 25 1  98      405 ));
 532 /* time_ops */
 533 DATA(insert (   1997   1083 1083 1 1108 405 ));
 534 /* timestamptz_ops */
 535 DATA(insert (   1999   1184 1184 1 1320 405 ));
 536 /* timetz_ops */
 537 DATA(insert (   2001   1266 1266 1 1550 405 ));
 538 /* timestamp_ops */
 539 DATA(insert (   2040   1114 1114 1 2060 405 ));
 540 /* bool_ops */
 541 DATA(insert (   2222   16 16 1  91      405 ));
 542 /* bytea_ops */
 543 DATA(insert (   2223   17 17 1 1955 405 ));
 544 /* int2vector_ops */
 545 DATA(insert (   2224   22 22 1  386 405 ));
 546 /* xid_ops */
 547 DATA(insert (   2225   28 28 1  352 405 ));
 548 /* cid_ops */
 549 DATA(insert (   2226   29 29 1  385 405 ));
 550 /* abstime_ops */
 551 DATA(insert (   2227   702 702 1        560 405 ));
 552 /* reltime_ops */
 553 DATA(insert (   2228   703 703 1        566 405 ));
 554 /* text_pattern_ops */
 555 DATA(insert (   2229   25 25 1 98       405 ));
 556 /* bpchar_pattern_ops */
 557 DATA(insert (   2231   1042 1042 1 1054 405 ));
 558 /* aclitem_ops */
 559 DATA(insert (   2235   1033 1033 1      974 405 ));
 560 /* uuid_ops */
 561 DATA(insert (   2969   2950 2950 1 2972 405 ));
 562 /* numeric_ops */
 563 DATA(insert (   1998   1700 1700 1 1752 405 ));
 564
 565
 566 /*
 567  *      gist box_ops
 568  */
 569
 570 DATA(insert (   2593   603 603 1  493 783 ));
 571 DATA(insert (   2593   603 603 2  494 783 ));
 572 DATA(insert (   2593   603 603 3  500 783 ));
 573 DATA(insert (   2593   603 603 4  495 783 ));
 574 DATA(insert (   2593   603 603 5  496 783 ));
 575 DATA(insert (   2593   603 603 6  499 783 ));
 576 DATA(insert (   2593   603 603 7  498 783 ));
 577 DATA(insert (   2593   603 603 8  497 783 ));
 578 DATA(insert (   2593   603 603 9  2571  783 ));
 579 DATA(insert (   2593   603 603 10 2570  783 ));
 580 DATA(insert (   2593   603 603 11 2573  783 ));
 581 DATA(insert (   2593   603 603 12 2572  783 ));
 582 DATA(insert (   2593   603 603 13 2863  783 ));
 583 DATA(insert (   2593   603 603 14 2862  783 ));
 584
 585 /*
 586  *      gist poly_ops (supports polygons)
 587  */
 588
 589 DATA(insert (   2594   604 604 1  485 783 ));
 590 DATA(insert (   2594   604 604 2  486 783 ));
 591 DATA(insert (   2594   604 604 3  492 783 ));
 592 DATA(insert (   2594   604 604 4  487 783 ));
 593 DATA(insert (   2594   604 604 5  488 783 ));
 594 DATA(insert (   2594   604 604 6  491 783 ));
 595 DATA(insert (   2594   604 604 7  490 783 ));
 596 DATA(insert (   2594   604 604 8  489 783 ));
 597 DATA(insert (   2594   604 604 9  2575  783 ));
 598 DATA(insert (   2594   604 604 10 2574  783 ));
 599 DATA(insert (   2594   604 604 11 2577  783 ));
 600 DATA(insert (   2594   604 604 12 2576  783 ));
 601 DATA(insert (   2594   604 604 13 2861  783 ));
 602 DATA(insert (   2594   604 604 14 2860  783 ));
 603
 604 /*
 605  *      gist circle_ops
 606  */
 607
 608 DATA(insert (   2595   718 718 1  1506  783 ));
 609 DATA(insert (   2595   718 718 2  1507  783 ));
 610 DATA(insert (   2595   718 718 3  1513  783 ));
 611 DATA(insert (   2595   718 718 4  1508  783 ));
 612 DATA(insert (   2595   718 718 5  1509  783 ));
 613 DATA(insert (   2595   718 718 6  1512  783 ));
 614 DATA(insert (   2595   718 718 7  1511  783 ));
 615 DATA(insert (   2595   718 718 8  1510  783 ));
 616 DATA(insert (   2595   718 718 9  2589  783 ));
 617 DATA(insert (   2595   718 718 10 1515  783 ));
 618 DATA(insert (   2595   718 718 11 1514  783 ));
 619 DATA(insert (   2595   718 718 12 2590  783 ));
 620 DATA(insert (   2595   718 718 13 2865  783 ));
 621 DATA(insert (   2595   718 718 14 2864  783 ));
 622
 623 /*
 624  * gin array_ops (these anyarray operators are used with all the opclasses
 625  * of the family)
 626  */
 627 DATA(insert (   2745   2277 2277 1      2750    2742 ));
 628 DATA(insert (   2745   2277 2277 2      2751    2742 ));
 629 DATA(insert (   2745   2277 2277 3      2752    2742 ));
 630 DATA(insert (   2745   2277 2277 4      1070    2742 ));
 631
 632 /*
 633  * btree enum_ops
 634  */
 635 DATA(insert (   3522   3500 3500 1      3518    403 ));
 636 DATA(insert (   3522   3500 3500 2      3520    403 ));
 637 DATA(insert (   3522   3500 3500 3      3516    403 ));
 638 DATA(insert (   3522   3500 3500 4      3521    403 ));
 639 DATA(insert (   3522   3500 3500 5      3519    403 ));
 640
 641 /*
 642  * hash enum_ops
 643  */
 644 DATA(insert (   3523   3500 3500 1      3516    405 ));
 645
 646 /*
 647  * btree tsvector_ops
 648  */
 649 DATA(insert (   3626   3614 3614 1       3627 403 ));
 650 DATA(insert (   3626   3614 3614 2       3628 403 ));
 651 DATA(insert (   3626   3614 3614 3       3629 403 ));
 652 DATA(insert (   3626   3614 3614 4       3631 403 ));
 653 DATA(insert (   3626   3614 3614 5       3632 403 ));
 654
 655 /*
 656  * GiST tsvector_ops
 657  */
 658 DATA(insert (   3655   3614 3615 1      3636 783 ));
 659
 660 /*
 661  * GIN tsvector_ops
 662  */
 663 DATA(insert (   3659   3614 3615 1      3636 2742 ));
 664 DATA(insert (   3659   3614 3615 2      3660 2742 ));
 665
 666 /*
 667  * btree tsquery_ops
 668  */
 669 DATA(insert (   3683   3615 3615 1       3674 403 ));
 670 DATA(insert (   3683   3615 3615 2       3675 403 ));
 671 DATA(insert (   3683   3615 3615 3       3676 403 ));
 672 DATA(insert (   3683   3615 3615 4       3678 403 ));
 673 DATA(insert (   3683   3615 3615 5       3679 403 ));
 674
 675 /*
 676  * GiST tsquery_ops
 677  */
 678 DATA(insert (   3702   3615 3615 7      3693 783 ));
 679 DATA(insert (   3702   3615 3615 8      3694 783 ));
 680
 681 #endif   /* PG_AMOP_H */