Header And Logo
|
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 */
1.7.1