src/include/catalog/pg_amproc.h

   1 /*-------------------------------------------------------------------------
   2  *
   3  * pg_amproc.h
   4  *        definition of the system "amproc" relation (pg_amproc)
   5  *        along with the relation's initial contents.
   6  *
   7  * The amproc table identifies support procedures associated with index
   8  * operator families and classes.  These procedures can't be listed in pg_amop
   9  * since they are not the implementation of any indexable operator.
  10  *
  11  * The primary key for this table is <amprocfamily, amproclefttype,
  12  * amprocrighttype, amprocnum>.  The "default" support functions for a
  13  * particular opclass within the family are those with amproclefttype =
  14  * amprocrighttype = opclass's opcintype.  These are the ones loaded into the
  15  * relcache for an index and typically used for internal index operations.
  16  * Other support functions are typically used to handle cross-type indexable
  17  * operators with oprleft/oprright matching the entry's amproclefttype and
  18  * amprocrighttype. The exact behavior depends on the index AM, however, and
  19  * some don't pay attention to non-default functions at all.
  20  *
  21  *
  22  * Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group
  23  * Portions Copyright (c) 1994, Regents of the University of California
  24  *
  25  * $PostgreSQL$
  26  *
  27  * NOTES
  28  *        the genbki.sh script reads this file and generates .bki
  29  *        information from the DATA() statements.
  30  *
  31  *-------------------------------------------------------------------------
  32  */
  33 #ifndef PG_AMPROC_H
  34 #define PG_AMPROC_H
  35
  36 #include "catalog/genbki.h"
  37
  38 /* ----------------
  39  *              pg_amproc definition.  cpp turns this into
  40  *              typedef struct FormData_pg_amproc
  41  * ----------------
  42  */
  43 #define AccessMethodProcedureRelationId  2603
  44
  45 CATALOG(pg_amproc,2603)
  46 {
  47         Oid                     amprocfamily;   /* the index opfamily this entry is for */
  48         Oid                     amproclefttype; /* procedure's left input data type */
  49         Oid                     amprocrighttype;        /* procedure's right input data type */
  50         int2            amprocnum;              /* support procedure index */
  51         regproc         amproc;                 /* OID of the proc */
  52 } FormData_pg_amproc;
  53
  54 /* ----------------
  55  *              Form_pg_amproc corresponds to a pointer to a tuple with
  56  *              the format of pg_amproc relation.
  57  * ----------------
  58  */
  59 typedef FormData_pg_amproc *Form_pg_amproc;
  60
  61 /* ----------------
  62  *              compiler constants for pg_amproc
  63  * ----------------
  64  */
  65 #define Natts_pg_amproc                                 5
  66 #define Anum_pg_amproc_amprocfamily             1
  67 #define Anum_pg_amproc_amproclefttype   2
  68 #define Anum_pg_amproc_amprocrighttype  3
  69 #define Anum_pg_amproc_amprocnum                4
  70 #define Anum_pg_amproc_amproc                   5
  71
  72 /* ----------------
  73  *              initial contents of pg_amproc
  74  * ----------------
  75  */
  76
  77 /* btree */
  78 DATA(insert (   397   2277 2277 1 382 ));
  79 DATA(insert (   421   702 702 1 357 ));
  80 DATA(insert (   423   1560 1560 1 1596 ));
  81 DATA(insert (   424   16 16 1 1693 ));
  82 DATA(insert (   426   1042 1042 1 1078 ));
  83 DATA(insert (   428   17 17 1 1954 ));
  84 DATA(insert (   429   18 18 1 358 ));
  85 DATA(insert (   434   1082 1082 1 1092 ));
  86 DATA(insert (   434   1082 1114 1 2344 ));
  87 DATA(insert (   434   1082 1184 1 2357 ));
  88 DATA(insert (   434   1114 1114 1 2045 ));
  89 DATA(insert (   434   1114 1082 1 2370 ));
  90 DATA(insert (   434   1114 1184 1 2526 ));
  91 DATA(insert (   434   1184 1184 1 1314 ));
  92 DATA(insert (   434   1184 1082 1 2383 ));
  93 DATA(insert (   434   1184 1114 1 2533 ));
  94 DATA(insert (   1970   700 700 1 354 ));
  95 DATA(insert (   1970   700 701 1 2194 ));
  96 DATA(insert (   1970   701 701 1 355 ));
  97 DATA(insert (   1970   701 700 1 2195 ));
  98 DATA(insert (   1974   869 869 1 926 ));
  99 DATA(insert (   1976   21 21 1 350 ));
 100 DATA(insert (   1976   21 23 1 2190 ));
 101 DATA(insert (   1976   21 20 1 2192 ));
 102 DATA(insert (   1976   23 23 1 351 ));
 103 DATA(insert (   1976   23 20 1 2188 ));
 104 DATA(insert (   1976   23 21 1 2191 ));
 105 DATA(insert (   1976   20 20 1 842 ));
 106 DATA(insert (   1976   20 23 1 2189 ));
 107 DATA(insert (   1976   20 21 1 2193 ));
 108 DATA(insert (   1982   1186 1186 1 1315 ));
 109 DATA(insert (   1984   829 829 1 836 ));
 110 DATA(insert (   1986   19 19 1 359 ));
 111 DATA(insert (   1988   1700 1700 1 1769 ));
 112 DATA(insert (   1989   26 26 1 356 ));
 113 DATA(insert (   1991   30 30 1 404 ));
 114 DATA(insert (   2994   2249 2249 1 2987 ));
 115 DATA(insert (   1994   25 25 1 360 ));
 116 DATA(insert (   1996   1083 1083 1 1107 ));
 117 DATA(insert (   2000   1266 1266 1 1358 ));
 118 DATA(insert (   2002   1562 1562 1 1672 ));
 119 DATA(insert (   2095   25 25 1 2166 ));
 120 DATA(insert (   2097   1042 1042 1 2180 ));
 121 DATA(insert (   2099   790 790 1  377 ));
 122 DATA(insert (   2233   703 703 1  380 ));
 123 DATA(insert (   2234   704 704 1  381 ));
 124 DATA(insert (   2789   27 27 1 2794 ));
 125 DATA(insert (   2968   2950 2950 1 2960 ));
 126 DATA(insert (   3522   3500 3500 1 3514 ));
 127
 128
 129 /* hash */
 130 DATA(insert (   427   1042 1042 1 1080 ));
 131 DATA(insert (   431   18 18 1 454 ));
 132 DATA(insert (   435   1082 1082 1 450 ));
 133 DATA(insert (   1971   700 700 1 451 ));
 134 DATA(insert (   1971   701 701 1 452 ));
 135 DATA(insert (   1975   869 869 1 422 ));
 136 DATA(insert (   1977   21 21 1 449 ));
 137 DATA(insert (   1977   23 23 1 450 ));
 138 DATA(insert (   1977   20 20 1 949 ));
 139 DATA(insert (   1983   1186 1186 1 1697 ));
 140 DATA(insert (   1985   829 829 1 399 ));
 141 DATA(insert (   1987   19 19 1 455 ));
 142 DATA(insert (   1990   26 26 1 453 ));
 143 DATA(insert (   1992   30 30 1 457 ));
 144 DATA(insert (   1995   25 25 1 400 ));
 145 DATA(insert (   1997   1083 1083 1 1688 ));
 146 DATA(insert (   1998   1700 1700 1 432 ));
 147 DATA(insert (   1999   1184 1184 1 2039 ));
 148 DATA(insert (   2001   1266 1266 1 1696 ));
 149 DATA(insert (   2040   1114 1114 1 2039 ));
 150 DATA(insert (   2222   16 16 1 454 ));
 151 DATA(insert (   2223   17 17 1 456 ));
 152 DATA(insert (   2224   22 22 1 398 ));
 153 DATA(insert (   2225   28 28 1 450 ));
 154 DATA(insert (   2226   29 29 1 450 ));
 155 DATA(insert (   2227   702 702 1 450 ));
 156 DATA(insert (   2228   703 703 1 450 ));
 157 DATA(insert (   2229   25 25 1 400 ));
 158 DATA(insert (   2231   1042 1042 1 1080 ));
 159 DATA(insert (   2235   1033 1033 1 329 ));
 160 DATA(insert (   2969   2950 2950 1 2963 ));
 161 DATA(insert (   3523   3500 3500 1 3515 ));
 162
 163
 164 /* gist */
 165 DATA(insert (   2593   603 603 1 2578 ));
 166 DATA(insert (   2593   603 603 2 2583 ));
 167 DATA(insert (   2593   603 603 3 2579 ));
 168 DATA(insert (   2593   603 603 4 2580 ));
 169 DATA(insert (   2593   603 603 5 2581 ));
 170 DATA(insert (   2593   603 603 6 2582 ));
 171 DATA(insert (   2593   603 603 7 2584 ));
 172 DATA(insert (   2594   604 604 1 2585 ));
 173 DATA(insert (   2594   604 604 2 2583 ));
 174 DATA(insert (   2594   604 604 3 2586 ));
 175 DATA(insert (   2594   604 604 4 2580 ));
 176 DATA(insert (   2594   604 604 5 2581 ));
 177 DATA(insert (   2594   604 604 6 2582 ));
 178 DATA(insert (   2594   604 604 7 2584 ));
 179 DATA(insert (   2595   718 718 1 2591 ));
 180 DATA(insert (   2595   718 718 2 2583 ));
 181 DATA(insert (   2595   718 718 3 2592 ));
 182 DATA(insert (   2595   718 718 4 2580 ));
 183 DATA(insert (   2595   718 718 5 2581 ));
 184 DATA(insert (   2595   718 718 6 2582 ));
 185 DATA(insert (   2595   718 718 7 2584 ));
 186 DATA(insert (   3655   3614 3614 1 3654 ));
 187 DATA(insert (   3655   3614 3614 2 3651 ));
 188 DATA(insert (   3655   3614 3614 3 3648 ));
 189 DATA(insert (   3655   3614 3614 4 3649 ));
 190 DATA(insert (   3655   3614 3614 5 3653 ));
 191 DATA(insert (   3655   3614 3614 6 3650 ));
 192 DATA(insert (   3655   3614 3614 7 3652 ));
 193 DATA(insert (   3702   3615 3615 1 3701 ));
 194 DATA(insert (   3702   3615 3615 2 3698 ));
 195 DATA(insert (   3702   3615 3615 3 3695 ));
 196 DATA(insert (   3702   3615 3615 4 3696 ));
 197 DATA(insert (   3702   3615 3615 5 3700 ));
 198 DATA(insert (   3702   3615 3615 6 3697 ));
 199 DATA(insert (   3702   3615 3615 7 3699 ));
 200
 201
 202 /* gin */
 203 DATA(insert (   2745   1007 1007 1      351 ));
 204 DATA(insert (   2745   1007 1007 2 2743 ));
 205 DATA(insert (   2745   1007 1007 3 2774 ));
 206 DATA(insert (   2745   1007 1007 4 2744 ));
 207 DATA(insert (   2745   1009 1009 1      360 ));
 208 DATA(insert (   2745   1009 1009 2 2743 ));
 209 DATA(insert (   2745   1009 1009 3 2774 ));
 210 DATA(insert (   2745   1009 1009 4 2744 ));
 211 DATA(insert (   2745   1015 1015 1      360 ));
 212 DATA(insert (   2745   1015 1015 2 2743 ));
 213 DATA(insert (   2745   1015 1015 3 2774 ));
 214 DATA(insert (   2745   1015 1015 4 2744 ));
 215 DATA(insert (   2745   1023 1023 1 357 ));
 216 DATA(insert (   2745   1023 1023 2 2743 ));
 217 DATA(insert (   2745   1023 1023 3 2774 ));
 218 DATA(insert (   2745   1023 1023 4 2744 ));
 219 DATA(insert (   2745   1561 1561 1 1596 ));
 220 DATA(insert (   2745   1561 1561 2 2743 ));
 221 DATA(insert (   2745   1561 1561 3 2774 ));
 222 DATA(insert (   2745   1561 1561 4 2744 ));
 223 DATA(insert (   2745   1000 1000 1 1693 ));
 224 DATA(insert (   2745   1000 1000 2 2743 ));
 225 DATA(insert (   2745   1000 1000 3 2774 ));
 226 DATA(insert (   2745   1000 1000 4 2744 ));
 227 DATA(insert (   2745   1014 1014 1 1078 ));
 228 DATA(insert (   2745   1014 1014 2 2743 ));
 229 DATA(insert (   2745   1014 1014 3 2774 ));
 230 DATA(insert (   2745   1014 1014 4 2744 ));
 231 DATA(insert (   2745   1001 1001 1 1954 ));
 232 DATA(insert (   2745   1001 1001 2 2743 ));
 233 DATA(insert (   2745   1001 1001 3 2774 ));
 234 DATA(insert (   2745   1001 1001 4 2744 ));
 235 DATA(insert (   2745   1002 1002 1 358 ));
 236 DATA(insert (   2745   1002 1002 2 2743 ));
 237 DATA(insert (   2745   1002 1002 3 2774 ));
 238 DATA(insert (   2745   1002 1002 4 2744 ));
 239 DATA(insert (   2745   1182 1182 1 1092 ));
 240 DATA(insert (   2745   1182 1182 2 2743 ));
 241 DATA(insert (   2745   1182 1182 3 2774 ));
 242 DATA(insert (   2745   1182 1182 4 2744 ));
 243 DATA(insert (   2745   1021 1021 1 354 ));
 244 DATA(insert (   2745   1021 1021 2 2743 ));
 245 DATA(insert (   2745   1021 1021 3 2774 ));
 246 DATA(insert (   2745   1021 1021 4 2744 ));
 247 DATA(insert (   2745   1022 1022 1 355 ));
 248 DATA(insert (   2745   1022 1022 2 2743 ));
 249 DATA(insert (   2745   1022 1022 3 2774 ));
 250 DATA(insert (   2745   1022 1022 4 2744 ));
 251 DATA(insert (   2745   1041 1041 1 926 ));
 252 DATA(insert (   2745   1041 1041 2 2743 ));
 253 DATA(insert (   2745   1041 1041 3 2774 ));
 254 DATA(insert (   2745   1041 1041 4 2744 ));
 255 DATA(insert (   2745   651 651 1 926 ));
 256 DATA(insert (   2745   651 651 2 2743 ));
 257 DATA(insert (   2745   651 651 3 2774 ));
 258 DATA(insert (   2745   651 651 4 2744 ));
 259 DATA(insert (   2745   1005 1005 1 350 ));
 260 DATA(insert (   2745   1005 1005 2 2743 ));
 261 DATA(insert (   2745   1005 1005 3 2774 ));
 262 DATA(insert (   2745   1005 1005 4 2744 ));
 263 DATA(insert (   2745   1016 1016 1 842 ));
 264 DATA(insert (   2745   1016 1016 2 2743 ));
 265 DATA(insert (   2745   1016 1016 3 2774 ));
 266 DATA(insert (   2745   1016 1016 4 2744 ));
 267 DATA(insert (   2745   1187 1187 1 1315 ));
 268 DATA(insert (   2745   1187 1187 2 2743 ));
 269 DATA(insert (   2745   1187 1187 3 2774 ));
 270 DATA(insert (   2745   1187 1187 4 2744 ));
 271 DATA(insert (   2745   1040 1040 1 836 ));
 272 DATA(insert (   2745   1040 1040 2 2743 ));
 273 DATA(insert (   2745   1040 1040 3 2774 ));
 274 DATA(insert (   2745   1040 1040 4 2744 ));
 275 DATA(insert (   2745   1003 1003 1 359 ));
 276 DATA(insert (   2745   1003 1003 2 2743 ));
 277 DATA(insert (   2745   1003 1003 3 2774 ));
 278 DATA(insert (   2745   1003 1003 4 2744 ));
 279 DATA(insert (   2745   1231 1231 1 1769 ));
 280 DATA(insert (   2745   1231 1231 2 2743 ));
 281 DATA(insert (   2745   1231 1231 3 2774 ));
 282 DATA(insert (   2745   1231 1231 4 2744 ));
 283 DATA(insert (   2745   1028 1028 1 356 ));
 284 DATA(insert (   2745   1028 1028 2 2743 ));
 285 DATA(insert (   2745   1028 1028 3 2774 ));
 286 DATA(insert (   2745   1028 1028 4 2744 ));
 287 DATA(insert (   2745   1013 1013 1 404 ));
 288 DATA(insert (   2745   1013 1013 2 2743 ));
 289 DATA(insert (   2745   1013 1013 3 2774 ));
 290 DATA(insert (   2745   1013 1013 4 2744 ));
 291 DATA(insert (   2745   1183 1183 1 1107 ));
 292 DATA(insert (   2745   1183 1183 2 2743 ));
 293 DATA(insert (   2745   1183 1183 3 2774 ));
 294 DATA(insert (   2745   1183 1183 4 2744 ));
 295 DATA(insert (   2745   1185 1185 1 1314 ));
 296 DATA(insert (   2745   1185 1185 2 2743 ));
 297 DATA(insert (   2745   1185 1185 3 2774 ));
 298 DATA(insert (   2745   1185 1185 4 2744 ));
 299 DATA(insert (   2745   1270 1270 1 1358 ));
 300 DATA(insert (   2745   1270 1270 2 2743 ));
 301 DATA(insert (   2745   1270 1270 3 2774 ));
 302 DATA(insert (   2745   1270 1270 4 2744 ));
 303 DATA(insert (   2745   1563 1563 1 1672 ));
 304 DATA(insert (   2745   1563 1563 2 2743 ));
 305 DATA(insert (   2745   1563 1563 3 2774 ));
 306 DATA(insert (   2745   1563 1563 4 2744 ));
 307 DATA(insert (   2745   1115 1115 1 2045 ));
 308 DATA(insert (   2745   1115 1115 2 2743 ));
 309 DATA(insert (   2745   1115 1115 3 2774 ));
 310 DATA(insert (   2745   1115 1115 4 2744 ));
 311 DATA(insert (   2745   791 791 1 377 ));
 312 DATA(insert (   2745   791 791 2 2743 ));
 313 DATA(insert (   2745   791 791 3 2774 ));
 314 DATA(insert (   2745   791 791 4 2744 ));
 315 DATA(insert (   2745   1024 1024 1 380 ));
 316 DATA(insert (   2745   1024 1024 2 2743 ));
 317 DATA(insert (   2745   1024 1024 3 2774 ));
 318 DATA(insert (   2745   1024 1024 4 2744 ));
 319 DATA(insert (   2745   1025 1025 1 381 ));
 320 DATA(insert (   2745   1025 1025 2 2743 ));
 321 DATA(insert (   2745   1025 1025 3 2774 ));
 322 DATA(insert (   2745   1025 1025 4 2744 ));
 323 DATA(insert (   3659   3614 3614 1 3724 ));
 324 DATA(insert (   3659   3614 3614 2 3656 ));
 325 DATA(insert (   3659   3614 3614 3 3657 ));
 326 DATA(insert (   3659   3614 3614 4 3658 ));
 327 DATA(insert (   3659   3614 3614 5 2700 ));
 328 DATA(insert (   3626   3614 3614 1 3622 ));
 329 DATA(insert (   3683   3615 3615 1 3668 ));
 330
 331 #endif   /* PG_AMPROC_H */