#---------------------------------------------------------------------- # # pg_opfamily.dat # Initial contents of the pg_opfamily system catalog. # # Portions Copyright (c) 1996-2023, 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', oid_symbol => 'INTERVAL_BTREE_FAM_OID', 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' }, ]