1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
|
#----------------------------------------------------------------------
#
# pg_opfamily.dat
# Initial contents of the pg_opfamily system catalog.
#
# Portions Copyright (c) 1996-2021, PostgreSQL Global Development Group
# Portions Copyright (c) 1994, Regents of the University of California
#
# src/include/catalog/pg_opfamily.dat
#
#----------------------------------------------------------------------
[
{ oid => '397',
opfmethod => 'btree', opfname => 'array_ops' },
{ oid => '627',
opfmethod => 'hash', opfname => 'array_ops' },
{ oid => '423',
opfmethod => 'btree', opfname => 'bit_ops' },
{ oid => '424', oid_symbol => 'BOOL_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'bool_ops' },
{ oid => '426', oid_symbol => 'BPCHAR_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'bpchar_ops' },
{ oid => '427',
opfmethod => 'hash', opfname => 'bpchar_ops' },
{ oid => '428', oid_symbol => 'BYTEA_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'bytea_ops' },
{ oid => '429',
opfmethod => 'btree', opfname => 'char_ops' },
{ oid => '431',
opfmethod => 'hash', opfname => 'char_ops' },
{ oid => '434',
opfmethod => 'btree', opfname => 'datetime_ops' },
{ oid => '435',
opfmethod => 'hash', opfname => 'date_ops' },
{ oid => '1970',
opfmethod => 'btree', opfname => 'float_ops' },
{ oid => '1971',
opfmethod => 'hash', opfname => 'float_ops' },
{ oid => '1974', oid_symbol => 'NETWORK_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'network_ops' },
{ oid => '1975',
opfmethod => 'hash', opfname => 'network_ops' },
{ oid => '3550',
opfmethod => 'gist', opfname => 'network_ops' },
{ oid => '3794',
opfmethod => 'spgist', opfname => 'network_ops' },
{ oid => '1976', oid_symbol => 'INTEGER_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'integer_ops' },
{ oid => '1977',
opfmethod => 'hash', opfname => 'integer_ops' },
{ oid => '1982',
opfmethod => 'btree', opfname => 'interval_ops' },
{ oid => '1983',
opfmethod => 'hash', opfname => 'interval_ops' },
{ oid => '1984',
opfmethod => 'btree', opfname => 'macaddr_ops' },
{ oid => '1985',
opfmethod => 'hash', opfname => 'macaddr_ops' },
{ oid => '3371',
opfmethod => 'btree', opfname => 'macaddr8_ops' },
{ oid => '3372',
opfmethod => 'hash', opfname => 'macaddr8_ops' },
{ oid => '1988',
opfmethod => 'btree', opfname => 'numeric_ops' },
{ oid => '1998',
opfmethod => 'hash', opfname => 'numeric_ops' },
{ oid => '1989', oid_symbol => 'OID_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'oid_ops' },
{ oid => '1990',
opfmethod => 'hash', opfname => 'oid_ops' },
{ oid => '1991',
opfmethod => 'btree', opfname => 'oidvector_ops' },
{ oid => '1992',
opfmethod => 'hash', opfname => 'oidvector_ops' },
{ oid => '2994',
opfmethod => 'btree', opfname => 'record_ops' },
{ oid => '6194',
opfmethod => 'hash', opfname => 'record_ops' },
{ oid => '3194',
opfmethod => 'btree', opfname => 'record_image_ops' },
{ oid => '1994', oid_symbol => 'TEXT_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'text_ops' },
{ oid => '1995',
opfmethod => 'hash', opfname => 'text_ops' },
{ oid => '1996',
opfmethod => 'btree', opfname => 'time_ops' },
{ oid => '1997',
opfmethod => 'hash', opfname => 'time_ops' },
{ oid => '1999',
opfmethod => 'hash', opfname => 'timestamptz_ops' },
{ oid => '2000',
opfmethod => 'btree', opfname => 'timetz_ops' },
{ oid => '2001',
opfmethod => 'hash', opfname => 'timetz_ops' },
{ oid => '2002',
opfmethod => 'btree', opfname => 'varbit_ops' },
{ oid => '2040',
opfmethod => 'hash', opfname => 'timestamp_ops' },
{ oid => '2095', oid_symbol => 'TEXT_PATTERN_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'text_pattern_ops' },
{ oid => '2097', oid_symbol => 'BPCHAR_PATTERN_BTREE_FAM_OID',
opfmethod => 'btree', opfname => 'bpchar_pattern_ops' },
{ oid => '2099',
opfmethod => 'btree', opfname => 'money_ops' },
{ oid => '2222', oid_symbol => 'BOOL_HASH_FAM_OID',
opfmethod => 'hash', opfname => 'bool_ops' },
{ oid => '2223',
opfmethod => 'hash', opfname => 'bytea_ops' },
{ oid => '2789',
opfmethod => 'btree', opfname => 'tid_ops' },
{ oid => '2225',
opfmethod => 'hash', opfname => 'xid_ops' },
{ oid => '5032',
opfmethod => 'hash', opfname => 'xid8_ops' },
{ oid => '5067',
opfmethod => 'btree', opfname => 'xid8_ops' },
{ oid => '2226',
opfmethod => 'hash', opfname => 'cid_ops' },
{ oid => '2227',
opfmethod => 'hash', opfname => 'tid_ops' },
{ oid => '2229',
opfmethod => 'hash', opfname => 'text_pattern_ops' },
{ oid => '2231',
opfmethod => 'hash', opfname => 'bpchar_pattern_ops' },
{ oid => '2235',
opfmethod => 'hash', opfname => 'aclitem_ops' },
{ oid => '2593',
opfmethod => 'gist', opfname => 'box_ops' },
{ oid => '2594',
opfmethod => 'gist', opfname => 'poly_ops' },
{ oid => '2595',
opfmethod => 'gist', opfname => 'circle_ops' },
{ oid => '1029',
opfmethod => 'gist', opfname => 'point_ops' },
{ oid => '2745',
opfmethod => 'gin', opfname => 'array_ops' },
{ oid => '2968',
opfmethod => 'btree', opfname => 'uuid_ops' },
{ oid => '2969',
opfmethod => 'hash', opfname => 'uuid_ops' },
{ oid => '3253',
opfmethod => 'btree', opfname => 'pg_lsn_ops' },
{ oid => '3254',
opfmethod => 'hash', opfname => 'pg_lsn_ops' },
{ oid => '3522',
opfmethod => 'btree', opfname => 'enum_ops' },
{ oid => '3523',
opfmethod => 'hash', opfname => 'enum_ops' },
{ oid => '3626',
opfmethod => 'btree', opfname => 'tsvector_ops' },
{ oid => '3655',
opfmethod => 'gist', opfname => 'tsvector_ops' },
{ oid => '3659',
opfmethod => 'gin', opfname => 'tsvector_ops' },
{ oid => '3683',
opfmethod => 'btree', opfname => 'tsquery_ops' },
{ oid => '3702',
opfmethod => 'gist', opfname => 'tsquery_ops' },
{ oid => '3901',
opfmethod => 'btree', opfname => 'range_ops' },
{ oid => '3903',
opfmethod => 'hash', opfname => 'range_ops' },
{ oid => '3919',
opfmethod => 'gist', opfname => 'range_ops' },
{ oid => '3474',
opfmethod => 'spgist', opfname => 'range_ops' },
{ oid => '4015',
opfmethod => 'spgist', opfname => 'quad_point_ops' },
{ oid => '4016',
opfmethod => 'spgist', opfname => 'kd_point_ops' },
{ oid => '4017', oid_symbol => 'TEXT_SPGIST_FAM_OID',
opfmethod => 'spgist', opfname => 'text_ops' },
{ oid => '4033',
opfmethod => 'btree', opfname => 'jsonb_ops' },
{ oid => '4034',
opfmethod => 'hash', opfname => 'jsonb_ops' },
{ oid => '4036',
opfmethod => 'gin', opfname => 'jsonb_ops' },
{ oid => '4037',
opfmethod => 'gin', opfname => 'jsonb_path_ops' },
{ oid => '4054',
opfmethod => 'brin', opfname => 'integer_minmax_ops' },
{ oid => '4602',
opfmethod => 'brin', opfname => 'integer_minmax_multi_ops' },
{ oid => '4572',
opfmethod => 'brin', opfname => 'integer_bloom_ops' },
{ oid => '4055',
opfmethod => 'brin', opfname => 'numeric_minmax_ops' },
{ oid => '4603',
opfmethod => 'brin', opfname => 'numeric_minmax_multi_ops' },
{ oid => '4056',
opfmethod => 'brin', opfname => 'text_minmax_ops' },
{ oid => '4573',
opfmethod => 'brin', opfname => 'text_bloom_ops' },
{ oid => '4574',
opfmethod => 'brin', opfname => 'numeric_bloom_ops' },
{ oid => '4058',
opfmethod => 'brin', opfname => 'timetz_minmax_ops' },
{ oid => '4604',
opfmethod => 'brin', opfname => 'timetz_minmax_multi_ops' },
{ oid => '4575',
opfmethod => 'brin', opfname => 'timetz_bloom_ops' },
{ oid => '4059',
opfmethod => 'brin', opfname => 'datetime_minmax_ops' },
{ oid => '4605',
opfmethod => 'brin', opfname => 'datetime_minmax_multi_ops' },
{ oid => '4576',
opfmethod => 'brin', opfname => 'datetime_bloom_ops' },
{ oid => '4062',
opfmethod => 'brin', opfname => 'char_minmax_ops' },
{ oid => '4577',
opfmethod => 'brin', opfname => 'char_bloom_ops' },
{ oid => '4064',
opfmethod => 'brin', opfname => 'bytea_minmax_ops' },
{ oid => '4578',
opfmethod => 'brin', opfname => 'bytea_bloom_ops' },
{ oid => '4065',
opfmethod => 'brin', opfname => 'name_minmax_ops' },
{ oid => '4579',
opfmethod => 'brin', opfname => 'name_bloom_ops' },
{ oid => '4068',
opfmethod => 'brin', opfname => 'oid_minmax_ops' },
{ oid => '4606',
opfmethod => 'brin', opfname => 'oid_minmax_multi_ops' },
{ oid => '4580',
opfmethod => 'brin', opfname => 'oid_bloom_ops' },
{ oid => '4069',
opfmethod => 'brin', opfname => 'tid_minmax_ops' },
{ oid => '4581',
opfmethod => 'brin', opfname => 'tid_bloom_ops' },
{ oid => '4607',
opfmethod => 'brin', opfname => 'tid_minmax_multi_ops' },
{ oid => '4070',
opfmethod => 'brin', opfname => 'float_minmax_ops' },
{ oid => '4608',
opfmethod => 'brin', opfname => 'float_minmax_multi_ops' },
{ oid => '4582',
opfmethod => 'brin', opfname => 'float_bloom_ops' },
{ oid => '4074',
opfmethod => 'brin', opfname => 'macaddr_minmax_ops' },
{ oid => '4609',
opfmethod => 'brin', opfname => 'macaddr_minmax_multi_ops' },
{ oid => '4583',
opfmethod => 'brin', opfname => 'macaddr_bloom_ops' },
{ oid => '4109',
opfmethod => 'brin', opfname => 'macaddr8_minmax_ops' },
{ oid => '4610',
opfmethod => 'brin', opfname => 'macaddr8_minmax_multi_ops' },
{ oid => '4584',
opfmethod => 'brin', opfname => 'macaddr8_bloom_ops' },
{ oid => '4075',
opfmethod => 'brin', opfname => 'network_minmax_ops' },
{ oid => '4611',
opfmethod => 'brin', opfname => 'network_minmax_multi_ops' },
{ oid => '4102',
opfmethod => 'brin', opfname => 'network_inclusion_ops' },
{ oid => '4585',
opfmethod => 'brin', opfname => 'network_bloom_ops' },
{ oid => '4076',
opfmethod => 'brin', opfname => 'bpchar_minmax_ops' },
{ oid => '4586',
opfmethod => 'brin', opfname => 'bpchar_bloom_ops' },
{ oid => '4077',
opfmethod => 'brin', opfname => 'time_minmax_ops' },
{ oid => '4612',
opfmethod => 'brin', opfname => 'time_minmax_multi_ops' },
{ oid => '4587',
opfmethod => 'brin', opfname => 'time_bloom_ops' },
{ oid => '4078',
opfmethod => 'brin', opfname => 'interval_minmax_ops' },
{ oid => '4613',
opfmethod => 'brin', opfname => 'interval_minmax_multi_ops' },
{ oid => '4588',
opfmethod => 'brin', opfname => 'interval_bloom_ops' },
{ oid => '4079',
opfmethod => 'brin', opfname => 'bit_minmax_ops' },
{ oid => '4080',
opfmethod => 'brin', opfname => 'varbit_minmax_ops' },
{ oid => '4081',
opfmethod => 'brin', opfname => 'uuid_minmax_ops' },
{ oid => '4614',
opfmethod => 'brin', opfname => 'uuid_minmax_multi_ops' },
{ oid => '4589',
opfmethod => 'brin', opfname => 'uuid_bloom_ops' },
{ oid => '4103',
opfmethod => 'brin', opfname => 'range_inclusion_ops' },
{ oid => '4082',
opfmethod => 'brin', opfname => 'pg_lsn_minmax_ops' },
{ oid => '4615',
opfmethod => 'brin', opfname => 'pg_lsn_minmax_multi_ops' },
{ oid => '4590',
opfmethod => 'brin', opfname => 'pg_lsn_bloom_ops' },
{ oid => '4104',
opfmethod => 'brin', opfname => 'box_inclusion_ops' },
{ oid => '5000',
opfmethod => 'spgist', opfname => 'box_ops' },
{ oid => '5008',
opfmethod => 'spgist', opfname => 'poly_ops' },
{ oid => '4199',
opfmethod => 'btree', opfname => 'multirange_ops' },
{ oid => '4225',
opfmethod => 'hash', opfname => 'multirange_ops' },
{ oid => '6158',
opfmethod => 'gist', opfname => 'multirange_ops' },
]
|
