pg_amop.h 41 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135
  1. /*-------------------------------------------------------------------------
  2. *
  3. * pg_amop.h
  4. * definition of the system "amop" relation (pg_amop)
  5. * along with the relation's initial contents.
  6. *
  7. * The amop table identifies the operators associated with each index operator
  8. * family and operator class (classes are subsets of families). An associated
  9. * operator can be either a search operator or an ordering operator, as
  10. * identified by amoppurpose.
  11. *
  12. * The primary key for this table is <amopfamily, amoplefttype, amoprighttype,
  13. * amopstrategy>. amoplefttype and amoprighttype are just copies of the
  14. * operator's oprleft/oprright, ie its declared input data types. The
  15. * "default" operators for a particular opclass within the family are those
  16. * with amoplefttype = amoprighttype = opclass's opcintype. An opfamily may
  17. * also contain other operators, typically cross-data-type operators. All the
  18. * operators within a family are supposed to be compatible, in a way that is
  19. * defined by each individual index AM.
  20. *
  21. * We also keep a unique index on <amopopr, amoppurpose, amopfamily>, so that
  22. * we can use a syscache to quickly answer questions of the form "is this
  23. * operator in this opfamily, and if so what are its semantics with respect to
  24. * the family?" This implies that the same operator cannot be listed for
  25. * multiple strategy numbers within a single opfamily, with the exception that
  26. * it's possible to list it for both search and ordering purposes (with
  27. * different strategy numbers for the two purposes).
  28. *
  29. * amopmethod is a copy of the owning opfamily's opfmethod field. This is an
  30. * intentional denormalization of the catalogs to buy lookup speed.
  31. *
  32. *
  33. * Portions Copyright (c) 1996-2016, PostgreSQL Global Development Group
  34. * Portions Copyright (c) 1994, Regents of the University of California
  35. *
  36. * src/include/catalog/pg_amop.h
  37. *
  38. * NOTES
  39. * the genbki.pl script reads this file and generates .bki
  40. * information from the DATA() statements.
  41. *
  42. *-------------------------------------------------------------------------
  43. */
  44. #ifndef PG_AMOP_H
  45. #define PG_AMOP_H
  46. #include "catalog/genbki.h"
  47. /* ----------------
  48. * pg_amop definition. cpp turns this into
  49. * typedef struct FormData_pg_amop
  50. * ----------------
  51. */
  52. #define AccessMethodOperatorRelationId 2602
  53. CATALOG(pg_amop,2602)
  54. {
  55. Oid amopfamily; /* the index opfamily this entry is for */
  56. Oid amoplefttype; /* operator's left input data type */
  57. Oid amoprighttype; /* operator's right input data type */
  58. int16 amopstrategy; /* operator strategy number */
  59. char amoppurpose; /* is operator for 's'earch or 'o'rdering? */
  60. Oid amopopr; /* the operator's pg_operator OID */
  61. Oid amopmethod; /* the index access method this entry is for */
  62. Oid amopsortfamily; /* ordering opfamily OID, or 0 if search op */
  63. } FormData_pg_amop;
  64. /* allowed values of amoppurpose: */
  65. #define AMOP_SEARCH 's' /* operator is for search */
  66. #define AMOP_ORDER 'o' /* operator is for ordering */
  67. /* ----------------
  68. * Form_pg_amop corresponds to a pointer to a tuple with
  69. * the format of pg_amop relation.
  70. * ----------------
  71. */
  72. typedef FormData_pg_amop *Form_pg_amop;
  73. /* ----------------
  74. * compiler constants for pg_amop
  75. * ----------------
  76. */
  77. #define Natts_pg_amop 8
  78. #define Anum_pg_amop_amopfamily 1
  79. #define Anum_pg_amop_amoplefttype 2
  80. #define Anum_pg_amop_amoprighttype 3
  81. #define Anum_pg_amop_amopstrategy 4
  82. #define Anum_pg_amop_amoppurpose 5
  83. #define Anum_pg_amop_amopopr 6
  84. #define Anum_pg_amop_amopmethod 7
  85. #define Anum_pg_amop_amopsortfamily 8
  86. /* ----------------
  87. * initial contents of pg_amop
  88. * ----------------
  89. */
  90. /*
  91. * btree integer_ops
  92. */
  93. /* default operators int2 */
  94. DATA(insert ( 1976 21 21 1 s 95 403 0 ));
  95. DATA(insert ( 1976 21 21 2 s 522 403 0 ));
  96. DATA(insert ( 1976 21 21 3 s 94 403 0 ));
  97. DATA(insert ( 1976 21 21 4 s 524 403 0 ));
  98. DATA(insert ( 1976 21 21 5 s 520 403 0 ));
  99. /* crosstype operators int24 */
  100. DATA(insert ( 1976 21 23 1 s 534 403 0 ));
  101. DATA(insert ( 1976 21 23 2 s 540 403 0 ));
  102. DATA(insert ( 1976 21 23 3 s 532 403 0 ));
  103. DATA(insert ( 1976 21 23 4 s 542 403 0 ));
  104. DATA(insert ( 1976 21 23 5 s 536 403 0 ));
  105. /* crosstype operators int28 */
  106. DATA(insert ( 1976 21 20 1 s 1864 403 0 ));
  107. DATA(insert ( 1976 21 20 2 s 1866 403 0 ));
  108. DATA(insert ( 1976 21 20 3 s 1862 403 0 ));
  109. DATA(insert ( 1976 21 20 4 s 1867 403 0 ));
  110. DATA(insert ( 1976 21 20 5 s 1865 403 0 ));
  111. /* default operators int4 */
  112. DATA(insert ( 1976 23 23 1 s 97 403 0 ));
  113. DATA(insert ( 1976 23 23 2 s 523 403 0 ));
  114. DATA(insert ( 1976 23 23 3 s 96 403 0 ));
  115. DATA(insert ( 1976 23 23 4 s 525 403 0 ));
  116. DATA(insert ( 1976 23 23 5 s 521 403 0 ));
  117. /* crosstype operators int42 */
  118. DATA(insert ( 1976 23 21 1 s 535 403 0 ));
  119. DATA(insert ( 1976 23 21 2 s 541 403 0 ));
  120. DATA(insert ( 1976 23 21 3 s 533 403 0 ));
  121. DATA(insert ( 1976 23 21 4 s 543 403 0 ));
  122. DATA(insert ( 1976 23 21 5 s 537 403 0 ));
  123. /* crosstype operators int48 */
  124. DATA(insert ( 1976 23 20 1 s 37 403 0 ));
  125. DATA(insert ( 1976 23 20 2 s 80 403 0 ));
  126. DATA(insert ( 1976 23 20 3 s 15 403 0 ));
  127. DATA(insert ( 1976 23 20 4 s 82 403 0 ));
  128. DATA(insert ( 1976 23 20 5 s 76 403 0 ));
  129. /* default operators int8 */
  130. DATA(insert ( 1976 20 20 1 s 412 403 0 ));
  131. DATA(insert ( 1976 20 20 2 s 414 403 0 ));
  132. DATA(insert ( 1976 20 20 3 s 410 403 0 ));
  133. DATA(insert ( 1976 20 20 4 s 415 403 0 ));
  134. DATA(insert ( 1976 20 20 5 s 413 403 0 ));
  135. /* crosstype operators int82 */
  136. DATA(insert ( 1976 20 21 1 s 1870 403 0 ));
  137. DATA(insert ( 1976 20 21 2 s 1872 403 0 ));
  138. DATA(insert ( 1976 20 21 3 s 1868 403 0 ));
  139. DATA(insert ( 1976 20 21 4 s 1873 403 0 ));
  140. DATA(insert ( 1976 20 21 5 s 1871 403 0 ));
  141. /* crosstype operators int84 */
  142. DATA(insert ( 1976 20 23 1 s 418 403 0 ));
  143. DATA(insert ( 1976 20 23 2 s 420 403 0 ));
  144. DATA(insert ( 1976 20 23 3 s 416 403 0 ));
  145. DATA(insert ( 1976 20 23 4 s 430 403 0 ));
  146. DATA(insert ( 1976 20 23 5 s 419 403 0 ));
  147. /*
  148. * btree oid_ops
  149. */
  150. DATA(insert ( 1989 26 26 1 s 609 403 0 ));
  151. DATA(insert ( 1989 26 26 2 s 611 403 0 ));
  152. DATA(insert ( 1989 26 26 3 s 607 403 0 ));
  153. DATA(insert ( 1989 26 26 4 s 612 403 0 ));
  154. DATA(insert ( 1989 26 26 5 s 610 403 0 ));
  155. /*
  156. * btree tid_ops
  157. */
  158. DATA(insert ( 2789 27 27 1 s 2799 403 0 ));
  159. DATA(insert ( 2789 27 27 2 s 2801 403 0 ));
  160. DATA(insert ( 2789 27 27 3 s 387 403 0 ));
  161. DATA(insert ( 2789 27 27 4 s 2802 403 0 ));
  162. DATA(insert ( 2789 27 27 5 s 2800 403 0 ));
  163. /*
  164. * btree oidvector_ops
  165. */
  166. DATA(insert ( 1991 30 30 1 s 645 403 0 ));
  167. DATA(insert ( 1991 30 30 2 s 647 403 0 ));
  168. DATA(insert ( 1991 30 30 3 s 649 403 0 ));
  169. DATA(insert ( 1991 30 30 4 s 648 403 0 ));
  170. DATA(insert ( 1991 30 30 5 s 646 403 0 ));
  171. /*
  172. * btree float_ops
  173. */
  174. /* default operators float4 */
  175. DATA(insert ( 1970 700 700 1 s 622 403 0 ));
  176. DATA(insert ( 1970 700 700 2 s 624 403 0 ));
  177. DATA(insert ( 1970 700 700 3 s 620 403 0 ));
  178. DATA(insert ( 1970 700 700 4 s 625 403 0 ));
  179. DATA(insert ( 1970 700 700 5 s 623 403 0 ));
  180. /* crosstype operators float48 */
  181. DATA(insert ( 1970 700 701 1 s 1122 403 0 ));
  182. DATA(insert ( 1970 700 701 2 s 1124 403 0 ));
  183. DATA(insert ( 1970 700 701 3 s 1120 403 0 ));
  184. DATA(insert ( 1970 700 701 4 s 1125 403 0 ));
  185. DATA(insert ( 1970 700 701 5 s 1123 403 0 ));
  186. /* default operators float8 */
  187. DATA(insert ( 1970 701 701 1 s 672 403 0 ));
  188. DATA(insert ( 1970 701 701 2 s 673 403 0 ));
  189. DATA(insert ( 1970 701 701 3 s 670 403 0 ));
  190. DATA(insert ( 1970 701 701 4 s 675 403 0 ));
  191. DATA(insert ( 1970 701 701 5 s 674 403 0 ));
  192. /* crosstype operators float84 */
  193. DATA(insert ( 1970 701 700 1 s 1132 403 0 ));
  194. DATA(insert ( 1970 701 700 2 s 1134 403 0 ));
  195. DATA(insert ( 1970 701 700 3 s 1130 403 0 ));
  196. DATA(insert ( 1970 701 700 4 s 1135 403 0 ));
  197. DATA(insert ( 1970 701 700 5 s 1133 403 0 ));
  198. /*
  199. * btree char_ops
  200. */
  201. DATA(insert ( 429 18 18 1 s 631 403 0 ));
  202. DATA(insert ( 429 18 18 2 s 632 403 0 ));
  203. DATA(insert ( 429 18 18 3 s 92 403 0 ));
  204. DATA(insert ( 429 18 18 4 s 634 403 0 ));
  205. DATA(insert ( 429 18 18 5 s 633 403 0 ));
  206. /*
  207. * btree name_ops
  208. */
  209. DATA(insert ( 1986 19 19 1 s 660 403 0 ));
  210. DATA(insert ( 1986 19 19 2 s 661 403 0 ));
  211. DATA(insert ( 1986 19 19 3 s 93 403 0 ));
  212. DATA(insert ( 1986 19 19 4 s 663 403 0 ));
  213. DATA(insert ( 1986 19 19 5 s 662 403 0 ));
  214. /*
  215. * btree text_ops
  216. */
  217. DATA(insert ( 1994 25 25 1 s 664 403 0 ));
  218. DATA(insert ( 1994 25 25 2 s 665 403 0 ));
  219. DATA(insert ( 1994 25 25 3 s 98 403 0 ));
  220. DATA(insert ( 1994 25 25 4 s 667 403 0 ));
  221. DATA(insert ( 1994 25 25 5 s 666 403 0 ));
  222. /*
  223. * btree bpchar_ops
  224. */
  225. DATA(insert ( 426 1042 1042 1 s 1058 403 0 ));
  226. DATA(insert ( 426 1042 1042 2 s 1059 403 0 ));
  227. DATA(insert ( 426 1042 1042 3 s 1054 403 0 ));
  228. DATA(insert ( 426 1042 1042 4 s 1061 403 0 ));
  229. DATA(insert ( 426 1042 1042 5 s 1060 403 0 ));
  230. /*
  231. * btree bytea_ops
  232. */
  233. DATA(insert ( 428 17 17 1 s 1957 403 0 ));
  234. DATA(insert ( 428 17 17 2 s 1958 403 0 ));
  235. DATA(insert ( 428 17 17 3 s 1955 403 0 ));
  236. DATA(insert ( 428 17 17 4 s 1960 403 0 ));
  237. DATA(insert ( 428 17 17 5 s 1959 403 0 ));
  238. /*
  239. * btree abstime_ops
  240. */
  241. DATA(insert ( 421 702 702 1 s 562 403 0 ));
  242. DATA(insert ( 421 702 702 2 s 564 403 0 ));
  243. DATA(insert ( 421 702 702 3 s 560 403 0 ));
  244. DATA(insert ( 421 702 702 4 s 565 403 0 ));
  245. DATA(insert ( 421 702 702 5 s 563 403 0 ));
  246. /*
  247. * btree datetime_ops
  248. */
  249. /* default operators date */
  250. DATA(insert ( 434 1082 1082 1 s 1095 403 0 ));
  251. DATA(insert ( 434 1082 1082 2 s 1096 403 0 ));
  252. DATA(insert ( 434 1082 1082 3 s 1093 403 0 ));
  253. DATA(insert ( 434 1082 1082 4 s 1098 403 0 ));
  254. DATA(insert ( 434 1082 1082 5 s 1097 403 0 ));
  255. /* crosstype operators vs timestamp */
  256. DATA(insert ( 434 1082 1114 1 s 2345 403 0 ));
  257. DATA(insert ( 434 1082 1114 2 s 2346 403 0 ));
  258. DATA(insert ( 434 1082 1114 3 s 2347 403 0 ));
  259. DATA(insert ( 434 1082 1114 4 s 2348 403 0 ));
  260. DATA(insert ( 434 1082 1114 5 s 2349 403 0 ));
  261. /* crosstype operators vs timestamptz */
  262. DATA(insert ( 434 1082 1184 1 s 2358 403 0 ));
  263. DATA(insert ( 434 1082 1184 2 s 2359 403 0 ));
  264. DATA(insert ( 434 1082 1184 3 s 2360 403 0 ));
  265. DATA(insert ( 434 1082 1184 4 s 2361 403 0 ));
  266. DATA(insert ( 434 1082 1184 5 s 2362 403 0 ));
  267. /* default operators timestamp */
  268. DATA(insert ( 434 1114 1114 1 s 2062 403 0 ));
  269. DATA(insert ( 434 1114 1114 2 s 2063 403 0 ));
  270. DATA(insert ( 434 1114 1114 3 s 2060 403 0 ));
  271. DATA(insert ( 434 1114 1114 4 s 2065 403 0 ));
  272. DATA(insert ( 434 1114 1114 5 s 2064 403 0 ));
  273. /* crosstype operators vs date */
  274. DATA(insert ( 434 1114 1082 1 s 2371 403 0 ));
  275. DATA(insert ( 434 1114 1082 2 s 2372 403 0 ));
  276. DATA(insert ( 434 1114 1082 3 s 2373 403 0 ));
  277. DATA(insert ( 434 1114 1082 4 s 2374 403 0 ));
  278. DATA(insert ( 434 1114 1082 5 s 2375 403 0 ));
  279. /* crosstype operators vs timestamptz */
  280. DATA(insert ( 434 1114 1184 1 s 2534 403 0 ));
  281. DATA(insert ( 434 1114 1184 2 s 2535 403 0 ));
  282. DATA(insert ( 434 1114 1184 3 s 2536 403 0 ));
  283. DATA(insert ( 434 1114 1184 4 s 2537 403 0 ));
  284. DATA(insert ( 434 1114 1184 5 s 2538 403 0 ));
  285. /* default operators timestamptz */
  286. DATA(insert ( 434 1184 1184 1 s 1322 403 0 ));
  287. DATA(insert ( 434 1184 1184 2 s 1323 403 0 ));
  288. DATA(insert ( 434 1184 1184 3 s 1320 403 0 ));
  289. DATA(insert ( 434 1184 1184 4 s 1325 403 0 ));
  290. DATA(insert ( 434 1184 1184 5 s 1324 403 0 ));
  291. /* crosstype operators vs date */
  292. DATA(insert ( 434 1184 1082 1 s 2384 403 0 ));
  293. DATA(insert ( 434 1184 1082 2 s 2385 403 0 ));
  294. DATA(insert ( 434 1184 1082 3 s 2386 403 0 ));
  295. DATA(insert ( 434 1184 1082 4 s 2387 403 0 ));
  296. DATA(insert ( 434 1184 1082 5 s 2388 403 0 ));
  297. /* crosstype operators vs timestamp */
  298. DATA(insert ( 434 1184 1114 1 s 2540 403 0 ));
  299. DATA(insert ( 434 1184 1114 2 s 2541 403 0 ));
  300. DATA(insert ( 434 1184 1114 3 s 2542 403 0 ));
  301. DATA(insert ( 434 1184 1114 4 s 2543 403 0 ));
  302. DATA(insert ( 434 1184 1114 5 s 2544 403 0 ));
  303. /*
  304. * btree time_ops
  305. */
  306. DATA(insert ( 1996 1083 1083 1 s 1110 403 0 ));
  307. DATA(insert ( 1996 1083 1083 2 s 1111 403 0 ));
  308. DATA(insert ( 1996 1083 1083 3 s 1108 403 0 ));
  309. DATA(insert ( 1996 1083 1083 4 s 1113 403 0 ));
  310. DATA(insert ( 1996 1083 1083 5 s 1112 403 0 ));
  311. /*
  312. * btree timetz_ops
  313. */
  314. DATA(insert ( 2000 1266 1266 1 s 1552 403 0 ));
  315. DATA(insert ( 2000 1266 1266 2 s 1553 403 0 ));
  316. DATA(insert ( 2000 1266 1266 3 s 1550 403 0 ));
  317. DATA(insert ( 2000 1266 1266 4 s 1555 403 0 ));
  318. DATA(insert ( 2000 1266 1266 5 s 1554 403 0 ));
  319. /*
  320. * btree interval_ops
  321. */
  322. DATA(insert ( 1982 1186 1186 1 s 1332 403 0 ));
  323. DATA(insert ( 1982 1186 1186 2 s 1333 403 0 ));
  324. DATA(insert ( 1982 1186 1186 3 s 1330 403 0 ));
  325. DATA(insert ( 1982 1186 1186 4 s 1335 403 0 ));
  326. DATA(insert ( 1982 1186 1186 5 s 1334 403 0 ));
  327. /*
  328. * btree macaddr
  329. */
  330. DATA(insert ( 1984 829 829 1 s 1222 403 0 ));
  331. DATA(insert ( 1984 829 829 2 s 1223 403 0 ));
  332. DATA(insert ( 1984 829 829 3 s 1220 403 0 ));
  333. DATA(insert ( 1984 829 829 4 s 1225 403 0 ));
  334. DATA(insert ( 1984 829 829 5 s 1224 403 0 ));
  335. /*
  336. * btree network
  337. */
  338. DATA(insert ( 1974 869 869 1 s 1203 403 0 ));
  339. DATA(insert ( 1974 869 869 2 s 1204 403 0 ));
  340. DATA(insert ( 1974 869 869 3 s 1201 403 0 ));
  341. DATA(insert ( 1974 869 869 4 s 1206 403 0 ));
  342. DATA(insert ( 1974 869 869 5 s 1205 403 0 ));
  343. /*
  344. * btree numeric
  345. */
  346. DATA(insert ( 1988 1700 1700 1 s 1754 403 0 ));
  347. DATA(insert ( 1988 1700 1700 2 s 1755 403 0 ));
  348. DATA(insert ( 1988 1700 1700 3 s 1752 403 0 ));
  349. DATA(insert ( 1988 1700 1700 4 s 1757 403 0 ));
  350. DATA(insert ( 1988 1700 1700 5 s 1756 403 0 ));
  351. /*
  352. * btree bool
  353. */
  354. DATA(insert ( 424 16 16 1 s 58 403 0 ));
  355. DATA(insert ( 424 16 16 2 s 1694 403 0 ));
  356. DATA(insert ( 424 16 16 3 s 91 403 0 ));
  357. DATA(insert ( 424 16 16 4 s 1695 403 0 ));
  358. DATA(insert ( 424 16 16 5 s 59 403 0 ));
  359. /*
  360. * btree bit
  361. */
  362. DATA(insert ( 423 1560 1560 1 s 1786 403 0 ));
  363. DATA(insert ( 423 1560 1560 2 s 1788 403 0 ));
  364. DATA(insert ( 423 1560 1560 3 s 1784 403 0 ));
  365. DATA(insert ( 423 1560 1560 4 s 1789 403 0 ));
  366. DATA(insert ( 423 1560 1560 5 s 1787 403 0 ));
  367. /*
  368. * btree varbit
  369. */
  370. DATA(insert ( 2002 1562 1562 1 s 1806 403 0 ));
  371. DATA(insert ( 2002 1562 1562 2 s 1808 403 0 ));
  372. DATA(insert ( 2002 1562 1562 3 s 1804 403 0 ));
  373. DATA(insert ( 2002 1562 1562 4 s 1809 403 0 ));
  374. DATA(insert ( 2002 1562 1562 5 s 1807 403 0 ));
  375. /*
  376. * btree text pattern
  377. */
  378. DATA(insert ( 2095 25 25 1 s 2314 403 0 ));
  379. DATA(insert ( 2095 25 25 2 s 2315 403 0 ));
  380. DATA(insert ( 2095 25 25 3 s 98 403 0 ));
  381. DATA(insert ( 2095 25 25 4 s 2317 403 0 ));
  382. DATA(insert ( 2095 25 25 5 s 2318 403 0 ));
  383. /*
  384. * btree bpchar pattern
  385. */
  386. DATA(insert ( 2097 1042 1042 1 s 2326 403 0 ));
  387. DATA(insert ( 2097 1042 1042 2 s 2327 403 0 ));
  388. DATA(insert ( 2097 1042 1042 3 s 1054 403 0 ));
  389. DATA(insert ( 2097 1042 1042 4 s 2329 403 0 ));
  390. DATA(insert ( 2097 1042 1042 5 s 2330 403 0 ));
  391. /*
  392. * btree money_ops
  393. */
  394. DATA(insert ( 2099 790 790 1 s 902 403 0 ));
  395. DATA(insert ( 2099 790 790 2 s 904 403 0 ));
  396. DATA(insert ( 2099 790 790 3 s 900 403 0 ));
  397. DATA(insert ( 2099 790 790 4 s 905 403 0 ));
  398. DATA(insert ( 2099 790 790 5 s 903 403 0 ));
  399. /*
  400. * btree reltime_ops
  401. */
  402. DATA(insert ( 2233 703 703 1 s 568 403 0 ));
  403. DATA(insert ( 2233 703 703 2 s 570 403 0 ));
  404. DATA(insert ( 2233 703 703 3 s 566 403 0 ));
  405. DATA(insert ( 2233 703 703 4 s 571 403 0 ));
  406. DATA(insert ( 2233 703 703 5 s 569 403 0 ));
  407. /*
  408. * btree tinterval_ops
  409. */
  410. DATA(insert ( 2234 704 704 1 s 813 403 0 ));
  411. DATA(insert ( 2234 704 704 2 s 815 403 0 ));
  412. DATA(insert ( 2234 704 704 3 s 811 403 0 ));
  413. DATA(insert ( 2234 704 704 4 s 816 403 0 ));
  414. DATA(insert ( 2234 704 704 5 s 814 403 0 ));
  415. /*
  416. * btree array_ops
  417. */
  418. DATA(insert ( 397 2277 2277 1 s 1072 403 0 ));
  419. DATA(insert ( 397 2277 2277 2 s 1074 403 0 ));
  420. DATA(insert ( 397 2277 2277 3 s 1070 403 0 ));
  421. DATA(insert ( 397 2277 2277 4 s 1075 403 0 ));
  422. DATA(insert ( 397 2277 2277 5 s 1073 403 0 ));
  423. /*
  424. * btree record_ops
  425. */
  426. DATA(insert ( 2994 2249 2249 1 s 2990 403 0 ));
  427. DATA(insert ( 2994 2249 2249 2 s 2992 403 0 ));
  428. DATA(insert ( 2994 2249 2249 3 s 2988 403 0 ));
  429. DATA(insert ( 2994 2249 2249 4 s 2993 403 0 ));
  430. DATA(insert ( 2994 2249 2249 5 s 2991 403 0 ));
  431. /*
  432. * btree record_image_ops
  433. */
  434. DATA(insert ( 3194 2249 2249 1 s 3190 403 0 ));
  435. DATA(insert ( 3194 2249 2249 2 s 3192 403 0 ));
  436. DATA(insert ( 3194 2249 2249 3 s 3188 403 0 ));
  437. DATA(insert ( 3194 2249 2249 4 s 3193 403 0 ));
  438. DATA(insert ( 3194 2249 2249 5 s 3191 403 0 ));
  439. /*
  440. * btree uuid_ops
  441. */
  442. DATA(insert ( 2968 2950 2950 1 s 2974 403 0 ));
  443. DATA(insert ( 2968 2950 2950 2 s 2976 403 0 ));
  444. DATA(insert ( 2968 2950 2950 3 s 2972 403 0 ));
  445. DATA(insert ( 2968 2950 2950 4 s 2977 403 0 ));
  446. DATA(insert ( 2968 2950 2950 5 s 2975 403 0 ));
  447. /*
  448. * btree pg_lsn_ops
  449. */
  450. DATA(insert ( 3253 3220 3220 1 s 3224 403 0 ));
  451. DATA(insert ( 3253 3220 3220 2 s 3226 403 0 ));
  452. DATA(insert ( 3253 3220 3220 3 s 3222 403 0 ));
  453. DATA(insert ( 3253 3220 3220 4 s 3227 403 0 ));
  454. DATA(insert ( 3253 3220 3220 5 s 3225 403 0 ));
  455. /*
  456. * hash index _ops
  457. */
  458. /* bpchar_ops */
  459. DATA(insert ( 427 1042 1042 1 s 1054 405 0 ));
  460. /* char_ops */
  461. DATA(insert ( 431 18 18 1 s 92 405 0 ));
  462. /* date_ops */
  463. DATA(insert ( 435 1082 1082 1 s 1093 405 0 ));
  464. /* float_ops */
  465. DATA(insert ( 1971 700 700 1 s 620 405 0 ));
  466. DATA(insert ( 1971 701 701 1 s 670 405 0 ));
  467. DATA(insert ( 1971 700 701 1 s 1120 405 0 ));
  468. DATA(insert ( 1971 701 700 1 s 1130 405 0 ));
  469. /* network_ops */
  470. DATA(insert ( 1975 869 869 1 s 1201 405 0 ));
  471. /* integer_ops */
  472. DATA(insert ( 1977 21 21 1 s 94 405 0 ));
  473. DATA(insert ( 1977 23 23 1 s 96 405 0 ));
  474. DATA(insert ( 1977 20 20 1 s 410 405 0 ));
  475. DATA(insert ( 1977 21 23 1 s 532 405 0 ));
  476. DATA(insert ( 1977 21 20 1 s 1862 405 0 ));
  477. DATA(insert ( 1977 23 21 1 s 533 405 0 ));
  478. DATA(insert ( 1977 23 20 1 s 15 405 0 ));
  479. DATA(insert ( 1977 20 21 1 s 1868 405 0 ));
  480. DATA(insert ( 1977 20 23 1 s 416 405 0 ));
  481. /* interval_ops */
  482. DATA(insert ( 1983 1186 1186 1 s 1330 405 0 ));
  483. /* macaddr_ops */
  484. DATA(insert ( 1985 829 829 1 s 1220 405 0 ));
  485. /* name_ops */
  486. DATA(insert ( 1987 19 19 1 s 93 405 0 ));
  487. /* oid_ops */
  488. DATA(insert ( 1990 26 26 1 s 607 405 0 ));
  489. /* oidvector_ops */
  490. DATA(insert ( 1992 30 30 1 s 649 405 0 ));
  491. /* text_ops */
  492. DATA(insert ( 1995 25 25 1 s 98 405 0 ));
  493. /* time_ops */
  494. DATA(insert ( 1997 1083 1083 1 s 1108 405 0 ));
  495. /* timestamptz_ops */
  496. DATA(insert ( 1999 1184 1184 1 s 1320 405 0 ));
  497. /* timetz_ops */
  498. DATA(insert ( 2001 1266 1266 1 s 1550 405 0 ));
  499. /* timestamp_ops */
  500. DATA(insert ( 2040 1114 1114 1 s 2060 405 0 ));
  501. /* bool_ops */
  502. DATA(insert ( 2222 16 16 1 s 91 405 0 ));
  503. /* bytea_ops */
  504. DATA(insert ( 2223 17 17 1 s 1955 405 0 ));
  505. /* int2vector_ops */
  506. DATA(insert ( 2224 22 22 1 s 386 405 0 ));
  507. /* xid_ops */
  508. DATA(insert ( 2225 28 28 1 s 352 405 0 ));
  509. /* cid_ops */
  510. DATA(insert ( 2226 29 29 1 s 385 405 0 ));
  511. /* abstime_ops */
  512. DATA(insert ( 2227 702 702 1 s 560 405 0 ));
  513. /* reltime_ops */
  514. DATA(insert ( 2228 703 703 1 s 566 405 0 ));
  515. /* text_pattern_ops */
  516. DATA(insert ( 2229 25 25 1 s 98 405 0 ));
  517. /* bpchar_pattern_ops */
  518. DATA(insert ( 2231 1042 1042 1 s 1054 405 0 ));
  519. /* aclitem_ops */
  520. DATA(insert ( 2235 1033 1033 1 s 974 405 0 ));
  521. /* uuid_ops */
  522. DATA(insert ( 2969 2950 2950 1 s 2972 405 0 ));
  523. /* pg_lsn_ops */
  524. DATA(insert ( 3254 3220 3220 1 s 3222 405 0 ));
  525. /* numeric_ops */
  526. DATA(insert ( 1998 1700 1700 1 s 1752 405 0 ));
  527. /* array_ops */
  528. DATA(insert ( 627 2277 2277 1 s 1070 405 0 ));
  529. /*
  530. * gist box_ops
  531. */
  532. DATA(insert ( 2593 603 603 1 s 493 783 0 ));
  533. DATA(insert ( 2593 603 603 2 s 494 783 0 ));
  534. DATA(insert ( 2593 603 603 3 s 500 783 0 ));
  535. DATA(insert ( 2593 603 603 4 s 495 783 0 ));
  536. DATA(insert ( 2593 603 603 5 s 496 783 0 ));
  537. DATA(insert ( 2593 603 603 6 s 499 783 0 ));
  538. DATA(insert ( 2593 603 603 7 s 498 783 0 ));
  539. DATA(insert ( 2593 603 603 8 s 497 783 0 ));
  540. DATA(insert ( 2593 603 603 9 s 2571 783 0 ));
  541. DATA(insert ( 2593 603 603 10 s 2570 783 0 ));
  542. DATA(insert ( 2593 603 603 11 s 2573 783 0 ));
  543. DATA(insert ( 2593 603 603 12 s 2572 783 0 ));
  544. DATA(insert ( 2593 603 603 13 s 2863 783 0 ));
  545. DATA(insert ( 2593 603 603 14 s 2862 783 0 ));
  546. /*
  547. * gist point_ops
  548. */
  549. DATA(insert ( 1029 600 600 11 s 506 783 0 ));
  550. DATA(insert ( 1029 600 600 1 s 507 783 0 ));
  551. DATA(insert ( 1029 600 600 5 s 508 783 0 ));
  552. DATA(insert ( 1029 600 600 10 s 509 783 0 ));
  553. DATA(insert ( 1029 600 600 6 s 510 783 0 ));
  554. DATA(insert ( 1029 600 600 15 o 517 783 1970 ));
  555. DATA(insert ( 1029 600 603 28 s 511 783 0 ));
  556. DATA(insert ( 1029 600 604 48 s 756 783 0 ));
  557. DATA(insert ( 1029 600 718 68 s 758 783 0 ));
  558. /*
  559. * gist poly_ops (supports polygons)
  560. */
  561. DATA(insert ( 2594 604 604 1 s 485 783 0 ));
  562. DATA(insert ( 2594 604 604 2 s 486 783 0 ));
  563. DATA(insert ( 2594 604 604 3 s 492 783 0 ));
  564. DATA(insert ( 2594 604 604 4 s 487 783 0 ));
  565. DATA(insert ( 2594 604 604 5 s 488 783 0 ));
  566. DATA(insert ( 2594 604 604 6 s 491 783 0 ));
  567. DATA(insert ( 2594 604 604 7 s 490 783 0 ));
  568. DATA(insert ( 2594 604 604 8 s 489 783 0 ));
  569. DATA(insert ( 2594 604 604 9 s 2575 783 0 ));
  570. DATA(insert ( 2594 604 604 10 s 2574 783 0 ));
  571. DATA(insert ( 2594 604 604 11 s 2577 783 0 ));
  572. DATA(insert ( 2594 604 604 12 s 2576 783 0 ));
  573. DATA(insert ( 2594 604 604 13 s 2861 783 0 ));
  574. DATA(insert ( 2594 604 604 14 s 2860 783 0 ));
  575. DATA(insert ( 2594 604 600 15 o 3289 783 1970 ));
  576. /*
  577. * gist circle_ops
  578. */
  579. DATA(insert ( 2595 718 718 1 s 1506 783 0 ));
  580. DATA(insert ( 2595 718 718 2 s 1507 783 0 ));
  581. DATA(insert ( 2595 718 718 3 s 1513 783 0 ));
  582. DATA(insert ( 2595 718 718 4 s 1508 783 0 ));
  583. DATA(insert ( 2595 718 718 5 s 1509 783 0 ));
  584. DATA(insert ( 2595 718 718 6 s 1512 783 0 ));
  585. DATA(insert ( 2595 718 718 7 s 1511 783 0 ));
  586. DATA(insert ( 2595 718 718 8 s 1510 783 0 ));
  587. DATA(insert ( 2595 718 718 9 s 2589 783 0 ));
  588. DATA(insert ( 2595 718 718 10 s 1515 783 0 ));
  589. DATA(insert ( 2595 718 718 11 s 1514 783 0 ));
  590. DATA(insert ( 2595 718 718 12 s 2590 783 0 ));
  591. DATA(insert ( 2595 718 718 13 s 2865 783 0 ));
  592. DATA(insert ( 2595 718 718 14 s 2864 783 0 ));
  593. DATA(insert ( 2595 718 600 15 o 3291 783 1970 ));
  594. /*
  595. * gin array_ops (these anyarray operators are used with all the opclasses
  596. * of the family)
  597. */
  598. DATA(insert ( 2745 2277 2277 1 s 2750 2742 0 ));
  599. DATA(insert ( 2745 2277 2277 2 s 2751 2742 0 ));
  600. DATA(insert ( 2745 2277 2277 3 s 2752 2742 0 ));
  601. DATA(insert ( 2745 2277 2277 4 s 1070 2742 0 ));
  602. /*
  603. * btree enum_ops
  604. */
  605. DATA(insert ( 3522 3500 3500 1 s 3518 403 0 ));
  606. DATA(insert ( 3522 3500 3500 2 s 3520 403 0 ));
  607. DATA(insert ( 3522 3500 3500 3 s 3516 403 0 ));
  608. DATA(insert ( 3522 3500 3500 4 s 3521 403 0 ));
  609. DATA(insert ( 3522 3500 3500 5 s 3519 403 0 ));
  610. /*
  611. * hash enum_ops
  612. */
  613. DATA(insert ( 3523 3500 3500 1 s 3516 405 0 ));
  614. /*
  615. * btree tsvector_ops
  616. */
  617. DATA(insert ( 3626 3614 3614 1 s 3627 403 0 ));
  618. DATA(insert ( 3626 3614 3614 2 s 3628 403 0 ));
  619. DATA(insert ( 3626 3614 3614 3 s 3629 403 0 ));
  620. DATA(insert ( 3626 3614 3614 4 s 3631 403 0 ));
  621. DATA(insert ( 3626 3614 3614 5 s 3632 403 0 ));
  622. /*
  623. * GiST tsvector_ops
  624. */
  625. DATA(insert ( 3655 3614 3615 1 s 3636 783 0 ));
  626. /*
  627. * GIN tsvector_ops
  628. */
  629. DATA(insert ( 3659 3614 3615 1 s 3636 2742 0 ));
  630. DATA(insert ( 3659 3614 3615 2 s 3660 2742 0 ));
  631. /*
  632. * btree tsquery_ops
  633. */
  634. DATA(insert ( 3683 3615 3615 1 s 3674 403 0 ));
  635. DATA(insert ( 3683 3615 3615 2 s 3675 403 0 ));
  636. DATA(insert ( 3683 3615 3615 3 s 3676 403 0 ));
  637. DATA(insert ( 3683 3615 3615 4 s 3678 403 0 ));
  638. DATA(insert ( 3683 3615 3615 5 s 3679 403 0 ));
  639. /*
  640. * GiST tsquery_ops
  641. */
  642. DATA(insert ( 3702 3615 3615 7 s 3693 783 0 ));
  643. DATA(insert ( 3702 3615 3615 8 s 3694 783 0 ));
  644. /*
  645. * btree range_ops
  646. */
  647. DATA(insert ( 3901 3831 3831 1 s 3884 403 0 ));
  648. DATA(insert ( 3901 3831 3831 2 s 3885 403 0 ));
  649. DATA(insert ( 3901 3831 3831 3 s 3882 403 0 ));
  650. DATA(insert ( 3901 3831 3831 4 s 3886 403 0 ));
  651. DATA(insert ( 3901 3831 3831 5 s 3887 403 0 ));
  652. /*
  653. * hash range_ops
  654. */
  655. DATA(insert ( 3903 3831 3831 1 s 3882 405 0 ));
  656. /*
  657. * GiST range_ops
  658. */
  659. DATA(insert ( 3919 3831 3831 1 s 3893 783 0 ));
  660. DATA(insert ( 3919 3831 3831 2 s 3895 783 0 ));
  661. DATA(insert ( 3919 3831 3831 3 s 3888 783 0 ));
  662. DATA(insert ( 3919 3831 3831 4 s 3896 783 0 ));
  663. DATA(insert ( 3919 3831 3831 5 s 3894 783 0 ));
  664. DATA(insert ( 3919 3831 3831 6 s 3897 783 0 ));
  665. DATA(insert ( 3919 3831 3831 7 s 3890 783 0 ));
  666. DATA(insert ( 3919 3831 3831 8 s 3892 783 0 ));
  667. DATA(insert ( 3919 3831 2283 16 s 3889 783 0 ));
  668. DATA(insert ( 3919 3831 3831 18 s 3882 783 0 ));
  669. /*
  670. * SP-GiST quad_point_ops
  671. */
  672. DATA(insert ( 4015 600 600 11 s 506 4000 0 ));
  673. DATA(insert ( 4015 600 600 1 s 507 4000 0 ));
  674. DATA(insert ( 4015 600 600 5 s 508 4000 0 ));
  675. DATA(insert ( 4015 600 600 10 s 509 4000 0 ));
  676. DATA(insert ( 4015 600 600 6 s 510 4000 0 ));
  677. DATA(insert ( 4015 600 603 8 s 511 4000 0 ));
  678. /*
  679. * SP-GiST kd_point_ops
  680. */
  681. DATA(insert ( 4016 600 600 11 s 506 4000 0 ));
  682. DATA(insert ( 4016 600 600 1 s 507 4000 0 ));
  683. DATA(insert ( 4016 600 600 5 s 508 4000 0 ));
  684. DATA(insert ( 4016 600 600 10 s 509 4000 0 ));
  685. DATA(insert ( 4016 600 600 6 s 510 4000 0 ));
  686. DATA(insert ( 4016 600 603 8 s 511 4000 0 ));
  687. /*
  688. * SP-GiST text_ops
  689. */
  690. DATA(insert ( 4017 25 25 1 s 2314 4000 0 ));
  691. DATA(insert ( 4017 25 25 2 s 2315 4000 0 ));
  692. DATA(insert ( 4017 25 25 3 s 98 4000 0 ));
  693. DATA(insert ( 4017 25 25 4 s 2317 4000 0 ));
  694. DATA(insert ( 4017 25 25 5 s 2318 4000 0 ));
  695. DATA(insert ( 4017 25 25 11 s 664 4000 0 ));
  696. DATA(insert ( 4017 25 25 12 s 665 4000 0 ));
  697. DATA(insert ( 4017 25 25 14 s 667 4000 0 ));
  698. DATA(insert ( 4017 25 25 15 s 666 4000 0 ));
  699. /*
  700. * btree jsonb_ops
  701. */
  702. DATA(insert ( 4033 3802 3802 1 s 3242 403 0 ));
  703. DATA(insert ( 4033 3802 3802 2 s 3244 403 0 ));
  704. DATA(insert ( 4033 3802 3802 3 s 3240 403 0 ));
  705. DATA(insert ( 4033 3802 3802 4 s 3245 403 0 ));
  706. DATA(insert ( 4033 3802 3802 5 s 3243 403 0 ));
  707. /*
  708. * hash jsonb_ops
  709. */
  710. DATA(insert ( 4034 3802 3802 1 s 3240 405 0 ));
  711. /*
  712. * GIN jsonb_ops
  713. */
  714. DATA(insert ( 4036 3802 3802 7 s 3246 2742 0 ));
  715. DATA(insert ( 4036 3802 25 9 s 3247 2742 0 ));
  716. DATA(insert ( 4036 3802 1009 10 s 3248 2742 0 ));
  717. DATA(insert ( 4036 3802 1009 11 s 3249 2742 0 ));
  718. /*
  719. * GIN jsonb_path_ops
  720. */
  721. DATA(insert ( 4037 3802 3802 7 s 3246 2742 0 ));
  722. /*
  723. * SP-GiST range_ops
  724. */
  725. DATA(insert ( 3474 3831 3831 1 s 3893 4000 0 ));
  726. DATA(insert ( 3474 3831 3831 2 s 3895 4000 0 ));
  727. DATA(insert ( 3474 3831 3831 3 s 3888 4000 0 ));
  728. DATA(insert ( 3474 3831 3831 4 s 3896 4000 0 ));
  729. DATA(insert ( 3474 3831 3831 5 s 3894 4000 0 ));
  730. DATA(insert ( 3474 3831 3831 6 s 3897 4000 0 ));
  731. DATA(insert ( 3474 3831 3831 7 s 3890 4000 0 ));
  732. DATA(insert ( 3474 3831 3831 8 s 3892 4000 0 ));
  733. DATA(insert ( 3474 3831 2283 16 s 3889 4000 0 ));
  734. DATA(insert ( 3474 3831 3831 18 s 3882 4000 0 ));
  735. /*
  736. * SP-GiST box_ops
  737. */
  738. DATA(insert ( 5000 603 603 1 s 493 4000 0 ));
  739. DATA(insert ( 5000 603 603 2 s 494 4000 0 ));
  740. DATA(insert ( 5000 603 603 3 s 500 4000 0 ));
  741. DATA(insert ( 5000 603 603 4 s 495 4000 0 ));
  742. DATA(insert ( 5000 603 603 5 s 496 4000 0 ));
  743. DATA(insert ( 5000 603 603 6 s 499 4000 0 ));
  744. DATA(insert ( 5000 603 603 7 s 498 4000 0 ));
  745. DATA(insert ( 5000 603 603 8 s 497 4000 0 ));
  746. DATA(insert ( 5000 603 603 9 s 2571 4000 0 ));
  747. DATA(insert ( 5000 603 603 10 s 2570 4000 0 ));
  748. DATA(insert ( 5000 603 603 11 s 2573 4000 0 ));
  749. DATA(insert ( 5000 603 603 12 s 2572 4000 0 ));
  750. /*
  751. * GiST inet_ops
  752. */
  753. DATA(insert ( 3550 869 869 3 s 3552 783 0 ));
  754. DATA(insert ( 3550 869 869 18 s 1201 783 0 ));
  755. DATA(insert ( 3550 869 869 19 s 1202 783 0 ));
  756. DATA(insert ( 3550 869 869 20 s 1203 783 0 ));
  757. DATA(insert ( 3550 869 869 21 s 1204 783 0 ));
  758. DATA(insert ( 3550 869 869 22 s 1205 783 0 ));
  759. DATA(insert ( 3550 869 869 23 s 1206 783 0 ));
  760. DATA(insert ( 3550 869 869 24 s 931 783 0 ));
  761. DATA(insert ( 3550 869 869 25 s 932 783 0 ));
  762. DATA(insert ( 3550 869 869 26 s 933 783 0 ));
  763. DATA(insert ( 3550 869 869 27 s 934 783 0 ));
  764. /* BRIN opclasses */
  765. /* minmax bytea */
  766. DATA(insert ( 4064 17 17 1 s 1957 3580 0 ));
  767. DATA(insert ( 4064 17 17 2 s 1958 3580 0 ));
  768. DATA(insert ( 4064 17 17 3 s 1955 3580 0 ));
  769. DATA(insert ( 4064 17 17 4 s 1960 3580 0 ));
  770. DATA(insert ( 4064 17 17 5 s 1959 3580 0 ));
  771. /* minmax "char" */
  772. DATA(insert ( 4062 18 18 1 s 631 3580 0 ));
  773. DATA(insert ( 4062 18 18 2 s 632 3580 0 ));
  774. DATA(insert ( 4062 18 18 3 s 92 3580 0 ));
  775. DATA(insert ( 4062 18 18 4 s 634 3580 0 ));
  776. DATA(insert ( 4062 18 18 5 s 633 3580 0 ));
  777. /* minmax name */
  778. DATA(insert ( 4065 19 19 1 s 660 3580 0 ));
  779. DATA(insert ( 4065 19 19 2 s 661 3580 0 ));
  780. DATA(insert ( 4065 19 19 3 s 93 3580 0 ));
  781. DATA(insert ( 4065 19 19 4 s 663 3580 0 ));
  782. DATA(insert ( 4065 19 19 5 s 662 3580 0 ));
  783. /* minmax integer */
  784. DATA(insert ( 4054 20 20 1 s 412 3580 0 ));
  785. DATA(insert ( 4054 20 20 2 s 414 3580 0 ));
  786. DATA(insert ( 4054 20 20 3 s 410 3580 0 ));
  787. DATA(insert ( 4054 20 20 4 s 415 3580 0 ));
  788. DATA(insert ( 4054 20 20 5 s 413 3580 0 ));
  789. DATA(insert ( 4054 20 21 1 s 1870 3580 0 ));
  790. DATA(insert ( 4054 20 21 2 s 1872 3580 0 ));
  791. DATA(insert ( 4054 20 21 3 s 1868 3580 0 ));
  792. DATA(insert ( 4054 20 21 4 s 1873 3580 0 ));
  793. DATA(insert ( 4054 20 21 5 s 1871 3580 0 ));
  794. DATA(insert ( 4054 20 23 1 s 418 3580 0 ));
  795. DATA(insert ( 4054 20 23 2 s 420 3580 0 ));
  796. DATA(insert ( 4054 20 23 3 s 416 3580 0 ));
  797. DATA(insert ( 4054 20 23 4 s 430 3580 0 ));
  798. DATA(insert ( 4054 20 23 5 s 419 3580 0 ));
  799. DATA(insert ( 4054 21 21 1 s 95 3580 0 ));
  800. DATA(insert ( 4054 21 21 2 s 522 3580 0 ));
  801. DATA(insert ( 4054 21 21 3 s 94 3580 0 ));
  802. DATA(insert ( 4054 21 21 4 s 524 3580 0 ));
  803. DATA(insert ( 4054 21 21 5 s 520 3580 0 ));
  804. DATA(insert ( 4054 21 20 1 s 1864 3580 0 ));
  805. DATA(insert ( 4054 21 20 2 s 1866 3580 0 ));
  806. DATA(insert ( 4054 21 20 3 s 1862 3580 0 ));
  807. DATA(insert ( 4054 21 20 4 s 1867 3580 0 ));
  808. DATA(insert ( 4054 21 20 5 s 1865 3580 0 ));
  809. DATA(insert ( 4054 21 23 1 s 534 3580 0 ));
  810. DATA(insert ( 4054 21 23 2 s 540 3580 0 ));
  811. DATA(insert ( 4054 21 23 3 s 532 3580 0 ));
  812. DATA(insert ( 4054 21 23 4 s 542 3580 0 ));
  813. DATA(insert ( 4054 21 23 5 s 536 3580 0 ));
  814. DATA(insert ( 4054 23 23 1 s 97 3580 0 ));
  815. DATA(insert ( 4054 23 23 2 s 523 3580 0 ));
  816. DATA(insert ( 4054 23 23 3 s 96 3580 0 ));
  817. DATA(insert ( 4054 23 23 4 s 525 3580 0 ));
  818. DATA(insert ( 4054 23 23 5 s 521 3580 0 ));
  819. DATA(insert ( 4054 23 21 1 s 535 3580 0 ));
  820. DATA(insert ( 4054 23 21 2 s 541 3580 0 ));
  821. DATA(insert ( 4054 23 21 3 s 533 3580 0 ));
  822. DATA(insert ( 4054 23 21 4 s 543 3580 0 ));
  823. DATA(insert ( 4054 23 21 5 s 537 3580 0 ));
  824. DATA(insert ( 4054 23 20 1 s 37 3580 0 ));
  825. DATA(insert ( 4054 23 20 2 s 80 3580 0 ));
  826. DATA(insert ( 4054 23 20 3 s 15 3580 0 ));
  827. DATA(insert ( 4054 23 20 4 s 82 3580 0 ));
  828. DATA(insert ( 4054 23 20 5 s 76 3580 0 ));
  829. /* minmax text */
  830. DATA(insert ( 4056 25 25 1 s 664 3580 0 ));
  831. DATA(insert ( 4056 25 25 2 s 665 3580 0 ));
  832. DATA(insert ( 4056 25 25 3 s 98 3580 0 ));
  833. DATA(insert ( 4056 25 25 4 s 667 3580 0 ));
  834. DATA(insert ( 4056 25 25 5 s 666 3580 0 ));
  835. /* minmax oid */
  836. DATA(insert ( 4068 26 26 1 s 609 3580 0 ));
  837. DATA(insert ( 4068 26 26 2 s 611 3580 0 ));
  838. DATA(insert ( 4068 26 26 3 s 607 3580 0 ));
  839. DATA(insert ( 4068 26 26 4 s 612 3580 0 ));
  840. DATA(insert ( 4068 26 26 5 s 610 3580 0 ));
  841. /* minmax tid */
  842. DATA(insert ( 4069 27 27 1 s 2799 3580 0 ));
  843. DATA(insert ( 4069 27 27 2 s 2801 3580 0 ));
  844. DATA(insert ( 4069 27 27 3 s 387 3580 0 ));
  845. DATA(insert ( 4069 27 27 4 s 2802 3580 0 ));
  846. DATA(insert ( 4069 27 27 5 s 2800 3580 0 ));
  847. /* minmax float (float4, float8) */
  848. DATA(insert ( 4070 700 700 1 s 622 3580 0 ));
  849. DATA(insert ( 4070 700 700 2 s 624 3580 0 ));
  850. DATA(insert ( 4070 700 700 3 s 620 3580 0 ));
  851. DATA(insert ( 4070 700 700 4 s 625 3580 0 ));
  852. DATA(insert ( 4070 700 700 5 s 623 3580 0 ));
  853. DATA(insert ( 4070 700 701 1 s 1122 3580 0 ));
  854. DATA(insert ( 4070 700 701 2 s 1124 3580 0 ));
  855. DATA(insert ( 4070 700 701 3 s 1120 3580 0 ));
  856. DATA(insert ( 4070 700 701 4 s 1125 3580 0 ));
  857. DATA(insert ( 4070 700 701 5 s 1123 3580 0 ));
  858. DATA(insert ( 4070 701 700 1 s 1132 3580 0 ));
  859. DATA(insert ( 4070 701 700 2 s 1134 3580 0 ));
  860. DATA(insert ( 4070 701 700 3 s 1130 3580 0 ));
  861. DATA(insert ( 4070 701 700 4 s 1135 3580 0 ));
  862. DATA(insert ( 4070 701 700 5 s 1133 3580 0 ));
  863. DATA(insert ( 4070 701 701 1 s 672 3580 0 ));
  864. DATA(insert ( 4070 701 701 2 s 673 3580 0 ));
  865. DATA(insert ( 4070 701 701 3 s 670 3580 0 ));
  866. DATA(insert ( 4070 701 701 4 s 675 3580 0 ));
  867. DATA(insert ( 4070 701 701 5 s 674 3580 0 ));
  868. /* minmax abstime */
  869. DATA(insert ( 4072 702 702 1 s 562 3580 0 ));
  870. DATA(insert ( 4072 702 702 2 s 564 3580 0 ));
  871. DATA(insert ( 4072 702 702 3 s 560 3580 0 ));
  872. DATA(insert ( 4072 702 702 4 s 565 3580 0 ));
  873. DATA(insert ( 4072 702 702 5 s 563 3580 0 ));
  874. /* minmax reltime */
  875. DATA(insert ( 4073 703 703 1 s 568 3580 0 ));
  876. DATA(insert ( 4073 703 703 2 s 570 3580 0 ));
  877. DATA(insert ( 4073 703 703 3 s 566 3580 0 ));
  878. DATA(insert ( 4073 703 703 4 s 571 3580 0 ));
  879. DATA(insert ( 4073 703 703 5 s 569 3580 0 ));
  880. /* minmax macaddr */
  881. DATA(insert ( 4074 829 829 1 s 1222 3580 0 ));
  882. DATA(insert ( 4074 829 829 2 s 1223 3580 0 ));
  883. DATA(insert ( 4074 829 829 3 s 1220 3580 0 ));
  884. DATA(insert ( 4074 829 829 4 s 1225 3580 0 ));
  885. DATA(insert ( 4074 829 829 5 s 1224 3580 0 ));
  886. /* minmax inet */
  887. DATA(insert ( 4075 869 869 1 s 1203 3580 0 ));
  888. DATA(insert ( 4075 869 869 2 s 1204 3580 0 ));
  889. DATA(insert ( 4075 869 869 3 s 1201 3580 0 ));
  890. DATA(insert ( 4075 869 869 4 s 1206 3580 0 ));
  891. DATA(insert ( 4075 869 869 5 s 1205 3580 0 ));
  892. /* inclusion inet */
  893. DATA(insert ( 4102 869 869 3 s 3552 3580 0 ));
  894. DATA(insert ( 4102 869 869 7 s 934 3580 0 ));
  895. DATA(insert ( 4102 869 869 8 s 932 3580 0 ));
  896. DATA(insert ( 4102 869 869 18 s 1201 3580 0 ));
  897. DATA(insert ( 4102 869 869 24 s 933 3580 0 ));
  898. DATA(insert ( 4102 869 869 26 s 931 3580 0 ));
  899. /* minmax character */
  900. DATA(insert ( 4076 1042 1042 1 s 1058 3580 0 ));
  901. DATA(insert ( 4076 1042 1042 2 s 1059 3580 0 ));
  902. DATA(insert ( 4076 1042 1042 3 s 1054 3580 0 ));
  903. DATA(insert ( 4076 1042 1042 4 s 1061 3580 0 ));
  904. DATA(insert ( 4076 1042 1042 5 s 1060 3580 0 ));
  905. /* minmax time without time zone */
  906. DATA(insert ( 4077 1083 1083 1 s 1110 3580 0 ));
  907. DATA(insert ( 4077 1083 1083 2 s 1111 3580 0 ));
  908. DATA(insert ( 4077 1083 1083 3 s 1108 3580 0 ));
  909. DATA(insert ( 4077 1083 1083 4 s 1113 3580 0 ));
  910. DATA(insert ( 4077 1083 1083 5 s 1112 3580 0 ));
  911. /* minmax datetime (date, timestamp, timestamptz) */
  912. DATA(insert ( 4059 1114 1114 1 s 2062 3580 0 ));
  913. DATA(insert ( 4059 1114 1114 2 s 2063 3580 0 ));
  914. DATA(insert ( 4059 1114 1114 3 s 2060 3580 0 ));
  915. DATA(insert ( 4059 1114 1114 4 s 2065 3580 0 ));
  916. DATA(insert ( 4059 1114 1114 5 s 2064 3580 0 ));
  917. DATA(insert ( 4059 1114 1082 1 s 2371 3580 0 ));
  918. DATA(insert ( 4059 1114 1082 2 s 2372 3580 0 ));
  919. DATA(insert ( 4059 1114 1082 3 s 2373 3580 0 ));
  920. DATA(insert ( 4059 1114 1082 4 s 2374 3580 0 ));
  921. DATA(insert ( 4059 1114 1082 5 s 2375 3580 0 ));
  922. DATA(insert ( 4059 1114 1184 1 s 2534 3580 0 ));
  923. DATA(insert ( 4059 1114 1184 2 s 2535 3580 0 ));
  924. DATA(insert ( 4059 1114 1184 3 s 2536 3580 0 ));
  925. DATA(insert ( 4059 1114 1184 4 s 2537 3580 0 ));
  926. DATA(insert ( 4059 1114 1184 5 s 2538 3580 0 ));
  927. DATA(insert ( 4059 1082 1082 1 s 1095 3580 0 ));
  928. DATA(insert ( 4059 1082 1082 2 s 1096 3580 0 ));
  929. DATA(insert ( 4059 1082 1082 3 s 1093 3580 0 ));
  930. DATA(insert ( 4059 1082 1082 4 s 1098 3580 0 ));
  931. DATA(insert ( 4059 1082 1082 5 s 1097 3580 0 ));
  932. DATA(insert ( 4059 1082 1114 1 s 2345 3580 0 ));
  933. DATA(insert ( 4059 1082 1114 2 s 2346 3580 0 ));
  934. DATA(insert ( 4059 1082 1114 3 s 2347 3580 0 ));
  935. DATA(insert ( 4059 1082 1114 4 s 2348 3580 0 ));
  936. DATA(insert ( 4059 1082 1114 5 s 2349 3580 0 ));
  937. DATA(insert ( 4059 1082 1184 1 s 2358 3580 0 ));
  938. DATA(insert ( 4059 1082 1184 2 s 2359 3580 0 ));
  939. DATA(insert ( 4059 1082 1184 3 s 2360 3580 0 ));
  940. DATA(insert ( 4059 1082 1184 4 s 2361 3580 0 ));
  941. DATA(insert ( 4059 1082 1184 5 s 2362 3580 0 ));
  942. DATA(insert ( 4059 1184 1082 1 s 2384 3580 0 ));
  943. DATA(insert ( 4059 1184 1082 2 s 2385 3580 0 ));
  944. DATA(insert ( 4059 1184 1082 3 s 2386 3580 0 ));
  945. DATA(insert ( 4059 1184 1082 4 s 2387 3580 0 ));
  946. DATA(insert ( 4059 1184 1082 5 s 2388 3580 0 ));
  947. DATA(insert ( 4059 1184 1114 1 s 2540 3580 0 ));
  948. DATA(insert ( 4059 1184 1114 2 s 2541 3580 0 ));
  949. DATA(insert ( 4059 1184 1114 3 s 2542 3580 0 ));
  950. DATA(insert ( 4059 1184 1114 4 s 2543 3580 0 ));
  951. DATA(insert ( 4059 1184 1114 5 s 2544 3580 0 ));
  952. DATA(insert ( 4059 1184 1184 1 s 1322 3580 0 ));
  953. DATA(insert ( 4059 1184 1184 2 s 1323 3580 0 ));
  954. DATA(insert ( 4059 1184 1184 3 s 1320 3580 0 ));
  955. DATA(insert ( 4059 1184 1184 4 s 1325 3580 0 ));
  956. DATA(insert ( 4059 1184 1184 5 s 1324 3580 0 ));
  957. /* minmax interval */
  958. DATA(insert ( 4078 1186 1186 1 s 1332 3580 0 ));
  959. DATA(insert ( 4078 1186 1186 2 s 1333 3580 0 ));
  960. DATA(insert ( 4078 1186 1186 3 s 1330 3580 0 ));
  961. DATA(insert ( 4078 1186 1186 4 s 1335 3580 0 ));
  962. DATA(insert ( 4078 1186 1186 5 s 1334 3580 0 ));
  963. /* minmax time with time zone */
  964. DATA(insert ( 4058 1266 1266 1 s 1552 3580 0 ));
  965. DATA(insert ( 4058 1266 1266 2 s 1553 3580 0 ));
  966. DATA(insert ( 4058 1266 1266 3 s 1550 3580 0 ));
  967. DATA(insert ( 4058 1266 1266 4 s 1555 3580 0 ));
  968. DATA(insert ( 4058 1266 1266 5 s 1554 3580 0 ));
  969. /* minmax bit */
  970. DATA(insert ( 4079 1560 1560 1 s 1786 3580 0 ));
  971. DATA(insert ( 4079 1560 1560 2 s 1788 3580 0 ));
  972. DATA(insert ( 4079 1560 1560 3 s 1784 3580 0 ));
  973. DATA(insert ( 4079 1560 1560 4 s 1789 3580 0 ));
  974. DATA(insert ( 4079 1560 1560 5 s 1787 3580 0 ));
  975. /* minmax bit varying */
  976. DATA(insert ( 4080 1562 1562 1 s 1806 3580 0 ));
  977. DATA(insert ( 4080 1562 1562 2 s 1808 3580 0 ));
  978. DATA(insert ( 4080 1562 1562 3 s 1804 3580 0 ));
  979. DATA(insert ( 4080 1562 1562 4 s 1809 3580 0 ));
  980. DATA(insert ( 4080 1562 1562 5 s 1807 3580 0 ));
  981. /* minmax numeric */
  982. DATA(insert ( 4055 1700 1700 1 s 1754 3580 0 ));
  983. DATA(insert ( 4055 1700 1700 2 s 1755 3580 0 ));
  984. DATA(insert ( 4055 1700 1700 3 s 1752 3580 0 ));
  985. DATA(insert ( 4055 1700 1700 4 s 1757 3580 0 ));
  986. DATA(insert ( 4055 1700 1700 5 s 1756 3580 0 ));
  987. /* minmax uuid */
  988. DATA(insert ( 4081 2950 2950 1 s 2974 3580 0 ));
  989. DATA(insert ( 4081 2950 2950 2 s 2976 3580 0 ));
  990. DATA(insert ( 4081 2950 2950 3 s 2972 3580 0 ));
  991. DATA(insert ( 4081 2950 2950 4 s 2977 3580 0 ));
  992. DATA(insert ( 4081 2950 2950 5 s 2975 3580 0 ));
  993. /* inclusion range types */
  994. DATA(insert ( 4103 3831 3831 1 s 3893 3580 0 ));
  995. DATA(insert ( 4103 3831 3831 2 s 3895 3580 0 ));
  996. DATA(insert ( 4103 3831 3831 3 s 3888 3580 0 ));
  997. DATA(insert ( 4103 3831 3831 4 s 3896 3580 0 ));
  998. DATA(insert ( 4103 3831 3831 5 s 3894 3580 0 ));
  999. DATA(insert ( 4103 3831 3831 7 s 3890 3580 0 ));
  1000. DATA(insert ( 4103 3831 3831 8 s 3892 3580 0 ));
  1001. DATA(insert ( 4103 3831 2283 16 s 3889 3580 0 ));
  1002. DATA(insert ( 4103 3831 3831 17 s 3897 3580 0 ));
  1003. DATA(insert ( 4103 3831 3831 18 s 3882 3580 0 ));
  1004. DATA(insert ( 4103 3831 3831 20 s 3884 3580 0 ));
  1005. DATA(insert ( 4103 3831 3831 21 s 3885 3580 0 ));
  1006. DATA(insert ( 4103 3831 3831 22 s 3887 3580 0 ));
  1007. DATA(insert ( 4103 3831 3831 23 s 3886 3580 0 ));
  1008. /* minmax pg_lsn */
  1009. DATA(insert ( 4082 3220 3220 1 s 3224 3580 0 ));
  1010. DATA(insert ( 4082 3220 3220 2 s 3226 3580 0 ));
  1011. DATA(insert ( 4082 3220 3220 3 s 3222 3580 0 ));
  1012. DATA(insert ( 4082 3220 3220 4 s 3227 3580 0 ));
  1013. DATA(insert ( 4082 3220 3220 5 s 3225 3580 0 ));
  1014. /* inclusion box */
  1015. DATA(insert ( 4104 603 603 1 s 493 3580 0 ));
  1016. DATA(insert ( 4104 603 603 2 s 494 3580 0 ));
  1017. DATA(insert ( 4104 603 603 3 s 500 3580 0 ));
  1018. DATA(insert ( 4104 603 603 4 s 495 3580 0 ));
  1019. DATA(insert ( 4104 603 603 5 s 496 3580 0 ));
  1020. DATA(insert ( 4104 603 603 6 s 499 3580 0 ));
  1021. DATA(insert ( 4104 603 603 7 s 498 3580 0 ));
  1022. DATA(insert ( 4104 603 603 8 s 497 3580 0 ));
  1023. DATA(insert ( 4104 603 603 9 s 2571 3580 0 ));
  1024. DATA(insert ( 4104 603 603 10 s 2570 3580 0 ));
  1025. DATA(insert ( 4104 603 603 11 s 2573 3580 0 ));
  1026. DATA(insert ( 4104 603 603 12 s 2572 3580 0 ));
  1027. /* we could, but choose not to, supply entries for strategies 13 and 14 */
  1028. DATA(insert ( 4104 603 600 7 s 433 3580 0 ));
  1029. #endif /* PG_AMOP_H */