Header And Logo

PostgreSQL
| The world's most advanced open source database.

pg_amop.h

Go to the documentation of this file.
00001 /*-------------------------------------------------------------------------
00002  *
00003  * pg_amop.h
00004  *    definition of the system "amop" relation (pg_amop)
00005  *    along with the relation's initial contents.
00006  *
00007  * The amop table identifies the operators associated with each index operator
00008  * family and operator class (classes are subsets of families).  An associated
00009  * operator can be either a search operator or an ordering operator, as
00010  * identified by amoppurpose.
00011  *
00012  * The primary key for this table is <amopfamily, amoplefttype, amoprighttype,
00013  * amopstrategy>.  amoplefttype and amoprighttype are just copies of the
00014  * operator's oprleft/oprright, ie its declared input data types.  The
00015  * "default" operators for a particular opclass within the family are those
00016  * with amoplefttype = amoprighttype = opclass's opcintype.  An opfamily may
00017  * also contain other operators, typically cross-data-type operators.  All the
00018  * operators within a family are supposed to be compatible, in a way that is
00019  * defined by each individual index AM.
00020  *
00021  * We also keep a unique index on <amopopr, amoppurpose, amopfamily>, so that
00022  * we can use a syscache to quickly answer questions of the form "is this
00023  * operator in this opfamily, and if so what are its semantics with respect to
00024  * the family?"  This implies that the same operator cannot be listed for
00025  * multiple strategy numbers within a single opfamily, with the exception that
00026  * it's possible to list it for both search and ordering purposes (with
00027  * different strategy numbers for the two purposes).
00028  *
00029  * amopmethod is a copy of the owning opfamily's opfmethod field.  This is an
00030  * intentional denormalization of the catalogs to buy lookup speed.
00031  *
00032  *
00033  * Portions Copyright (c) 1996-2013, PostgreSQL Global Development Group
00034  * Portions Copyright (c) 1994, Regents of the University of California
00035  *
00036  * src/include/catalog/pg_amop.h
00037  *
00038  * NOTES
00039  *   the genbki.pl script reads this file and generates .bki
00040  *   information from the DATA() statements.
00041  *
00042  *-------------------------------------------------------------------------
00043  */
00044 #ifndef PG_AMOP_H
00045 #define PG_AMOP_H
00046 
00047 #include "catalog/genbki.h"
00048 
00049 /* ----------------
00050  *      pg_amop definition.  cpp turns this into
00051  *      typedef struct FormData_pg_amop
00052  * ----------------
00053  */
00054 #define AccessMethodOperatorRelationId  2602
00055 
00056 CATALOG(pg_amop,2602)
00057 {
00058     Oid         amopfamily;     /* the index opfamily this entry is for */
00059     Oid         amoplefttype;   /* operator's left input data type */
00060     Oid         amoprighttype;  /* operator's right input data type */
00061     int16       amopstrategy;   /* operator strategy number */
00062     char        amoppurpose;    /* is operator for 's'earch or 'o'rdering? */
00063     Oid         amopopr;        /* the operator's pg_operator OID */
00064     Oid         amopmethod;     /* the index access method this entry is for */
00065     Oid         amopsortfamily; /* ordering opfamily OID, or 0 if search op */
00066 } FormData_pg_amop;
00067 
00068 /* allowed values of amoppurpose: */
00069 #define AMOP_SEARCH     's'     /* operator is for search */
00070 #define AMOP_ORDER      'o'     /* operator is for ordering */
00071 
00072 /* ----------------
00073  *      Form_pg_amop corresponds to a pointer to a tuple with
00074  *      the format of pg_amop relation.
00075  * ----------------
00076  */
00077 typedef FormData_pg_amop *Form_pg_amop;
00078 
00079 /* ----------------
00080  *      compiler constants for pg_amop
00081  * ----------------
00082  */
00083 #define Natts_pg_amop                   8
00084 #define Anum_pg_amop_amopfamily         1
00085 #define Anum_pg_amop_amoplefttype       2
00086 #define Anum_pg_amop_amoprighttype      3
00087 #define Anum_pg_amop_amopstrategy       4
00088 #define Anum_pg_amop_amoppurpose        5
00089 #define Anum_pg_amop_amopopr            6
00090 #define Anum_pg_amop_amopmethod         7
00091 #define Anum_pg_amop_amopsortfamily     8
00092 
00093 /* ----------------
00094  *      initial contents of pg_amop
00095  * ----------------
00096  */
00097 
00098 /*
00099  *  btree integer_ops
00100  */
00101 
00102 /* default operators int2 */
00103 DATA(insert (   1976   21 21 1 s    95  403 0 ));
00104 DATA(insert (   1976   21 21 2 s    522 403 0 ));
00105 DATA(insert (   1976   21 21 3 s    94  403 0 ));
00106 DATA(insert (   1976   21 21 4 s    524 403 0 ));
00107 DATA(insert (   1976   21 21 5 s    520 403 0 ));
00108 /* crosstype operators int24 */
00109 DATA(insert (   1976   21 23 1 s    534 403 0 ));
00110 DATA(insert (   1976   21 23 2 s    540 403 0 ));
00111 DATA(insert (   1976   21 23 3 s    532 403 0 ));
00112 DATA(insert (   1976   21 23 4 s    542 403 0 ));
00113 DATA(insert (   1976   21 23 5 s    536 403 0 ));
00114 /* crosstype operators int28 */
00115 DATA(insert (   1976   21 20 1 s    1864    403 0 ));
00116 DATA(insert (   1976   21 20 2 s    1866    403 0 ));
00117 DATA(insert (   1976   21 20 3 s    1862    403 0 ));
00118 DATA(insert (   1976   21 20 4 s    1867    403 0 ));
00119 DATA(insert (   1976   21 20 5 s    1865    403 0 ));
00120 /* default operators int4 */
00121 DATA(insert (   1976   23 23 1 s    97  403 0 ));
00122 DATA(insert (   1976   23 23 2 s    523 403 0 ));
00123 DATA(insert (   1976   23 23 3 s    96  403 0 ));
00124 DATA(insert (   1976   23 23 4 s    525 403 0 ));
00125 DATA(insert (   1976   23 23 5 s    521 403 0 ));
00126 /* crosstype operators int42 */
00127 DATA(insert (   1976   23 21 1 s    535 403 0 ));
00128 DATA(insert (   1976   23 21 2 s    541 403 0 ));
00129 DATA(insert (   1976   23 21 3 s    533 403 0 ));
00130 DATA(insert (   1976   23 21 4 s    543 403 0 ));
00131 DATA(insert (   1976   23 21 5 s    537 403 0 ));
00132 /* crosstype operators int48 */
00133 DATA(insert (   1976   23 20 1 s    37  403 0 ));
00134 DATA(insert (   1976   23 20 2 s    80  403 0 ));
00135 DATA(insert (   1976   23 20 3 s    15  403 0 ));
00136 DATA(insert (   1976   23 20 4 s    82  403 0 ));
00137 DATA(insert (   1976   23 20 5 s    76  403 0 ));
00138 /* default operators int8 */
00139 DATA(insert (   1976   20 20 1 s    412 403 0 ));
00140 DATA(insert (   1976   20 20 2 s    414 403 0 ));
00141 DATA(insert (   1976   20 20 3 s    410 403 0 ));
00142 DATA(insert (   1976   20 20 4 s    415 403 0 ));
00143 DATA(insert (   1976   20 20 5 s    413 403 0 ));
00144 /* crosstype operators int82 */
00145 DATA(insert (   1976   20 21 1 s    1870    403 0 ));
00146 DATA(insert (   1976   20 21 2 s    1872    403 0 ));
00147 DATA(insert (   1976   20 21 3 s    1868    403 0 ));
00148 DATA(insert (   1976   20 21 4 s    1873    403 0 ));
00149 DATA(insert (   1976   20 21 5 s    1871    403 0 ));
00150 /* crosstype operators int84 */
00151 DATA(insert (   1976   20 23 1 s    418 403 0 ));
00152 DATA(insert (   1976   20 23 2 s    420 403 0 ));
00153 DATA(insert (   1976   20 23 3 s    416 403 0 ));
00154 DATA(insert (   1976   20 23 4 s    430 403 0 ));
00155 DATA(insert (   1976   20 23 5 s    419 403 0 ));
00156 
00157 /*
00158  *  btree oid_ops
00159  */
00160 
00161 DATA(insert (   1989   26 26 1 s    609 403 0 ));
00162 DATA(insert (   1989   26 26 2 s    611 403 0 ));
00163 DATA(insert (   1989   26 26 3 s    607 403 0 ));
00164 DATA(insert (   1989   26 26 4 s    612 403 0 ));
00165 DATA(insert (   1989   26 26 5 s    610 403 0 ));
00166 
00167 /*
00168  * btree tid_ops
00169  */
00170 
00171 DATA(insert (   2789   27 27 1 s 2799 403 0 ));
00172 DATA(insert (   2789   27 27 2 s 2801 403 0 ));
00173 DATA(insert (   2789   27 27 3 s 387  403 0 ));
00174 DATA(insert (   2789   27 27 4 s 2802 403 0 ));
00175 DATA(insert (   2789   27 27 5 s 2800 403 0 ));
00176 
00177 /*
00178  *  btree oidvector_ops
00179  */
00180 
00181 DATA(insert (   1991   30 30 1 s    645 403 0 ));
00182 DATA(insert (   1991   30 30 2 s    647 403 0 ));
00183 DATA(insert (   1991   30 30 3 s    649 403 0 ));
00184 DATA(insert (   1991   30 30 4 s    648 403 0 ));
00185 DATA(insert (   1991   30 30 5 s    646 403 0 ));
00186 
00187 /*
00188  *  btree float_ops
00189  */
00190 
00191 /* default operators float4 */
00192 DATA(insert (   1970   700 700 1 s  622 403 0 ));
00193 DATA(insert (   1970   700 700 2 s  624 403 0 ));
00194 DATA(insert (   1970   700 700 3 s  620 403 0 ));
00195 DATA(insert (   1970   700 700 4 s  625 403 0 ));
00196 DATA(insert (   1970   700 700 5 s  623 403 0 ));
00197 /* crosstype operators float48 */
00198 DATA(insert (   1970   700 701 1 s  1122 403 0 ));
00199 DATA(insert (   1970   700 701 2 s  1124 403 0 ));
00200 DATA(insert (   1970   700 701 3 s  1120 403 0 ));
00201 DATA(insert (   1970   700 701 4 s  1125 403 0 ));
00202 DATA(insert (   1970   700 701 5 s  1123 403 0 ));
00203 /* default operators float8 */
00204 DATA(insert (   1970   701 701 1 s  672 403 0 ));
00205 DATA(insert (   1970   701 701 2 s  673 403 0 ));
00206 DATA(insert (   1970   701 701 3 s  670 403 0 ));
00207 DATA(insert (   1970   701 701 4 s  675 403 0 ));
00208 DATA(insert (   1970   701 701 5 s  674 403 0 ));
00209 /* crosstype operators float84 */
00210 DATA(insert (   1970   701 700 1 s  1132 403 0 ));
00211 DATA(insert (   1970   701 700 2 s  1134 403 0 ));
00212 DATA(insert (   1970   701 700 3 s  1130 403 0 ));
00213 DATA(insert (   1970   701 700 4 s  1135 403 0 ));
00214 DATA(insert (   1970   701 700 5 s  1133 403 0 ));
00215 
00216 /*
00217  *  btree char_ops
00218  */
00219 
00220 DATA(insert (   429   18 18 1 s  631    403 0 ));
00221 DATA(insert (   429   18 18 2 s  632    403 0 ));
00222 DATA(insert (   429   18 18 3 s   92    403 0 ));
00223 DATA(insert (   429   18 18 4 s  634    403 0 ));
00224 DATA(insert (   429   18 18 5 s  633    403 0 ));
00225 
00226 /*
00227  *  btree name_ops
00228  */
00229 
00230 DATA(insert (   1986   19 19 1 s    660 403 0 ));
00231 DATA(insert (   1986   19 19 2 s    661 403 0 ));
00232 DATA(insert (   1986   19 19 3 s    93  403 0 ));
00233 DATA(insert (   1986   19 19 4 s    663 403 0 ));
00234 DATA(insert (   1986   19 19 5 s    662 403 0 ));
00235 
00236 /*
00237  *  btree text_ops
00238  */
00239 
00240 DATA(insert (   1994   25 25 1 s    664 403 0 ));
00241 DATA(insert (   1994   25 25 2 s    665 403 0 ));
00242 DATA(insert (   1994   25 25 3 s    98  403 0 ));
00243 DATA(insert (   1994   25 25 4 s    667 403 0 ));
00244 DATA(insert (   1994   25 25 5 s    666 403 0 ));
00245 
00246 /*
00247  *  btree bpchar_ops
00248  */
00249 
00250 DATA(insert (   426   1042 1042 1 s 1058    403 0 ));
00251 DATA(insert (   426   1042 1042 2 s 1059    403 0 ));
00252 DATA(insert (   426   1042 1042 3 s 1054    403 0 ));
00253 DATA(insert (   426   1042 1042 4 s 1061    403 0 ));
00254 DATA(insert (   426   1042 1042 5 s 1060    403 0 ));
00255 
00256 /*
00257  *  btree bytea_ops
00258  */
00259 
00260 DATA(insert (   428   17 17 1 s 1957    403 0 ));
00261 DATA(insert (   428   17 17 2 s 1958    403 0 ));
00262 DATA(insert (   428   17 17 3 s 1955    403 0 ));
00263 DATA(insert (   428   17 17 4 s 1960    403 0 ));
00264 DATA(insert (   428   17 17 5 s 1959    403 0 ));
00265 
00266 /*
00267  *  btree abstime_ops
00268  */
00269 
00270 DATA(insert (   421   702 702 1 s  562  403 0 ));
00271 DATA(insert (   421   702 702 2 s  564  403 0 ));
00272 DATA(insert (   421   702 702 3 s  560  403 0 ));
00273 DATA(insert (   421   702 702 4 s  565  403 0 ));
00274 DATA(insert (   421   702 702 5 s  563  403 0 ));
00275 
00276 /*
00277  *  btree datetime_ops
00278  */
00279 
00280 /* default operators date */
00281 DATA(insert (   434   1082 1082 1 s 1095    403 0 ));
00282 DATA(insert (   434   1082 1082 2 s 1096    403 0 ));
00283 DATA(insert (   434   1082 1082 3 s 1093    403 0 ));
00284 DATA(insert (   434   1082 1082 4 s 1098    403 0 ));
00285 DATA(insert (   434   1082 1082 5 s 1097    403 0 ));
00286 /* crosstype operators vs timestamp */
00287 DATA(insert (   434   1082 1114 1 s 2345    403 0 ));
00288 DATA(insert (   434   1082 1114 2 s 2346    403 0 ));
00289 DATA(insert (   434   1082 1114 3 s 2347    403 0 ));
00290 DATA(insert (   434   1082 1114 4 s 2348    403 0 ));
00291 DATA(insert (   434   1082 1114 5 s 2349    403 0 ));
00292 /* crosstype operators vs timestamptz */
00293 DATA(insert (   434   1082 1184 1 s 2358    403 0 ));
00294 DATA(insert (   434   1082 1184 2 s 2359    403 0 ));
00295 DATA(insert (   434   1082 1184 3 s 2360    403 0 ));
00296 DATA(insert (   434   1082 1184 4 s 2361    403 0 ));
00297 DATA(insert (   434   1082 1184 5 s 2362    403 0 ));
00298 /* default operators timestamp */
00299 DATA(insert (   434   1114 1114 1 s 2062    403 0 ));
00300 DATA(insert (   434   1114 1114 2 s 2063    403 0 ));
00301 DATA(insert (   434   1114 1114 3 s 2060    403 0 ));
00302 DATA(insert (   434   1114 1114 4 s 2065    403 0 ));
00303 DATA(insert (   434   1114 1114 5 s 2064    403 0 ));
00304 /* crosstype operators vs date */
00305 DATA(insert (   434   1114 1082 1 s 2371    403 0 ));
00306 DATA(insert (   434   1114 1082 2 s 2372    403 0 ));
00307 DATA(insert (   434   1114 1082 3 s 2373    403 0 ));
00308 DATA(insert (   434   1114 1082 4 s 2374    403 0 ));
00309 DATA(insert (   434   1114 1082 5 s 2375    403 0 ));
00310 /* crosstype operators vs timestamptz */
00311 DATA(insert (   434   1114 1184 1 s 2534    403 0 ));
00312 DATA(insert (   434   1114 1184 2 s 2535    403 0 ));
00313 DATA(insert (   434   1114 1184 3 s 2536    403 0 ));
00314 DATA(insert (   434   1114 1184 4 s 2537    403 0 ));
00315 DATA(insert (   434   1114 1184 5 s 2538    403 0 ));
00316 /* default operators timestamptz */
00317 DATA(insert (   434   1184 1184 1 s 1322    403 0 ));
00318 DATA(insert (   434   1184 1184 2 s 1323    403 0 ));
00319 DATA(insert (   434   1184 1184 3 s 1320    403 0 ));
00320 DATA(insert (   434   1184 1184 4 s 1325    403 0 ));
00321 DATA(insert (   434   1184 1184 5 s 1324    403 0 ));
00322 /* crosstype operators vs date */
00323 DATA(insert (   434   1184 1082 1 s 2384    403 0 ));
00324 DATA(insert (   434   1184 1082 2 s 2385    403 0 ));
00325 DATA(insert (   434   1184 1082 3 s 2386    403 0 ));
00326 DATA(insert (   434   1184 1082 4 s 2387    403 0 ));
00327 DATA(insert (   434   1184 1082 5 s 2388    403 0 ));
00328 /* crosstype operators vs timestamp */
00329 DATA(insert (   434   1184 1114 1 s 2540    403 0 ));
00330 DATA(insert (   434   1184 1114 2 s 2541    403 0 ));
00331 DATA(insert (   434   1184 1114 3 s 2542    403 0 ));
00332 DATA(insert (   434   1184 1114 4 s 2543    403 0 ));
00333 DATA(insert (   434   1184 1114 5 s 2544    403 0 ));
00334 
00335 /*
00336  *  btree time_ops
00337  */
00338 
00339 DATA(insert (   1996   1083 1083 1 s 1110 403 0 ));
00340 DATA(insert (   1996   1083 1083 2 s 1111 403 0 ));
00341 DATA(insert (   1996   1083 1083 3 s 1108 403 0 ));
00342 DATA(insert (   1996   1083 1083 4 s 1113 403 0 ));
00343 DATA(insert (   1996   1083 1083 5 s 1112 403 0 ));
00344 
00345 /*
00346  *  btree timetz_ops
00347  */
00348 
00349 DATA(insert (   2000   1266 1266 1 s 1552 403 0 ));
00350 DATA(insert (   2000   1266 1266 2 s 1553 403 0 ));
00351 DATA(insert (   2000   1266 1266 3 s 1550 403 0 ));
00352 DATA(insert (   2000   1266 1266 4 s 1555 403 0 ));
00353 DATA(insert (   2000   1266 1266 5 s 1554 403 0 ));
00354 
00355 /*
00356  *  btree interval_ops
00357  */
00358 
00359 DATA(insert (   1982   1186 1186 1 s 1332 403 0 ));
00360 DATA(insert (   1982   1186 1186 2 s 1333 403 0 ));
00361 DATA(insert (   1982   1186 1186 3 s 1330 403 0 ));
00362 DATA(insert (   1982   1186 1186 4 s 1335 403 0 ));
00363 DATA(insert (   1982   1186 1186 5 s 1334 403 0 ));
00364 
00365 /*
00366  *  btree macaddr
00367  */
00368 
00369 DATA(insert (   1984   829 829 1 s 1222 403 0 ));
00370 DATA(insert (   1984   829 829 2 s 1223 403 0 ));
00371 DATA(insert (   1984   829 829 3 s 1220 403 0 ));
00372 DATA(insert (   1984   829 829 4 s 1225 403 0 ));
00373 DATA(insert (   1984   829 829 5 s 1224 403 0 ));
00374 
00375 /*
00376  *  btree network
00377  */
00378 
00379 DATA(insert (   1974   869 869 1 s 1203 403 0 ));
00380 DATA(insert (   1974   869 869 2 s 1204 403 0 ));
00381 DATA(insert (   1974   869 869 3 s 1201 403 0 ));
00382 DATA(insert (   1974   869 869 4 s 1206 403 0 ));
00383 DATA(insert (   1974   869 869 5 s 1205 403 0 ));
00384 
00385 /*
00386  *  btree numeric
00387  */
00388 
00389 DATA(insert (   1988   1700 1700 1 s 1754 403 0 ));
00390 DATA(insert (   1988   1700 1700 2 s 1755 403 0 ));
00391 DATA(insert (   1988   1700 1700 3 s 1752 403 0 ));
00392 DATA(insert (   1988   1700 1700 4 s 1757 403 0 ));
00393 DATA(insert (   1988   1700 1700 5 s 1756 403 0 ));
00394 
00395 /*
00396  *  btree bool
00397  */
00398 
00399 DATA(insert (   424   16 16 1 s 58      403 0 ));
00400 DATA(insert (   424   16 16 2 s 1694    403 0 ));
00401 DATA(insert (   424   16 16 3 s 91      403 0 ));
00402 DATA(insert (   424   16 16 4 s 1695    403 0 ));
00403 DATA(insert (   424   16 16 5 s 59      403 0 ));
00404 
00405 /*
00406  *  btree bit
00407  */
00408 
00409 DATA(insert (   423   1560 1560 1 s 1786    403 0 ));
00410 DATA(insert (   423   1560 1560 2 s 1788    403 0 ));
00411 DATA(insert (   423   1560 1560 3 s 1784    403 0 ));
00412 DATA(insert (   423   1560 1560 4 s 1789    403 0 ));
00413 DATA(insert (   423   1560 1560 5 s 1787    403 0 ));
00414 
00415 /*
00416  *  btree varbit
00417  */
00418 
00419 DATA(insert (   2002   1562 1562 1 s 1806 403 0 ));
00420 DATA(insert (   2002   1562 1562 2 s 1808 403 0 ));
00421 DATA(insert (   2002   1562 1562 3 s 1804 403 0 ));
00422 DATA(insert (   2002   1562 1562 4 s 1809 403 0 ));
00423 DATA(insert (   2002   1562 1562 5 s 1807 403 0 ));
00424 
00425 /*
00426  *  btree text pattern
00427  */
00428 
00429 DATA(insert (   2095   25 25 1 s 2314 403 0 ));
00430 DATA(insert (   2095   25 25 2 s 2315 403 0 ));
00431 DATA(insert (   2095   25 25 3 s 98   403 0 ));
00432 DATA(insert (   2095   25 25 4 s 2317 403 0 ));
00433 DATA(insert (   2095   25 25 5 s 2318 403 0 ));
00434 
00435 /*
00436  *  btree bpchar pattern
00437  */
00438 
00439 DATA(insert (   2097   1042 1042 1 s 2326 403 0 ));
00440 DATA(insert (   2097   1042 1042 2 s 2327 403 0 ));
00441 DATA(insert (   2097   1042 1042 3 s 1054 403 0 ));
00442 DATA(insert (   2097   1042 1042 4 s 2329 403 0 ));
00443 DATA(insert (   2097   1042 1042 5 s 2330 403 0 ));
00444 
00445 /*
00446  *  btree money_ops
00447  */
00448 
00449 DATA(insert (   2099   790 790 1 s  902 403 0 ));
00450 DATA(insert (   2099   790 790 2 s  904 403 0 ));
00451 DATA(insert (   2099   790 790 3 s  900 403 0 ));
00452 DATA(insert (   2099   790 790 4 s  905 403 0 ));
00453 DATA(insert (   2099   790 790 5 s  903 403 0 ));
00454 
00455 /*
00456  *  btree reltime_ops
00457  */
00458 
00459 DATA(insert (   2233   703 703 1 s  568 403 0 ));
00460 DATA(insert (   2233   703 703 2 s  570 403 0 ));
00461 DATA(insert (   2233   703 703 3 s  566 403 0 ));
00462 DATA(insert (   2233   703 703 4 s  571 403 0 ));
00463 DATA(insert (   2233   703 703 5 s  569 403 0 ));
00464 
00465 /*
00466  *  btree tinterval_ops
00467  */
00468 
00469 DATA(insert (   2234   704 704 1 s  813 403 0 ));
00470 DATA(insert (   2234   704 704 2 s  815 403 0 ));
00471 DATA(insert (   2234   704 704 3 s  811 403 0 ));
00472 DATA(insert (   2234   704 704 4 s  816 403 0 ));
00473 DATA(insert (   2234   704 704 5 s  814 403 0 ));
00474 
00475 /*
00476  *  btree array_ops
00477  */
00478 
00479 DATA(insert (   397   2277 2277 1 s 1072    403 0 ));
00480 DATA(insert (   397   2277 2277 2 s 1074    403 0 ));
00481 DATA(insert (   397   2277 2277 3 s 1070    403 0 ));
00482 DATA(insert (   397   2277 2277 4 s 1075    403 0 ));
00483 DATA(insert (   397   2277 2277 5 s 1073    403 0 ));
00484 
00485 /*
00486  *  btree record_ops
00487  */
00488 
00489 DATA(insert (   2994  2249 2249 1 s 2990    403 0 ));
00490 DATA(insert (   2994  2249 2249 2 s 2992    403 0 ));
00491 DATA(insert (   2994  2249 2249 3 s 2988    403 0 ));
00492 DATA(insert (   2994  2249 2249 4 s 2993    403 0 ));
00493 DATA(insert (   2994  2249 2249 5 s 2991    403 0 ));
00494 
00495 /*
00496  * btree uuid_ops
00497  */
00498 
00499 DATA(insert (   2968  2950 2950 1 s 2974    403 0 ));
00500 DATA(insert (   2968  2950 2950 2 s 2976    403 0 ));
00501 DATA(insert (   2968  2950 2950 3 s 2972    403 0 ));
00502 DATA(insert (   2968  2950 2950 4 s 2977    403 0 ));
00503 DATA(insert (   2968  2950 2950 5 s 2975    403 0 ));
00504 
00505 /*
00506  *  hash index _ops
00507  */
00508 
00509 /* bpchar_ops */
00510 DATA(insert (   427   1042 1042 1 s 1054    405 0 ));
00511 /* char_ops */
00512 DATA(insert (   431   18 18 1 s 92  405 0 ));
00513 /* date_ops */
00514 DATA(insert (   435   1082 1082 1 s 1093    405 0 ));
00515 /* float_ops */
00516 DATA(insert (   1971   700 700 1 s  620 405 0 ));
00517 DATA(insert (   1971   701 701 1 s  670 405 0 ));
00518 DATA(insert (   1971   700 701 1 s 1120 405 0 ));
00519 DATA(insert (   1971   701 700 1 s 1130 405 0 ));
00520 /* network_ops */
00521 DATA(insert (   1975   869 869 1 s 1201 405 0 ));
00522 /* integer_ops */
00523 DATA(insert (   1977   21 21 1 s    94   405 0 ));
00524 DATA(insert (   1977   23 23 1 s    96   405 0 ));
00525 DATA(insert (   1977   20 20 1 s    410  405 0 ));
00526 DATA(insert (   1977   21 23 1 s    532  405 0 ));
00527 DATA(insert (   1977   21 20 1 s    1862 405 0 ));
00528 DATA(insert (   1977   23 21 1 s    533  405 0 ));
00529 DATA(insert (   1977   23 20 1 s    15   405 0 ));
00530 DATA(insert (   1977   20 21 1 s    1868 405 0 ));
00531 DATA(insert (   1977   20 23 1 s    416  405 0 ));
00532 /* interval_ops */
00533 DATA(insert (   1983   1186 1186 1 s 1330 405 0 ));
00534 /* macaddr_ops */
00535 DATA(insert (   1985   829 829 1 s 1220 405 0 ));
00536 /* name_ops */
00537 DATA(insert (   1987   19 19 1 s    93  405 0 ));
00538 /* oid_ops */
00539 DATA(insert (   1990   26 26 1 s    607 405 0 ));
00540 /* oidvector_ops */
00541 DATA(insert (   1992   30 30 1 s    649 405 0 ));
00542 /* text_ops */
00543 DATA(insert (   1995   25 25 1 s    98  405 0 ));
00544 /* time_ops */
00545 DATA(insert (   1997   1083 1083 1 s 1108 405 0 ));
00546 /* timestamptz_ops */
00547 DATA(insert (   1999   1184 1184 1 s 1320 405 0 ));
00548 /* timetz_ops */
00549 DATA(insert (   2001   1266 1266 1 s 1550 405 0 ));
00550 /* timestamp_ops */
00551 DATA(insert (   2040   1114 1114 1 s 2060 405 0 ));
00552 /* bool_ops */
00553 DATA(insert (   2222   16 16 1 s   91 405 0 ));
00554 /* bytea_ops */
00555 DATA(insert (   2223   17 17 1 s 1955 405 0 ));
00556 /* int2vector_ops */
00557 DATA(insert (   2224   22 22 1 s    386 405 0 ));
00558 /* xid_ops */
00559 DATA(insert (   2225   28 28 1 s    352 405 0 ));
00560 /* cid_ops */
00561 DATA(insert (   2226   29 29 1 s    385 405 0 ));
00562 /* abstime_ops */
00563 DATA(insert (   2227   702 702 1 s  560 405 0 ));
00564 /* reltime_ops */
00565 DATA(insert (   2228   703 703 1 s  566 405 0 ));
00566 /* text_pattern_ops */
00567 DATA(insert (   2229   25 25 1 s    98  405 0 ));
00568 /* bpchar_pattern_ops */
00569 DATA(insert (   2231   1042 1042 1 s 1054 405 0 ));
00570 /* aclitem_ops */
00571 DATA(insert (   2235   1033 1033 1 s  974 405 0 ));
00572 /* uuid_ops */
00573 DATA(insert (   2969   2950 2950 1 s 2972 405 0 ));
00574 /* numeric_ops */
00575 DATA(insert (   1998   1700 1700 1 s 1752 405 0 ));
00576 /* array_ops */
00577 DATA(insert (   627    2277 2277 1 s 1070 405 0 ));
00578 
00579 
00580 /*
00581  *  gist box_ops
00582  */
00583 
00584 DATA(insert (   2593   603 603 1 s  493 783 0 ));
00585 DATA(insert (   2593   603 603 2 s  494 783 0 ));
00586 DATA(insert (   2593   603 603 3 s  500 783 0 ));
00587 DATA(insert (   2593   603 603 4 s  495 783 0 ));
00588 DATA(insert (   2593   603 603 5 s  496 783 0 ));
00589 DATA(insert (   2593   603 603 6 s  499 783 0 ));
00590 DATA(insert (   2593   603 603 7 s  498 783 0 ));
00591 DATA(insert (   2593   603 603 8 s  497 783 0 ));
00592 DATA(insert (   2593   603 603 9 s  2571 783 0 ));
00593 DATA(insert (   2593   603 603 10 s 2570 783 0 ));
00594 DATA(insert (   2593   603 603 11 s 2573 783 0 ));
00595 DATA(insert (   2593   603 603 12 s 2572 783 0 ));
00596 DATA(insert (   2593   603 603 13 s 2863 783 0 ));
00597 DATA(insert (   2593   603 603 14 s 2862 783 0 ));
00598 
00599 /*
00600  * gist point_ops
00601  */
00602 DATA(insert (   1029   600 600 11 s 506 783 0 ));
00603 DATA(insert (   1029   600 600 1 s  507 783 0 ));
00604 DATA(insert (   1029   600 600 5 s  508 783 0 ));
00605 DATA(insert (   1029   600 600 10 s 509 783 0 ));
00606 DATA(insert (   1029   600 600 6 s  510 783 0 ));
00607 DATA(insert (   1029   600 600 15 o 517 783 1970 ));
00608 DATA(insert (   1029   600 603 28 s 511 783 0 ));
00609 DATA(insert (   1029   600 604 48 s 756 783 0 ));
00610 DATA(insert (   1029   600 718 68 s 758 783 0 ));
00611 
00612 
00613 /*
00614  *  gist poly_ops (supports polygons)
00615  */
00616 
00617 DATA(insert (   2594   604 604 1 s  485 783 0 ));
00618 DATA(insert (   2594   604 604 2 s  486 783 0 ));
00619 DATA(insert (   2594   604 604 3 s  492 783 0 ));
00620 DATA(insert (   2594   604 604 4 s  487 783 0 ));
00621 DATA(insert (   2594   604 604 5 s  488 783 0 ));
00622 DATA(insert (   2594   604 604 6 s  491 783 0 ));
00623 DATA(insert (   2594   604 604 7 s  490 783 0 ));
00624 DATA(insert (   2594   604 604 8 s  489 783 0 ));
00625 DATA(insert (   2594   604 604 9 s  2575 783 0 ));
00626 DATA(insert (   2594   604 604 10 s 2574 783 0 ));
00627 DATA(insert (   2594   604 604 11 s 2577 783 0 ));
00628 DATA(insert (   2594   604 604 12 s 2576 783 0 ));
00629 DATA(insert (   2594   604 604 13 s 2861 783 0 ));
00630 DATA(insert (   2594   604 604 14 s 2860 783 0 ));
00631 
00632 /*
00633  *  gist circle_ops
00634  */
00635 
00636 DATA(insert (   2595   718 718 1 s  1506 783 0 ));
00637 DATA(insert (   2595   718 718 2 s  1507 783 0 ));
00638 DATA(insert (   2595   718 718 3 s  1513 783 0 ));
00639 DATA(insert (   2595   718 718 4 s  1508 783 0 ));
00640 DATA(insert (   2595   718 718 5 s  1509 783 0 ));
00641 DATA(insert (   2595   718 718 6 s  1512 783 0 ));
00642 DATA(insert (   2595   718 718 7 s  1511 783 0 ));
00643 DATA(insert (   2595   718 718 8 s  1510 783 0 ));
00644 DATA(insert (   2595   718 718 9 s  2589 783 0 ));
00645 DATA(insert (   2595   718 718 10 s 1515 783 0 ));
00646 DATA(insert (   2595   718 718 11 s 1514 783 0 ));
00647 DATA(insert (   2595   718 718 12 s 2590 783 0 ));
00648 DATA(insert (   2595   718 718 13 s 2865 783 0 ));
00649 DATA(insert (   2595   718 718 14 s 2864 783 0 ));
00650 
00651 /*
00652  * gin array_ops (these anyarray operators are used with all the opclasses
00653  * of the family)
00654  */
00655 DATA(insert (   2745   2277 2277 1 s 2750 2742 0 ));
00656 DATA(insert (   2745   2277 2277 2 s 2751 2742 0 ));
00657 DATA(insert (   2745   2277 2277 3 s 2752 2742 0 ));
00658 DATA(insert (   2745   2277 2277 4 s 1070 2742 0 ));
00659 
00660 /*
00661  * btree enum_ops
00662  */
00663 DATA(insert (   3522   3500 3500 1 s 3518 403 0 ));
00664 DATA(insert (   3522   3500 3500 2 s 3520 403 0 ));
00665 DATA(insert (   3522   3500 3500 3 s 3516 403 0 ));
00666 DATA(insert (   3522   3500 3500 4 s 3521 403 0 ));
00667 DATA(insert (   3522   3500 3500 5 s 3519 403 0 ));
00668 
00669 /*
00670  * hash enum_ops
00671  */
00672 DATA(insert (   3523   3500 3500 1 s 3516 405 0 ));
00673 
00674 /*
00675  * btree tsvector_ops
00676  */
00677 DATA(insert (   3626   3614 3614 1 s    3627 403 0 ));
00678 DATA(insert (   3626   3614 3614 2 s    3628 403 0 ));
00679 DATA(insert (   3626   3614 3614 3 s    3629 403 0 ));
00680 DATA(insert (   3626   3614 3614 4 s    3631 403 0 ));
00681 DATA(insert (   3626   3614 3614 5 s    3632 403 0 ));
00682 
00683 /*
00684  * GiST tsvector_ops
00685  */
00686 DATA(insert (   3655   3614 3615 1 s    3636 783 0 ));
00687 
00688 /*
00689  * GIN tsvector_ops
00690  */
00691 DATA(insert (   3659   3614 3615 1 s    3636 2742 0 ));
00692 DATA(insert (   3659   3614 3615 2 s    3660 2742 0 ));
00693 
00694 /*
00695  * btree tsquery_ops
00696  */
00697 DATA(insert (   3683   3615 3615 1 s    3674 403 0 ));
00698 DATA(insert (   3683   3615 3615 2 s    3675 403 0 ));
00699 DATA(insert (   3683   3615 3615 3 s    3676 403 0 ));
00700 DATA(insert (   3683   3615 3615 4 s    3678 403 0 ));
00701 DATA(insert (   3683   3615 3615 5 s    3679 403 0 ));
00702 
00703 /*
00704  * GiST tsquery_ops
00705  */
00706 DATA(insert (   3702   3615 3615 7 s    3693 783 0 ));
00707 DATA(insert (   3702   3615 3615 8 s    3694 783 0 ));
00708 
00709 /*
00710  * btree range_ops
00711  */
00712 DATA(insert (   3901   3831 3831 1 s    3884 403 0 ));
00713 DATA(insert (   3901   3831 3831 2 s    3885 403 0 ));
00714 DATA(insert (   3901   3831 3831 3 s    3882 403 0 ));
00715 DATA(insert (   3901   3831 3831 4 s    3886 403 0 ));
00716 DATA(insert (   3901   3831 3831 5 s    3887 403 0 ));
00717 
00718 /*
00719  * hash range_ops
00720  */
00721 DATA(insert (   3903   3831 3831 1 s    3882 405 0 ));
00722 
00723 /*
00724  * GiST range_ops
00725  */
00726 DATA(insert (   3919   3831 3831 1 s    3893 783 0 ));
00727 DATA(insert (   3919   3831 3831 2 s    3895 783 0 ));
00728 DATA(insert (   3919   3831 3831 3 s    3888 783 0 ));
00729 DATA(insert (   3919   3831 3831 4 s    3896 783 0 ));
00730 DATA(insert (   3919   3831 3831 5 s    3894 783 0 ));
00731 DATA(insert (   3919   3831 3831 6 s    3897 783 0 ));
00732 DATA(insert (   3919   3831 3831 7 s    3890 783 0 ));
00733 DATA(insert (   3919   3831 3831 8 s    3892 783 0 ));
00734 DATA(insert (   3919   3831 2283 16 s   3889 783 0 ));
00735 DATA(insert (   3919   3831 3831 18 s   3882 783 0 ));
00736 
00737 /*
00738  * SP-GiST quad_point_ops
00739  */
00740 DATA(insert (   4015   600 600 11 s 506 4000 0 ));
00741 DATA(insert (   4015   600 600 1 s  507 4000 0 ));
00742 DATA(insert (   4015   600 600 5 s  508 4000 0 ));
00743 DATA(insert (   4015   600 600 10 s 509 4000 0 ));
00744 DATA(insert (   4015   600 600 6 s  510 4000 0 ));
00745 DATA(insert (   4015   600 603 8 s  511 4000 0 ));
00746 
00747 /*
00748  * SP-GiST kd_point_ops
00749  */
00750 DATA(insert (   4016   600 600 11 s 506 4000 0 ));
00751 DATA(insert (   4016   600 600 1 s  507 4000 0 ));
00752 DATA(insert (   4016   600 600 5 s  508 4000 0 ));
00753 DATA(insert (   4016   600 600 10 s 509 4000 0 ));
00754 DATA(insert (   4016   600 600 6 s  510 4000 0 ));
00755 DATA(insert (   4016   600 603 8 s  511 4000 0 ));
00756 
00757 /*
00758  * SP-GiST text_ops
00759  */
00760 DATA(insert (   4017   25 25 1 s    2314 4000 0 ));
00761 DATA(insert (   4017   25 25 2 s    2315 4000 0 ));
00762 DATA(insert (   4017   25 25 3 s    98  4000 0 ));
00763 DATA(insert (   4017   25 25 4 s    2317 4000 0 ));
00764 DATA(insert (   4017   25 25 5 s    2318 4000 0 ));
00765 DATA(insert (   4017   25 25 11 s   664 4000 0 ));
00766 DATA(insert (   4017   25 25 12 s   665 4000 0 ));
00767 DATA(insert (   4017   25 25 14 s   667 4000 0 ));
00768 DATA(insert (   4017   25 25 15 s   666 4000 0 ));
00769 
00770 /*
00771  * SP-GiST range_ops
00772  */
00773 DATA(insert (   3474   3831 3831 1 s    3893 4000 0 ));
00774 DATA(insert (   3474   3831 3831 2 s    3895 4000 0 ));
00775 DATA(insert (   3474   3831 3831 3 s    3888 4000 0 ));
00776 DATA(insert (   3474   3831 3831 4 s    3896 4000 0 ));
00777 DATA(insert (   3474   3831 3831 5 s    3894 4000 0 ));
00778 DATA(insert (   3474   3831 3831 6 s    3897 4000 0 ));
00779 DATA(insert (   3474   3831 3831 7 s    3890 4000 0 ));
00780 DATA(insert (   3474   3831 3831 8 s    3892 4000 0 ));
00781 DATA(insert (   3474   3831 2283 16 s   3889 4000 0 ));
00782 DATA(insert (   3474   3831 3831 18 s   3882 4000 0 ));
00783 
00784 #endif   /* PG_AMOP_H */