Header And Logo

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

pg_amproc.h

Go to the documentation of this file.
00001 /*-------------------------------------------------------------------------
00002  *
00003  * pg_amproc.h
00004  *    definition of the system "amproc" relation (pg_amproc)
00005  *    along with the relation's initial contents.
00006  *
00007  * The amproc table identifies support procedures associated with index
00008  * operator families and classes.  These procedures can't be listed in pg_amop
00009  * since they are not the implementation of any indexable operator.
00010  *
00011  * The primary key for this table is <amprocfamily, amproclefttype,
00012  * amprocrighttype, amprocnum>.  The "default" support functions for a
00013  * particular opclass within the family are those with amproclefttype =
00014  * amprocrighttype = opclass's opcintype.  These are the ones loaded into the
00015  * relcache for an index and typically used for internal index operations.
00016  * Other support functions are typically used to handle cross-type indexable
00017  * operators with oprleft/oprright matching the entry's amproclefttype and
00018  * amprocrighttype. The exact behavior depends on the index AM, however, and
00019  * some don't pay attention to non-default functions at all.
00020  *
00021  *
00022  * Portions Copyright (c) 1996-2013, PostgreSQL Global Development Group
00023  * Portions Copyright (c) 1994, Regents of the University of California
00024  *
00025  * src/include/catalog/pg_amproc.h
00026  *
00027  * NOTES
00028  *    the genbki.pl script reads this file and generates .bki
00029  *    information from the DATA() statements.
00030  *
00031  *-------------------------------------------------------------------------
00032  */
00033 #ifndef PG_AMPROC_H
00034 #define PG_AMPROC_H
00035 
00036 #include "catalog/genbki.h"
00037 
00038 /* ----------------
00039  *      pg_amproc definition.  cpp turns this into
00040  *      typedef struct FormData_pg_amproc
00041  * ----------------
00042  */
00043 #define AccessMethodProcedureRelationId  2603
00044 
00045 CATALOG(pg_amproc,2603)
00046 {
00047     Oid         amprocfamily;   /* the index opfamily this entry is for */
00048     Oid         amproclefttype; /* procedure's left input data type */
00049     Oid         amprocrighttype;    /* procedure's right input data type */
00050     int16       amprocnum;      /* support procedure index */
00051     regproc     amproc;         /* OID of the proc */
00052 } FormData_pg_amproc;
00053 
00054 /* ----------------
00055  *      Form_pg_amproc corresponds to a pointer to a tuple with
00056  *      the format of pg_amproc relation.
00057  * ----------------
00058  */
00059 typedef FormData_pg_amproc *Form_pg_amproc;
00060 
00061 /* ----------------
00062  *      compiler constants for pg_amproc
00063  * ----------------
00064  */
00065 #define Natts_pg_amproc                 5
00066 #define Anum_pg_amproc_amprocfamily     1
00067 #define Anum_pg_amproc_amproclefttype   2
00068 #define Anum_pg_amproc_amprocrighttype  3
00069 #define Anum_pg_amproc_amprocnum        4
00070 #define Anum_pg_amproc_amproc           5
00071 
00072 /* ----------------
00073  *      initial contents of pg_amproc
00074  * ----------------
00075  */
00076 
00077 /* btree */
00078 DATA(insert (   397   2277 2277 1 382 ));
00079 DATA(insert (   421   702 702 1 357 ));
00080 DATA(insert (   423   1560 1560 1 1596 ));
00081 DATA(insert (   424   16 16 1 1693 ));
00082 DATA(insert (   426   1042 1042 1 1078 ));
00083 DATA(insert (   428   17 17 1 1954 ));
00084 DATA(insert (   429   18 18 1 358 ));
00085 DATA(insert (   434   1082 1082 1 1092 ));
00086 DATA(insert (   434   1082 1082 2 3136 ));
00087 DATA(insert (   434   1082 1114 1 2344 ));
00088 DATA(insert (   434   1082 1184 1 2357 ));
00089 DATA(insert (   434   1114 1114 1 2045 ));
00090 DATA(insert (   434   1114 1114 2 3137 ));
00091 DATA(insert (   434   1114 1082 1 2370 ));
00092 DATA(insert (   434   1114 1184 1 2526 ));
00093 DATA(insert (   434   1184 1184 1 1314 ));
00094 DATA(insert (   434   1184 1184 2 3137 ));
00095 DATA(insert (   434   1184 1082 1 2383 ));
00096 DATA(insert (   434   1184 1114 1 2533 ));
00097 DATA(insert (   1970   700 700 1 354 ));
00098 DATA(insert (   1970   700 700 2 3132 ));
00099 DATA(insert (   1970   700 701 1 2194 ));
00100 DATA(insert (   1970   701 701 1 355 ));
00101 DATA(insert (   1970   701 701 2 3133 ));
00102 DATA(insert (   1970   701 700 1 2195 ));
00103 DATA(insert (   1974   869 869 1 926 ));
00104 DATA(insert (   1976   21 21 1 350 ));
00105 DATA(insert (   1976   21 21 2 3129 ));
00106 DATA(insert (   1976   21 23 1 2190 ));
00107 DATA(insert (   1976   21 20 1 2192 ));
00108 DATA(insert (   1976   23 23 1 351 ));
00109 DATA(insert (   1976   23 23 2 3130 ));
00110 DATA(insert (   1976   23 20 1 2188 ));
00111 DATA(insert (   1976   23 21 1 2191 ));
00112 DATA(insert (   1976   20 20 1 842 ));
00113 DATA(insert (   1976   20 20 2 3131 ));
00114 DATA(insert (   1976   20 23 1 2189 ));
00115 DATA(insert (   1976   20 21 1 2193 ));
00116 DATA(insert (   1982   1186 1186 1 1315 ));
00117 DATA(insert (   1984   829 829 1 836 ));
00118 DATA(insert (   1986   19 19 1 359 ));
00119 DATA(insert (   1986   19 19 2 3135 ));
00120 DATA(insert (   1988   1700 1700 1 1769 ));
00121 DATA(insert (   1989   26 26 1 356 ));
00122 DATA(insert (   1989   26 26 2 3134 ));
00123 DATA(insert (   1991   30 30 1 404 ));
00124 DATA(insert (   2994   2249 2249 1 2987 ));
00125 DATA(insert (   1994   25 25 1 360 ));
00126 DATA(insert (   1996   1083 1083 1 1107 ));
00127 DATA(insert (   2000   1266 1266 1 1358 ));
00128 DATA(insert (   2002   1562 1562 1 1672 ));
00129 DATA(insert (   2095   25 25 1 2166 ));
00130 DATA(insert (   2097   1042 1042 1 2180 ));
00131 DATA(insert (   2099   790 790 1  377 ));
00132 DATA(insert (   2233   703 703 1  380 ));
00133 DATA(insert (   2234   704 704 1  381 ));
00134 DATA(insert (   2789   27 27 1 2794 ));
00135 DATA(insert (   2968   2950 2950 1 2960 ));
00136 DATA(insert (   3522   3500 3500 1 3514 ));
00137 
00138 
00139 /* hash */
00140 DATA(insert (   427   1042 1042 1 1080 ));
00141 DATA(insert (   431   18 18 1 454 ));
00142 DATA(insert (   435   1082 1082 1 450 ));
00143 DATA(insert (   627   2277 2277 1 626 ));
00144 DATA(insert (   1971   700 700 1 451 ));
00145 DATA(insert (   1971   701 701 1 452 ));
00146 DATA(insert (   1975   869 869 1 422 ));
00147 DATA(insert (   1977   21 21 1 449 ));
00148 DATA(insert (   1977   23 23 1 450 ));
00149 DATA(insert (   1977   20 20 1 949 ));
00150 DATA(insert (   1983   1186 1186 1 1697 ));
00151 DATA(insert (   1985   829 829 1 399 ));
00152 DATA(insert (   1987   19 19 1 455 ));
00153 DATA(insert (   1990   26 26 1 453 ));
00154 DATA(insert (   1992   30 30 1 457 ));
00155 DATA(insert (   1995   25 25 1 400 ));
00156 DATA(insert (   1997   1083 1083 1 1688 ));
00157 DATA(insert (   1998   1700 1700 1 432 ));
00158 DATA(insert (   1999   1184 1184 1 2039 ));
00159 DATA(insert (   2001   1266 1266 1 1696 ));
00160 DATA(insert (   2040   1114 1114 1 2039 ));
00161 DATA(insert (   2222   16 16 1 454 ));
00162 DATA(insert (   2223   17 17 1 456 ));
00163 DATA(insert (   2224   22 22 1 398 ));
00164 DATA(insert (   2225   28 28 1 450 ));
00165 DATA(insert (   2226   29 29 1 450 ));
00166 DATA(insert (   2227   702 702 1 450 ));
00167 DATA(insert (   2228   703 703 1 450 ));
00168 DATA(insert (   2229   25 25 1 400 ));
00169 DATA(insert (   2231   1042 1042 1 1080 ));
00170 DATA(insert (   2235   1033 1033 1 329 ));
00171 DATA(insert (   2969   2950 2950 1 2963 ));
00172 DATA(insert (   3523   3500 3500 1 3515 ));
00173 
00174 
00175 /* gist */
00176 DATA(insert (   2593   603 603 1 2578 ));
00177 DATA(insert (   2593   603 603 2 2583 ));
00178 DATA(insert (   2593   603 603 3 2579 ));
00179 DATA(insert (   2593   603 603 4 2580 ));
00180 DATA(insert (   2593   603 603 5 2581 ));
00181 DATA(insert (   2593   603 603 6 2582 ));
00182 DATA(insert (   2593   603 603 7 2584 ));
00183 DATA(insert (   2594   604 604 1 2585 ));
00184 DATA(insert (   2594   604 604 2 2583 ));
00185 DATA(insert (   2594   604 604 3 2586 ));
00186 DATA(insert (   2594   604 604 4 2580 ));
00187 DATA(insert (   2594   604 604 5 2581 ));
00188 DATA(insert (   2594   604 604 6 2582 ));
00189 DATA(insert (   2594   604 604 7 2584 ));
00190 DATA(insert (   2595   718 718 1 2591 ));
00191 DATA(insert (   2595   718 718 2 2583 ));
00192 DATA(insert (   2595   718 718 3 2592 ));
00193 DATA(insert (   2595   718 718 4 2580 ));
00194 DATA(insert (   2595   718 718 5 2581 ));
00195 DATA(insert (   2595   718 718 6 2582 ));
00196 DATA(insert (   2595   718 718 7 2584 ));
00197 DATA(insert (   3655   3614 3614 1 3654 ));
00198 DATA(insert (   3655   3614 3614 2 3651 ));
00199 DATA(insert (   3655   3614 3614 3 3648 ));
00200 DATA(insert (   3655   3614 3614 4 3649 ));
00201 DATA(insert (   3655   3614 3614 5 3653 ));
00202 DATA(insert (   3655   3614 3614 6 3650 ));
00203 DATA(insert (   3655   3614 3614 7 3652 ));
00204 DATA(insert (   3702   3615 3615 1 3701 ));
00205 DATA(insert (   3702   3615 3615 2 3698 ));
00206 DATA(insert (   3702   3615 3615 3 3695 ));
00207 DATA(insert (   3702   3615 3615 4 3696 ));
00208 DATA(insert (   3702   3615 3615 5 3700 ));
00209 DATA(insert (   3702   3615 3615 6 3697 ));
00210 DATA(insert (   3702   3615 3615 7 3699 ));
00211 DATA(insert (   1029   600 600 1 2179 ));
00212 DATA(insert (   1029   600 600 2 2583 ));
00213 DATA(insert (   1029   600 600 3 1030 ));
00214 DATA(insert (   1029   600 600 4 2580 ));
00215 DATA(insert (   1029   600 600 5 2581 ));
00216 DATA(insert (   1029   600 600 6 2582 ));
00217 DATA(insert (   1029   600 600 7 2584 ));
00218 DATA(insert (   1029   600 600 8 3064 ));
00219 
00220 
00221 /* gin */
00222 DATA(insert (   2745   1007 1007 1  351 ));
00223 DATA(insert (   2745   1007 1007 2 2743 ));
00224 DATA(insert (   2745   1007 1007 3 2774 ));
00225 DATA(insert (   2745   1007 1007 4 2744 ));
00226 DATA(insert (   2745   1009 1009 1  360 ));
00227 DATA(insert (   2745   1009 1009 2 2743 ));
00228 DATA(insert (   2745   1009 1009 3 2774 ));
00229 DATA(insert (   2745   1009 1009 4 2744 ));
00230 DATA(insert (   2745   1015 1015 1  360 ));
00231 DATA(insert (   2745   1015 1015 2 2743 ));
00232 DATA(insert (   2745   1015 1015 3 2774 ));
00233 DATA(insert (   2745   1015 1015 4 2744 ));
00234 DATA(insert (   2745   1023 1023 1 357 ));
00235 DATA(insert (   2745   1023 1023 2 2743 ));
00236 DATA(insert (   2745   1023 1023 3 2774 ));
00237 DATA(insert (   2745   1023 1023 4 2744 ));
00238 DATA(insert (   2745   1561 1561 1 1596 ));
00239 DATA(insert (   2745   1561 1561 2 2743 ));
00240 DATA(insert (   2745   1561 1561 3 2774 ));
00241 DATA(insert (   2745   1561 1561 4 2744 ));
00242 DATA(insert (   2745   1000 1000 1 1693 ));
00243 DATA(insert (   2745   1000 1000 2 2743 ));
00244 DATA(insert (   2745   1000 1000 3 2774 ));
00245 DATA(insert (   2745   1000 1000 4 2744 ));
00246 DATA(insert (   2745   1014 1014 1 1078 ));
00247 DATA(insert (   2745   1014 1014 2 2743 ));
00248 DATA(insert (   2745   1014 1014 3 2774 ));
00249 DATA(insert (   2745   1014 1014 4 2744 ));
00250 DATA(insert (   2745   1001 1001 1 1954 ));
00251 DATA(insert (   2745   1001 1001 2 2743 ));
00252 DATA(insert (   2745   1001 1001 3 2774 ));
00253 DATA(insert (   2745   1001 1001 4 2744 ));
00254 DATA(insert (   2745   1002 1002 1 358 ));
00255 DATA(insert (   2745   1002 1002 2 2743 ));
00256 DATA(insert (   2745   1002 1002 3 2774 ));
00257 DATA(insert (   2745   1002 1002 4 2744 ));
00258 DATA(insert (   2745   1182 1182 1 1092 ));
00259 DATA(insert (   2745   1182 1182 2 2743 ));
00260 DATA(insert (   2745   1182 1182 3 2774 ));
00261 DATA(insert (   2745   1182 1182 4 2744 ));
00262 DATA(insert (   2745   1021 1021 1 354 ));
00263 DATA(insert (   2745   1021 1021 2 2743 ));
00264 DATA(insert (   2745   1021 1021 3 2774 ));
00265 DATA(insert (   2745   1021 1021 4 2744 ));
00266 DATA(insert (   2745   1022 1022 1 355 ));
00267 DATA(insert (   2745   1022 1022 2 2743 ));
00268 DATA(insert (   2745   1022 1022 3 2774 ));
00269 DATA(insert (   2745   1022 1022 4 2744 ));
00270 DATA(insert (   2745   1041 1041 1 926 ));
00271 DATA(insert (   2745   1041 1041 2 2743 ));
00272 DATA(insert (   2745   1041 1041 3 2774 ));
00273 DATA(insert (   2745   1041 1041 4 2744 ));
00274 DATA(insert (   2745   651 651 1 926 ));
00275 DATA(insert (   2745   651 651 2 2743 ));
00276 DATA(insert (   2745   651 651 3 2774 ));
00277 DATA(insert (   2745   651 651 4 2744 ));
00278 DATA(insert (   2745   1005 1005 1 350 ));
00279 DATA(insert (   2745   1005 1005 2 2743 ));
00280 DATA(insert (   2745   1005 1005 3 2774 ));
00281 DATA(insert (   2745   1005 1005 4 2744 ));
00282 DATA(insert (   2745   1016 1016 1 842 ));
00283 DATA(insert (   2745   1016 1016 2 2743 ));
00284 DATA(insert (   2745   1016 1016 3 2774 ));
00285 DATA(insert (   2745   1016 1016 4 2744 ));
00286 DATA(insert (   2745   1187 1187 1 1315 ));
00287 DATA(insert (   2745   1187 1187 2 2743 ));
00288 DATA(insert (   2745   1187 1187 3 2774 ));
00289 DATA(insert (   2745   1187 1187 4 2744 ));
00290 DATA(insert (   2745   1040 1040 1 836 ));
00291 DATA(insert (   2745   1040 1040 2 2743 ));
00292 DATA(insert (   2745   1040 1040 3 2774 ));
00293 DATA(insert (   2745   1040 1040 4 2744 ));
00294 DATA(insert (   2745   1003 1003 1 359 ));
00295 DATA(insert (   2745   1003 1003 2 2743 ));
00296 DATA(insert (   2745   1003 1003 3 2774 ));
00297 DATA(insert (   2745   1003 1003 4 2744 ));
00298 DATA(insert (   2745   1231 1231 1 1769 ));
00299 DATA(insert (   2745   1231 1231 2 2743 ));
00300 DATA(insert (   2745   1231 1231 3 2774 ));
00301 DATA(insert (   2745   1231 1231 4 2744 ));
00302 DATA(insert (   2745   1028 1028 1 356 ));
00303 DATA(insert (   2745   1028 1028 2 2743 ));
00304 DATA(insert (   2745   1028 1028 3 2774 ));
00305 DATA(insert (   2745   1028 1028 4 2744 ));
00306 DATA(insert (   2745   1013 1013 1 404 ));
00307 DATA(insert (   2745   1013 1013 2 2743 ));
00308 DATA(insert (   2745   1013 1013 3 2774 ));
00309 DATA(insert (   2745   1013 1013 4 2744 ));
00310 DATA(insert (   2745   1183 1183 1 1107 ));
00311 DATA(insert (   2745   1183 1183 2 2743 ));
00312 DATA(insert (   2745   1183 1183 3 2774 ));
00313 DATA(insert (   2745   1183 1183 4 2744 ));
00314 DATA(insert (   2745   1185 1185 1 1314 ));
00315 DATA(insert (   2745   1185 1185 2 2743 ));
00316 DATA(insert (   2745   1185 1185 3 2774 ));
00317 DATA(insert (   2745   1185 1185 4 2744 ));
00318 DATA(insert (   2745   1270 1270 1 1358 ));
00319 DATA(insert (   2745   1270 1270 2 2743 ));
00320 DATA(insert (   2745   1270 1270 3 2774 ));
00321 DATA(insert (   2745   1270 1270 4 2744 ));
00322 DATA(insert (   2745   1563 1563 1 1672 ));
00323 DATA(insert (   2745   1563 1563 2 2743 ));
00324 DATA(insert (   2745   1563 1563 3 2774 ));
00325 DATA(insert (   2745   1563 1563 4 2744 ));
00326 DATA(insert (   2745   1115 1115 1 2045 ));
00327 DATA(insert (   2745   1115 1115 2 2743 ));
00328 DATA(insert (   2745   1115 1115 3 2774 ));
00329 DATA(insert (   2745   1115 1115 4 2744 ));
00330 DATA(insert (   2745   791 791 1 377 ));
00331 DATA(insert (   2745   791 791 2 2743 ));
00332 DATA(insert (   2745   791 791 3 2774 ));
00333 DATA(insert (   2745   791 791 4 2744 ));
00334 DATA(insert (   2745   1024 1024 1 380 ));
00335 DATA(insert (   2745   1024 1024 2 2743 ));
00336 DATA(insert (   2745   1024 1024 3 2774 ));
00337 DATA(insert (   2745   1024 1024 4 2744 ));
00338 DATA(insert (   2745   1025 1025 1 381 ));
00339 DATA(insert (   2745   1025 1025 2 2743 ));
00340 DATA(insert (   2745   1025 1025 3 2774 ));
00341 DATA(insert (   2745   1025 1025 4 2744 ));
00342 DATA(insert (   3659   3614 3614 1 3724 ));
00343 DATA(insert (   3659   3614 3614 2 3656 ));
00344 DATA(insert (   3659   3614 3614 3 3657 ));
00345 DATA(insert (   3659   3614 3614 4 3658 ));
00346 DATA(insert (   3659   3614 3614 5 2700 ));
00347 DATA(insert (   3626   3614 3614 1 3622 ));
00348 DATA(insert (   3683   3615 3615 1 3668 ));
00349 DATA(insert (   3901   3831 3831 1 3870 ));
00350 DATA(insert (   3903   3831 3831 1 3902 ));
00351 DATA(insert (   3919   3831 3831 1 3875 ));
00352 DATA(insert (   3919   3831 3831 2 3876 ));
00353 DATA(insert (   3919   3831 3831 3 3877 ));
00354 DATA(insert (   3919   3831 3831 4 3878 ));
00355 DATA(insert (   3919   3831 3831 5 3879 ));
00356 DATA(insert (   3919   3831 3831 6 3880 ));
00357 DATA(insert (   3919   3831 3831 7 3881 ));
00358 
00359 
00360 /* sp-gist */
00361 DATA(insert (   4015   600 600 1 4018 ));
00362 DATA(insert (   4015   600 600 2 4019 ));
00363 DATA(insert (   4015   600 600 3 4020 ));
00364 DATA(insert (   4015   600 600 4 4021 ));
00365 DATA(insert (   4015   600 600 5 4022 ));
00366 DATA(insert (   4016   600 600 1 4023 ));
00367 DATA(insert (   4016   600 600 2 4024 ));
00368 DATA(insert (   4016   600 600 3 4025 ));
00369 DATA(insert (   4016   600 600 4 4026 ));
00370 DATA(insert (   4016   600 600 5 4022 ));
00371 DATA(insert (   4017   25 25 1 4027 ));
00372 DATA(insert (   4017   25 25 2 4028 ));
00373 DATA(insert (   4017   25 25 3 4029 ));
00374 DATA(insert (   4017   25 25 4 4030 ));
00375 DATA(insert (   4017   25 25 5 4031 ));
00376 DATA(insert (   3474   3831 3831 1 3469 ));
00377 DATA(insert (   3474   3831 3831 2 3470 ));
00378 DATA(insert (   3474   3831 3831 3 3471 ));
00379 DATA(insert (   3474   3831 3831 4 3472 ));
00380 DATA(insert (   3474   3831 3831 5 3473 ));
00381 
00382 #endif   /* PG_AMPROC_H */