#---------------------------------------------------------------------- # # pg_amproc.dat # Initial contents of the pg_amproc system catalog. # # Portions Copyright (c) 1996-2020, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_amproc.dat # #---------------------------------------------------------------------- [ # btree { amprocfamily => 'btree/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '1', amproc => 'btarraycmp' }, { amprocfamily => 'btree/bit_ops', amproclefttype => 'bit', amprocrighttype => 'bit', amprocnum => '1', amproc => 'bitcmp' }, { amprocfamily => 'btree/bit_ops', amproclefttype => 'bit', amprocrighttype => 'bit', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/bool_ops', amproclefttype => 'bool', amprocrighttype => 'bool', amprocnum => '1', amproc => 'btboolcmp' }, { amprocfamily => 'btree/bool_ops', amproclefttype => 'bool', amprocrighttype => 'bool', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/bpchar_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '1', amproc => 'bpcharcmp' }, { amprocfamily => 'btree/bpchar_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '2', amproc => 'bpchar_sortsupport' }, { amprocfamily => 'btree/bpchar_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '4', amproc => 'btvarstrequalimage' }, { amprocfamily => 'btree/bytea_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '1', amproc => 'byteacmp' }, { amprocfamily => 'btree/bytea_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '2', amproc => 'bytea_sortsupport' }, { amprocfamily => 'btree/bytea_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/char_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '1', amproc => 'btcharcmp' }, { amprocfamily => 'btree/char_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '1', amproc => 'date_cmp' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '2', amproc => 'date_sortsupport' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'date', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'date_cmp_timestamp' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'date', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'date_cmp_timestamptz' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'timestamp_cmp' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '2', amproc => 'timestamp_sortsupport' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamp', amprocrighttype => 'date', amprocnum => '1', amproc => 'timestamp_cmp_date' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'timestamp_cmp_timestamptz' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'timestamptz_cmp' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '2', amproc => 'timestamp_sortsupport' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamptz', amprocrighttype => 'date', amprocnum => '1', amproc => 'timestamptz_cmp_date' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'timestamptz_cmp_timestamp' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'date', amprocrighttype => 'interval', amprocnum => '3', amproc => 'in_range(date,date,interval,bool,bool)' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamp', amprocrighttype => 'interval', amprocnum => '3', amproc => 'in_range(timestamp,timestamp,interval,bool,bool)' }, { amprocfamily => 'btree/datetime_ops', amproclefttype => 'timestamptz', amprocrighttype => 'interval', amprocnum => '3', amproc => 'in_range(timestamptz,timestamptz,interval,bool,bool)' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '1', amproc => 'btfloat4cmp' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '2', amproc => 'btfloat4sortsupport' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float4', amprocrighttype => 'float8', amprocnum => '1', amproc => 'btfloat48cmp' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '1', amproc => 'btfloat8cmp' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '2', amproc => 'btfloat8sortsupport' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float8', amprocrighttype => 'float4', amprocnum => '1', amproc => 'btfloat84cmp' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '3', amproc => 'in_range(float8,float8,float8,bool,bool)' }, { amprocfamily => 'btree/float_ops', amproclefttype => 'float4', amprocrighttype => 'float8', amprocnum => '3', amproc => 'in_range(float4,float4,float8,bool,bool)' }, { amprocfamily => 'btree/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '1', amproc => 'network_cmp' }, { amprocfamily => 'btree/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '2', amproc => 'network_sortsupport' }, { amprocfamily => 'btree/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '1', amproc => 'btint2cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '2', amproc => 'btint2sortsupport' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int4', amprocnum => '1', amproc => 'btint24cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int8', amprocnum => '1', amproc => 'btint28cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int8', amprocnum => '3', amproc => 'in_range(int2,int2,int8,bool,bool)' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int4', amprocnum => '3', amproc => 'in_range(int2,int2,int4,bool,bool)' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '3', amproc => 'in_range(int2,int2,int2,bool,bool)' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '1', amproc => 'btint4cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '2', amproc => 'btint4sortsupport' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int8', amprocnum => '1', amproc => 'btint48cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int2', amprocnum => '1', amproc => 'btint42cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int8', amprocnum => '3', amproc => 'in_range(int4,int4,int8,bool,bool)' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '3', amproc => 'in_range(int4,int4,int4,bool,bool)' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int2', amprocnum => '3', amproc => 'in_range(int4,int4,int2,bool,bool)' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '1', amproc => 'btint8cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '2', amproc => 'btint8sortsupport' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int4', amprocnum => '1', amproc => 'btint84cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int2', amprocnum => '1', amproc => 'btint82cmp' }, { amprocfamily => 'btree/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '3', amproc => 'in_range(int8,int8,int8,bool,bool)' }, { amprocfamily => 'btree/interval_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '1', amproc => 'interval_cmp' }, { amprocfamily => 'btree/interval_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '3', amproc => 'in_range(interval,interval,interval,bool,bool)' }, { amprocfamily => 'btree/interval_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/macaddr_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '1', amproc => 'macaddr_cmp' }, { amprocfamily => 'btree/macaddr_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '2', amproc => 'macaddr_sortsupport' }, { amprocfamily => 'btree/macaddr_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/numeric_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '1', amproc => 'numeric_cmp' }, { amprocfamily => 'btree/numeric_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '2', amproc => 'numeric_sortsupport' }, { amprocfamily => 'btree/numeric_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '3', amproc => 'in_range(numeric,numeric,numeric,bool,bool)' }, { amprocfamily => 'btree/oid_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '1', amproc => 'btoidcmp' }, { amprocfamily => 'btree/oid_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '2', amproc => 'btoidsortsupport' }, { amprocfamily => 'btree/oid_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/oidvector_ops', amproclefttype => 'oidvector', amprocrighttype => 'oidvector', amprocnum => '1', amproc => 'btoidvectorcmp' }, { amprocfamily => 'btree/oidvector_ops', amproclefttype => 'oidvector', amprocrighttype => 'oidvector', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '1', amproc => 'bttextcmp' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '2', amproc => 'bttextsortsupport' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '4', amproc => 'btvarstrequalimage' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '1', amproc => 'btnamecmp' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '2', amproc => 'btnamesortsupport' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '4', amproc => 'btvarstrequalimage' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'name', amprocrighttype => 'text', amprocnum => '1', amproc => 'btnametextcmp' }, { amprocfamily => 'btree/text_ops', amproclefttype => 'text', amprocrighttype => 'name', amprocnum => '1', amproc => 'bttextnamecmp' }, { amprocfamily => 'btree/time_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '1', amproc => 'time_cmp' }, { amprocfamily => 'btree/time_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/time_ops', amproclefttype => 'time', amprocrighttype => 'interval', amprocnum => '3', amproc => 'in_range(time,time,interval,bool,bool)' }, { amprocfamily => 'btree/timetz_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '1', amproc => 'timetz_cmp' }, { amprocfamily => 'btree/timetz_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/timetz_ops', amproclefttype => 'timetz', amprocrighttype => 'interval', amprocnum => '3', amproc => 'in_range(timetz,timetz,interval,bool,bool)' }, { amprocfamily => 'btree/varbit_ops', amproclefttype => 'varbit', amprocrighttype => 'varbit', amprocnum => '1', amproc => 'varbitcmp' }, { amprocfamily => 'btree/varbit_ops', amproclefttype => 'varbit', amprocrighttype => 'varbit', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/text_pattern_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '1', amproc => 'bttext_pattern_cmp' }, { amprocfamily => 'btree/text_pattern_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '2', amproc => 'bttext_pattern_sortsupport' }, { amprocfamily => 'btree/text_pattern_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/bpchar_pattern_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '1', amproc => 'btbpchar_pattern_cmp' }, { amprocfamily => 'btree/bpchar_pattern_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '2', amproc => 'btbpchar_pattern_sortsupport' }, { amprocfamily => 'btree/bpchar_pattern_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/money_ops', amproclefttype => 'money', amprocrighttype => 'money', amprocnum => '1', amproc => 'cash_cmp' }, { amprocfamily => 'btree/money_ops', amproclefttype => 'money', amprocrighttype => 'money', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/tid_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '1', amproc => 'bttidcmp' }, { amprocfamily => 'btree/tid_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/uuid_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '1', amproc => 'uuid_cmp' }, { amprocfamily => 'btree/uuid_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '2', amproc => 'uuid_sortsupport' }, { amprocfamily => 'btree/uuid_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/record_ops', amproclefttype => 'record', amprocrighttype => 'record', amprocnum => '1', amproc => 'btrecordcmp' }, { amprocfamily => 'btree/record_image_ops', amproclefttype => 'record', amprocrighttype => 'record', amprocnum => '1', amproc => 'btrecordimagecmp' }, { amprocfamily => 'btree/pg_lsn_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '1', amproc => 'pg_lsn_cmp' }, { amprocfamily => 'btree/pg_lsn_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/macaddr8_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '1', amproc => 'macaddr8_cmp' }, { amprocfamily => 'btree/macaddr8_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/enum_ops', amproclefttype => 'anyenum', amprocrighttype => 'anyenum', amprocnum => '1', amproc => 'enum_cmp' }, { amprocfamily => 'btree/enum_ops', amproclefttype => 'anyenum', amprocrighttype => 'anyenum', amprocnum => '4', amproc => 'btequalimage' }, { amprocfamily => 'btree/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '1', amproc => 'tsvector_cmp' }, { amprocfamily => 'btree/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '1', amproc => 'tsquery_cmp' }, { amprocfamily => 'btree/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '1', amproc => 'range_cmp' }, { amprocfamily => 'btree/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '1', amproc => 'jsonb_cmp' }, { amprocfamily => 'btree/xid8_ops', amproclefttype => 'xid8', amprocrighttype => 'xid8', amprocnum => '1', amproc => 'xid8cmp' }, { amprocfamily => 'btree/xid8_ops', amproclefttype => 'xid8', amprocrighttype => 'xid8', amprocnum => '4', amproc => 'btequalimage' }, # hash { amprocfamily => 'hash/bpchar_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '1', amproc => 'hashbpchar' }, { amprocfamily => 'hash/bpchar_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '2', amproc => 'hashbpcharextended' }, { amprocfamily => 'hash/char_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '1', amproc => 'hashchar' }, { amprocfamily => 'hash/char_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '2', amproc => 'hashcharextended' }, { amprocfamily => 'hash/date_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '1', amproc => 'hashint4' }, { amprocfamily => 'hash/date_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '2', amproc => 'hashint4extended' }, { amprocfamily => 'hash/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '1', amproc => 'hash_array' }, { amprocfamily => 'hash/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '2', amproc => 'hash_array_extended' }, { amprocfamily => 'hash/float_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '1', amproc => 'hashfloat4' }, { amprocfamily => 'hash/float_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '2', amproc => 'hashfloat4extended' }, { amprocfamily => 'hash/float_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '1', amproc => 'hashfloat8' }, { amprocfamily => 'hash/float_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '2', amproc => 'hashfloat8extended' }, { amprocfamily => 'hash/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '1', amproc => 'hashinet' }, { amprocfamily => 'hash/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '2', amproc => 'hashinetextended' }, { amprocfamily => 'hash/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '1', amproc => 'hashint2' }, { amprocfamily => 'hash/integer_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '2', amproc => 'hashint2extended' }, { amprocfamily => 'hash/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '1', amproc => 'hashint4' }, { amprocfamily => 'hash/integer_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '2', amproc => 'hashint4extended' }, { amprocfamily => 'hash/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '1', amproc => 'hashint8' }, { amprocfamily => 'hash/integer_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '2', amproc => 'hashint8extended' }, { amprocfamily => 'hash/interval_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '1', amproc => 'interval_hash' }, { amprocfamily => 'hash/interval_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '2', amproc => 'interval_hash_extended' }, { amprocfamily => 'hash/macaddr_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '1', amproc => 'hashmacaddr' }, { amprocfamily => 'hash/macaddr_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '2', amproc => 'hashmacaddrextended' }, { amprocfamily => 'hash/oid_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '1', amproc => 'hashoid' }, { amprocfamily => 'hash/oid_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '2', amproc => 'hashoidextended' }, { amprocfamily => 'hash/oidvector_ops', amproclefttype => 'oidvector', amprocrighttype => 'oidvector', amprocnum => '1', amproc => 'hashoidvector' }, { amprocfamily => 'hash/oidvector_ops', amproclefttype => 'oidvector', amprocrighttype => 'oidvector', amprocnum => '2', amproc => 'hashoidvectorextended' }, { amprocfamily => 'hash/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '1', amproc => 'hashtext' }, { amprocfamily => 'hash/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '2', amproc => 'hashtextextended' }, { amprocfamily => 'hash/text_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '1', amproc => 'hashname' }, { amprocfamily => 'hash/text_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '2', amproc => 'hashnameextended' }, { amprocfamily => 'hash/time_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '1', amproc => 'time_hash' }, { amprocfamily => 'hash/time_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '2', amproc => 'time_hash_extended' }, { amprocfamily => 'hash/numeric_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '1', amproc => 'hash_numeric' }, { amprocfamily => 'hash/numeric_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '2', amproc => 'hash_numeric_extended' }, { amprocfamily => 'hash/timestamptz_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'timestamp_hash' }, { amprocfamily => 'hash/timestamptz_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '2', amproc => 'timestamp_hash_extended' }, { amprocfamily => 'hash/timetz_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '1', amproc => 'timetz_hash' }, { amprocfamily => 'hash/timetz_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '2', amproc => 'timetz_hash_extended' }, { amprocfamily => 'hash/timestamp_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'timestamp_hash' }, { amprocfamily => 'hash/timestamp_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '2', amproc => 'timestamp_hash_extended' }, { amprocfamily => 'hash/bool_ops', amproclefttype => 'bool', amprocrighttype => 'bool', amprocnum => '1', amproc => 'hashchar' }, { amprocfamily => 'hash/bool_ops', amproclefttype => 'bool', amprocrighttype => 'bool', amprocnum => '2', amproc => 'hashcharextended' }, { amprocfamily => 'hash/bytea_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '1', amproc => 'hashvarlena' }, { amprocfamily => 'hash/bytea_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '2', amproc => 'hashvarlenaextended' }, { amprocfamily => 'hash/xid_ops', amproclefttype => 'xid', amprocrighttype => 'xid', amprocnum => '1', amproc => 'hashint4' }, { amprocfamily => 'hash/xid_ops', amproclefttype => 'xid', amprocrighttype => 'xid', amprocnum => '2', amproc => 'hashint4extended' }, { amprocfamily => 'hash/xid8_ops', amproclefttype => 'xid8', amprocrighttype => 'xid8', amprocnum => '1', amproc => 'hashint8' }, { amprocfamily => 'hash/xid8_ops', amproclefttype => 'xid8', amprocrighttype => 'xid8', amprocnum => '2', amproc => 'hashint8extended' }, { amprocfamily => 'hash/cid_ops', amproclefttype => 'cid', amprocrighttype => 'cid', amprocnum => '1', amproc => 'hashint4' }, { amprocfamily => 'hash/cid_ops', amproclefttype => 'cid', amprocrighttype => 'cid', amprocnum => '2', amproc => 'hashint4extended' }, { amprocfamily => 'hash/tid_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '1', amproc => 'hashtid' }, { amprocfamily => 'hash/tid_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '2', amproc => 'hashtidextended' }, { amprocfamily => 'hash/text_pattern_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '1', amproc => 'hashtext' }, { amprocfamily => 'hash/text_pattern_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '2', amproc => 'hashtextextended' }, { amprocfamily => 'hash/bpchar_pattern_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '1', amproc => 'hashbpchar' }, { amprocfamily => 'hash/bpchar_pattern_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '2', amproc => 'hashbpcharextended' }, { amprocfamily => 'hash/aclitem_ops', amproclefttype => 'aclitem', amprocrighttype => 'aclitem', amprocnum => '1', amproc => 'hash_aclitem' }, { amprocfamily => 'hash/aclitem_ops', amproclefttype => 'aclitem', amprocrighttype => 'aclitem', amprocnum => '2', amproc => 'hash_aclitem_extended' }, { amprocfamily => 'hash/uuid_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '1', amproc => 'uuid_hash' }, { amprocfamily => 'hash/uuid_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '2', amproc => 'uuid_hash_extended' }, { amprocfamily => 'hash/pg_lsn_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '1', amproc => 'pg_lsn_hash' }, { amprocfamily => 'hash/pg_lsn_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '2', amproc => 'pg_lsn_hash_extended' }, { amprocfamily => 'hash/macaddr8_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '1', amproc => 'hashmacaddr8' }, { amprocfamily => 'hash/macaddr8_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '2', amproc => 'hashmacaddr8extended' }, { amprocfamily => 'hash/enum_ops', amproclefttype => 'anyenum', amprocrighttype => 'anyenum', amprocnum => '1', amproc => 'hashenum' }, { amprocfamily => 'hash/enum_ops', amproclefttype => 'anyenum', amprocrighttype => 'anyenum', amprocnum => '2', amproc => 'hashenumextended' }, { amprocfamily => 'hash/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '1', amproc => 'hash_range' }, { amprocfamily => 'hash/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '2', amproc => 'hash_range_extended' }, { amprocfamily => 'hash/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '1', amproc => 'jsonb_hash' }, { amprocfamily => 'hash/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '2', amproc => 'jsonb_hash_extended' }, # gist { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '1', amproc => 'gist_point_consistent' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '2', amproc => 'gist_box_union' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '3', amproc => 'gist_point_compress' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '5', amproc => 'gist_box_penalty' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '6', amproc => 'gist_box_picksplit' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '7', amproc => 'gist_box_same' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '8', amproc => 'gist_point_distance' }, { amprocfamily => 'gist/point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '9', amproc => 'gist_point_fetch' }, { amprocfamily => 'gist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '1', amproc => 'gist_box_consistent' }, { amprocfamily => 'gist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '2', amproc => 'gist_box_union' }, { amprocfamily => 'gist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '5', amproc => 'gist_box_penalty' }, { amprocfamily => 'gist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '6', amproc => 'gist_box_picksplit' }, { amprocfamily => 'gist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '7', amproc => 'gist_box_same' }, { amprocfamily => 'gist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '8', amproc => 'gist_box_distance' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '1', amproc => 'gist_poly_consistent' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '2', amproc => 'gist_box_union' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '3', amproc => 'gist_poly_compress' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '5', amproc => 'gist_box_penalty' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '6', amproc => 'gist_box_picksplit' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '7', amproc => 'gist_box_same' }, { amprocfamily => 'gist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '8', amproc => 'gist_poly_distance' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '1', amproc => 'gist_circle_consistent' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '2', amproc => 'gist_box_union' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '3', amproc => 'gist_circle_compress' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '5', amproc => 'gist_box_penalty' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '6', amproc => 'gist_box_picksplit' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '7', amproc => 'gist_box_same' }, { amprocfamily => 'gist/circle_ops', amproclefttype => 'circle', amprocrighttype => 'circle', amprocnum => '8', amproc => 'gist_circle_distance' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '1', amproc => 'gtsvector_consistent(internal,tsvector,int2,oid,internal)' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '2', amproc => 'gtsvector_union' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '3', amproc => 'gtsvector_compress' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '4', amproc => 'gtsvector_decompress' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '5', amproc => 'gtsvector_penalty' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '6', amproc => 'gtsvector_picksplit' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '7', amproc => 'gtsvector_same' }, { amprocfamily => 'gist/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '10', amproc => 'gtsvector_options' }, { amprocfamily => 'gist/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '1', amproc => 'gtsquery_consistent(internal,tsquery,int2,oid,internal)' }, { amprocfamily => 'gist/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '2', amproc => 'gtsquery_union' }, { amprocfamily => 'gist/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '3', amproc => 'gtsquery_compress' }, { amprocfamily => 'gist/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '5', amproc => 'gtsquery_penalty' }, { amprocfamily => 'gist/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '6', amproc => 'gtsquery_picksplit' }, { amprocfamily => 'gist/tsquery_ops', amproclefttype => 'tsquery', amprocrighttype => 'tsquery', amprocnum => '7', amproc => 'gtsquery_same' }, { amprocfamily => 'gist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '1', amproc => 'range_gist_consistent' }, { amprocfamily => 'gist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '2', amproc => 'range_gist_union' }, { amprocfamily => 'gist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '5', amproc => 'range_gist_penalty' }, { amprocfamily => 'gist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '6', amproc => 'range_gist_picksplit' }, { amprocfamily => 'gist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '7', amproc => 'range_gist_same' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '1', amproc => 'inet_gist_consistent' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '2', amproc => 'inet_gist_union' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '3', amproc => 'inet_gist_compress' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '5', amproc => 'inet_gist_penalty' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '6', amproc => 'inet_gist_picksplit' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '7', amproc => 'inet_gist_same' }, { amprocfamily => 'gist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '9', amproc => 'inet_gist_fetch' }, # gin { amprocfamily => 'gin/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '2', amproc => 'ginarrayextract(anyarray,internal,internal)' }, { amprocfamily => 'gin/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '3', amproc => 'ginqueryarrayextract' }, { amprocfamily => 'gin/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '4', amproc => 'ginarrayconsistent' }, { amprocfamily => 'gin/array_ops', amproclefttype => 'anyarray', amprocrighttype => 'anyarray', amprocnum => '6', amproc => 'ginarraytriconsistent' }, { amprocfamily => 'gin/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '1', amproc => 'gin_cmp_tslexeme' }, { amprocfamily => 'gin/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '2', amproc => 'gin_extract_tsvector(tsvector,internal,internal)' }, { amprocfamily => 'gin/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '3', amproc => 'gin_extract_tsquery(tsvector,internal,int2,internal,internal,internal,internal)' }, { amprocfamily => 'gin/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '4', amproc => 'gin_tsquery_consistent(internal,int2,tsvector,int4,internal,internal,internal,internal)' }, { amprocfamily => 'gin/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '5', amproc => 'gin_cmp_prefix' }, { amprocfamily => 'gin/tsvector_ops', amproclefttype => 'tsvector', amprocrighttype => 'tsvector', amprocnum => '6', amproc => 'gin_tsquery_triconsistent' }, { amprocfamily => 'gin/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '1', amproc => 'gin_compare_jsonb' }, { amprocfamily => 'gin/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '2', amproc => 'gin_extract_jsonb' }, { amprocfamily => 'gin/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '3', amproc => 'gin_extract_jsonb_query' }, { amprocfamily => 'gin/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '4', amproc => 'gin_consistent_jsonb' }, { amprocfamily => 'gin/jsonb_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '6', amproc => 'gin_triconsistent_jsonb' }, { amprocfamily => 'gin/jsonb_path_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '1', amproc => 'btint4cmp' }, { amprocfamily => 'gin/jsonb_path_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '2', amproc => 'gin_extract_jsonb_path' }, { amprocfamily => 'gin/jsonb_path_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '3', amproc => 'gin_extract_jsonb_query_path' }, { amprocfamily => 'gin/jsonb_path_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '4', amproc => 'gin_consistent_jsonb_path' }, { amprocfamily => 'gin/jsonb_path_ops', amproclefttype => 'jsonb', amprocrighttype => 'jsonb', amprocnum => '6', amproc => 'gin_triconsistent_jsonb_path' }, # sp-gist { amprocfamily => 'spgist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '1', amproc => 'spg_range_quad_config' }, { amprocfamily => 'spgist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '2', amproc => 'spg_range_quad_choose' }, { amprocfamily => 'spgist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '3', amproc => 'spg_range_quad_picksplit' }, { amprocfamily => 'spgist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '4', amproc => 'spg_range_quad_inner_consistent' }, { amprocfamily => 'spgist/range_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '5', amproc => 'spg_range_quad_leaf_consistent' }, { amprocfamily => 'spgist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '1', amproc => 'inet_spg_config' }, { amprocfamily => 'spgist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '2', amproc => 'inet_spg_choose' }, { amprocfamily => 'spgist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '3', amproc => 'inet_spg_picksplit' }, { amprocfamily => 'spgist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '4', amproc => 'inet_spg_inner_consistent' }, { amprocfamily => 'spgist/network_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '5', amproc => 'inet_spg_leaf_consistent' }, { amprocfamily => 'spgist/quad_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '1', amproc => 'spg_quad_config' }, { amprocfamily => 'spgist/quad_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '2', amproc => 'spg_quad_choose' }, { amprocfamily => 'spgist/quad_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '3', amproc => 'spg_quad_picksplit' }, { amprocfamily => 'spgist/quad_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '4', amproc => 'spg_quad_inner_consistent' }, { amprocfamily => 'spgist/quad_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '5', amproc => 'spg_quad_leaf_consistent' }, { amprocfamily => 'spgist/kd_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '1', amproc => 'spg_kd_config' }, { amprocfamily => 'spgist/kd_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '2', amproc => 'spg_kd_choose' }, { amprocfamily => 'spgist/kd_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '3', amproc => 'spg_kd_picksplit' }, { amprocfamily => 'spgist/kd_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '4', amproc => 'spg_kd_inner_consistent' }, { amprocfamily => 'spgist/kd_point_ops', amproclefttype => 'point', amprocrighttype => 'point', amprocnum => '5', amproc => 'spg_quad_leaf_consistent' }, { amprocfamily => 'spgist/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '1', amproc => 'spg_text_config' }, { amprocfamily => 'spgist/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '2', amproc => 'spg_text_choose' }, { amprocfamily => 'spgist/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '3', amproc => 'spg_text_picksplit' }, { amprocfamily => 'spgist/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '4', amproc => 'spg_text_inner_consistent' }, { amprocfamily => 'spgist/text_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '5', amproc => 'spg_text_leaf_consistent' }, { amprocfamily => 'spgist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '1', amproc => 'spg_box_quad_config' }, { amprocfamily => 'spgist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '2', amproc => 'spg_box_quad_choose' }, { amprocfamily => 'spgist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '3', amproc => 'spg_box_quad_picksplit' }, { amprocfamily => 'spgist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '4', amproc => 'spg_box_quad_inner_consistent' }, { amprocfamily => 'spgist/box_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '5', amproc => 'spg_box_quad_leaf_consistent' }, { amprocfamily => 'spgist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '1', amproc => 'spg_bbox_quad_config' }, { amprocfamily => 'spgist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '2', amproc => 'spg_box_quad_choose' }, { amprocfamily => 'spgist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '3', amproc => 'spg_box_quad_picksplit' }, { amprocfamily => 'spgist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '4', amproc => 'spg_box_quad_inner_consistent' }, { amprocfamily => 'spgist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '5', amproc => 'spg_box_quad_leaf_consistent' }, { amprocfamily => 'spgist/poly_ops', amproclefttype => 'polygon', amprocrighttype => 'polygon', amprocnum => '6', amproc => 'spg_poly_quad_compress' }, # BRIN opclasses # minmax bytea { amprocfamily => 'brin/bytea_minmax_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/bytea_minmax_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/bytea_minmax_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/bytea_minmax_ops', amproclefttype => 'bytea', amprocrighttype => 'bytea', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax "char" { amprocfamily => 'brin/char_minmax_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/char_minmax_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/char_minmax_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/char_minmax_ops', amproclefttype => 'char', amprocrighttype => 'char', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax name { amprocfamily => 'brin/name_minmax_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/name_minmax_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/name_minmax_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/name_minmax_ops', amproclefttype => 'name', amprocrighttype => 'name', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax integer: int2, int4, int8 { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int8', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int2', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int2', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int2', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int2', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int4', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int4', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int4', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int8', amprocrighttype => 'int4', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int2', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int8', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int8', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int8', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int8', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int4', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int4', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int4', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int2', amprocrighttype => 'int4', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int4', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int8', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int8', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int8', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int8', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int2', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int2', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int2', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/integer_minmax_ops', amproclefttype => 'int4', amprocrighttype => 'int2', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax text { amprocfamily => 'brin/text_minmax_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/text_minmax_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/text_minmax_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/text_minmax_ops', amproclefttype => 'text', amprocrighttype => 'text', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax oid { amprocfamily => 'brin/oid_minmax_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/oid_minmax_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/oid_minmax_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/oid_minmax_ops', amproclefttype => 'oid', amprocrighttype => 'oid', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax tid { amprocfamily => 'brin/tid_minmax_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/tid_minmax_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/tid_minmax_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/tid_minmax_ops', amproclefttype => 'tid', amprocrighttype => 'tid', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax float { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float4', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float8', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float8', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float8', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float4', amprocrighttype => 'float8', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float8', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float4', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float4', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float4', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/float_minmax_ops', amproclefttype => 'float8', amprocrighttype => 'float4', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax macaddr { amprocfamily => 'brin/macaddr_minmax_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/macaddr_minmax_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/macaddr_minmax_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/macaddr_minmax_ops', amproclefttype => 'macaddr', amprocrighttype => 'macaddr', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax macaddr8 { amprocfamily => 'brin/macaddr8_minmax_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/macaddr8_minmax_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/macaddr8_minmax_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/macaddr8_minmax_ops', amproclefttype => 'macaddr8', amprocrighttype => 'macaddr8', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax inet { amprocfamily => 'brin/network_minmax_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/network_minmax_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/network_minmax_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/network_minmax_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '4', amproc => 'brin_minmax_union' }, # inclusion inet { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '1', amproc => 'brin_inclusion_opcinfo' }, { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '2', amproc => 'brin_inclusion_add_value' }, { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '3', amproc => 'brin_inclusion_consistent' }, { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '4', amproc => 'brin_inclusion_union' }, { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '11', amproc => 'inet_merge' }, { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '12', amproc => 'inet_same_family' }, { amprocfamily => 'brin/network_inclusion_ops', amproclefttype => 'inet', amprocrighttype => 'inet', amprocnum => '13', amproc => 'network_supeq' }, # minmax character { amprocfamily => 'brin/bpchar_minmax_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/bpchar_minmax_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/bpchar_minmax_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/bpchar_minmax_ops', amproclefttype => 'bpchar', amprocrighttype => 'bpchar', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax time without time zone { amprocfamily => 'brin/time_minmax_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/time_minmax_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/time_minmax_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/time_minmax_ops', amproclefttype => 'time', amprocrighttype => 'time', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax datetime (date, timestamp, timestamptz) { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamp', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamptz', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamptz', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'timestamptz', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'date', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'date', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'date', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamp', amprocrighttype => 'date', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamptz', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamp', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamp', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'timestamp', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'date', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'date', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'date', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'timestamptz', amprocrighttype => 'date', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'date', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamp', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamp', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamp', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamp', amprocnum => '4', amproc => 'brin_minmax_union' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamptz', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamptz', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamptz', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/datetime_minmax_ops', amproclefttype => 'date', amprocrighttype => 'timestamptz', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax interval { amprocfamily => 'brin/interval_minmax_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/interval_minmax_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/interval_minmax_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/interval_minmax_ops', amproclefttype => 'interval', amprocrighttype => 'interval', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax time with time zone { amprocfamily => 'brin/timetz_minmax_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/timetz_minmax_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/timetz_minmax_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/timetz_minmax_ops', amproclefttype => 'timetz', amprocrighttype => 'timetz', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax bit { amprocfamily => 'brin/bit_minmax_ops', amproclefttype => 'bit', amprocrighttype => 'bit', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/bit_minmax_ops', amproclefttype => 'bit', amprocrighttype => 'bit', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/bit_minmax_ops', amproclefttype => 'bit', amprocrighttype => 'bit', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/bit_minmax_ops', amproclefttype => 'bit', amprocrighttype => 'bit', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax bit varying { amprocfamily => 'brin/varbit_minmax_ops', amproclefttype => 'varbit', amprocrighttype => 'varbit', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/varbit_minmax_ops', amproclefttype => 'varbit', amprocrighttype => 'varbit', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/varbit_minmax_ops', amproclefttype => 'varbit', amprocrighttype => 'varbit', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/varbit_minmax_ops', amproclefttype => 'varbit', amprocrighttype => 'varbit', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax numeric { amprocfamily => 'brin/numeric_minmax_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/numeric_minmax_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/numeric_minmax_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/numeric_minmax_ops', amproclefttype => 'numeric', amprocrighttype => 'numeric', amprocnum => '4', amproc => 'brin_minmax_union' }, # minmax uuid { amprocfamily => 'brin/uuid_minmax_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/uuid_minmax_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/uuid_minmax_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/uuid_minmax_ops', amproclefttype => 'uuid', amprocrighttype => 'uuid', amprocnum => '4', amproc => 'brin_minmax_union' }, # inclusion range types { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '1', amproc => 'brin_inclusion_opcinfo' }, { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '2', amproc => 'brin_inclusion_add_value' }, { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '3', amproc => 'brin_inclusion_consistent' }, { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '4', amproc => 'brin_inclusion_union' }, { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '11', amproc => 'range_merge' }, { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '13', amproc => 'range_contains' }, { amprocfamily => 'brin/range_inclusion_ops', amproclefttype => 'anyrange', amprocrighttype => 'anyrange', amprocnum => '14', amproc => 'isempty' }, # minmax pg_lsn { amprocfamily => 'brin/pg_lsn_minmax_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '1', amproc => 'brin_minmax_opcinfo' }, { amprocfamily => 'brin/pg_lsn_minmax_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '2', amproc => 'brin_minmax_add_value' }, { amprocfamily => 'brin/pg_lsn_minmax_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '3', amproc => 'brin_minmax_consistent' }, { amprocfamily => 'brin/pg_lsn_minmax_ops', amproclefttype => 'pg_lsn', amprocrighttype => 'pg_lsn', amprocnum => '4', amproc => 'brin_minmax_union' }, # inclusion box { amprocfamily => 'brin/box_inclusion_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '1', amproc => 'brin_inclusion_opcinfo' }, { amprocfamily => 'brin/box_inclusion_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '2', amproc => 'brin_inclusion_add_value' }, { amprocfamily => 'brin/box_inclusion_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '3', amproc => 'brin_inclusion_consistent' }, { amprocfamily => 'brin/box_inclusion_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '4', amproc => 'brin_inclusion_union' }, { amprocfamily => 'brin/box_inclusion_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '11', amproc => 'bound_box' }, { amprocfamily => 'brin/box_inclusion_ops', amproclefttype => 'box', amprocrighttype => 'box', amprocnum => '13', amproc => 'box_contain' }, ]