Operator Families
Version coverage matrixDefinitions for PostgreSQL 18
Reading PG 18·Select a recorded version
BRIN operator class for bit; member of bit_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for box; member of box_inclusion_ops.
BRIN operator family containing 1 classes, 13 operator strategies and 6 support functions in this source build.
BRIN operator class for bpchar; member of bpchar_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for bpchar; member of bpchar_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for bytea; member of bytea_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for bytea; member of bytea_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for char; member of char_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for char; member of char_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for date; member of datetime_bloom_ops.
BRIN operator class for date; member of datetime_minmax_multi_ops.
BRIN operator class for date; member of datetime_minmax_ops.
BRIN operator family containing 3 classes, 3 operator strategies and 18 support functions in this source build.
BRIN operator family containing 3 classes, 45 operator strategies and 18 support functions in this source build.
BRIN operator family containing 3 classes, 45 operator strategies and 12 support functions in this source build.
BRIN operator class for float4; member of float_bloom_ops.
BRIN operator class for float4; member of float_minmax_multi_ops.
BRIN operator class for float4; member of float_minmax_ops.
BRIN operator class for float8; member of float_bloom_ops.
BRIN operator class for float8; member of float_minmax_multi_ops.
BRIN operator class for float8; member of float_minmax_ops.
BRIN operator family containing 2 classes, 2 operator strategies and 12 support functions in this source build.
BRIN operator family containing 2 classes, 20 operator strategies and 12 support functions in this source build.
BRIN operator family containing 2 classes, 20 operator strategies and 8 support functions in this source build.
BRIN operator class for inet; member of network_bloom_ops.
BRIN operator class for inet; member of network_inclusion_ops.
BRIN operator class for inet; member of network_minmax_multi_ops.
BRIN operator class for inet; member of network_minmax_ops.
BRIN operator class for int2; member of integer_bloom_ops.
BRIN operator class for int2; member of integer_minmax_multi_ops.
BRIN operator class for int2; member of integer_minmax_ops.
BRIN operator class for int4; member of integer_bloom_ops.
BRIN operator class for int4; member of integer_minmax_multi_ops.
BRIN operator class for int4; member of integer_minmax_ops.
BRIN operator class for int8; member of integer_bloom_ops.
BRIN operator class for int8; member of integer_minmax_multi_ops.
BRIN operator class for int8; member of integer_minmax_ops.
BRIN operator family containing 3 classes, 3 operator strategies and 18 support functions in this source build.
BRIN operator family containing 3 classes, 45 operator strategies and 18 support functions in this source build.
BRIN operator family containing 3 classes, 45 operator strategies and 12 support functions in this source build.
BRIN operator class for interval; member of interval_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for interval; member of interval_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for interval; member of interval_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for macaddr8; member of macaddr8_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for macaddr8; member of macaddr8_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for macaddr8; member of macaddr8_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for macaddr; member of macaddr_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for macaddr; member of macaddr_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for macaddr; member of macaddr_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for name; member of name_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for name; member of name_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator family containing 1 classes, 6 operator strategies and 7 support functions in this source build.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for numeric; member of numeric_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for numeric; member of numeric_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for numeric; member of numeric_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for oid; member of oid_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for oid; member of oid_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for oid; member of oid_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for pg_lsn; member of pg_lsn_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for pg_lsn; member of pg_lsn_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for pg_lsn; member of pg_lsn_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for anyrange; member of range_inclusion_ops.
BRIN operator family containing 1 classes, 14 operator strategies and 7 support functions in this source build.
BRIN operator class for text; member of text_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for text; member of text_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for tid; member of tid_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for tid; member of tid_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for tid; member of tid_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for time; member of time_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for time; member of time_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for time; member of time_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for timestamp; member of datetime_bloom_ops.
BRIN operator class for timestamp; member of datetime_minmax_multi_ops.
BRIN operator class for timestamp; member of datetime_minmax_ops.
BRIN operator class for timestamptz; member of datetime_bloom_ops.
BRIN operator class for timestamptz; member of datetime_minmax_multi_ops.
BRIN operator class for timestamptz; member of datetime_minmax_ops.
BRIN operator class for timetz; member of timetz_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for timetz; member of timetz_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for timetz; member of timetz_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for uuid; member of uuid_bloom_ops.
BRIN operator family containing 1 classes, 1 operator strategies and 6 support functions in this source build.
BRIN operator class for uuid; member of uuid_minmax_multi_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 6 support functions in this source build.
BRIN operator class for uuid; member of uuid_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
BRIN operator class for varbit; member of varbit_minmax_ops.
BRIN operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
B-tree operator class for anyarray; member of array_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for bit; member of bit_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for bool; member of bool_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for bpchar; member of bpchar_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for bpchar; member of bpchar_pattern_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for bytea; member of bytea_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for char; member of char_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for inet; member of network_ops.
B-tree operator class for date; member of datetime_ops.
B-tree operator family containing 3 classes, 45 operator strategies and 21 support functions in this source build.
B-tree operator class for anyenum; member of enum_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for float4; member of float_ops.
B-tree operator class for float8; member of float_ops.
B-tree operator family containing 2 classes, 20 operator strategies and 8 support functions in this source build.
B-tree operator class for inet; member of network_ops.
B-tree operator class for int2; member of integer_ops.
B-tree operator class for int4; member of integer_ops.
B-tree operator class for int8; member of integer_ops.
B-tree operator family containing 3 classes, 45 operator strategies and 25 support functions in this source build.
B-tree operator class for interval; member of interval_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for jsonb; member of jsonb_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for macaddr8; member of macaddr8_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for macaddr; member of macaddr_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for money; member of money_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for anymultirange; member of multirange_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for name; member of text_ops.
B-tree operator family containing 2 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for numeric; member of numeric_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for oid; member of oid_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
B-tree operator class for oidvector; member of oidvector_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for pg_lsn; member of pg_lsn_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for anyrange; member of range_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for record; member of record_image_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for record; member of record_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for text; member of text_ops.
B-tree operator family containing 3 classes, 20 operator strategies and 8 support functions in this source build.
B-tree operator class for text; member of text_pattern_ops.
B-tree operator family containing 2 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for tid; member of tid_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for time; member of time_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for timestamp; member of datetime_ops.
B-tree operator class for timestamptz; member of datetime_ops.
B-tree operator class for timetz; member of timetz_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.
B-tree operator class for tsquery; member of tsquery_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for tsvector; member of tsvector_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.
B-tree operator class for uuid; member of uuid_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.
B-tree operator class for varbit; member of varbit_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
B-tree operator class for text; member of text_ops.
B-tree operator class for text; member of text_pattern_ops.
B-tree operator class for xid8; member of xid8_ops.
B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.
GIN operator class for anyarray; member of array_ops.
GIN operator family containing 1 classes, 4 operator strategies and 4 support functions in this source build.
GIN operator class for jsonb; member of jsonb_ops.
GIN operator family containing 1 classes, 6 operator strategies and 5 support functions in this source build.
GIN operator class for jsonb; member of jsonb_path_ops.
GIN operator family containing 1 classes, 3 operator strategies and 5 support functions in this source build.
GIN operator class for tsvector; member of tsvector_ops.
GIN operator family containing 1 classes, 2 operator strategies and 6 support functions in this source build.
GiST operator class for box; member of box_ops.
GiST operator family containing 1 classes, 13 operator strategies and 7 support functions in this source build.
GiST operator class for circle; member of circle_ops.
GiST operator family containing 1 classes, 13 operator strategies and 8 support functions in this source build.
GiST operator class for inet; member of network_ops.
GiST operator class for anymultirange; member of multirange_ops.
GiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build.
GiST operator family containing 1 classes, 11 operator strategies and 8 support functions in this source build.
GiST operator class for point; member of point_ops.
GiST operator family containing 1 classes, 11 operator strategies and 9 support functions in this source build.
GiST operator class for polygon; member of poly_ops.
GiST operator family containing 1 classes, 13 operator strategies and 8 support functions in this source build.
GiST operator class for anyrange; member of range_ops.
GiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build.
GiST operator class for tsquery; member of tsquery_ops.
GiST operator family containing 1 classes, 2 operator strategies and 6 support functions in this source build.
GiST operator class for tsvector; member of tsvector_ops.
GiST operator family containing 1 classes, 1 operator strategies and 8 support functions in this source build.
Hash operator class for aclitem; member of aclitem_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for anyarray; member of array_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for bool; member of bool_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for bpchar; member of bpchar_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for bpchar; member of bpchar_pattern_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for bytea; member of bytea_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for char; member of char_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for cid; member of cid_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for inet; member of network_ops.
Hash operator class for date; member of date_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for anyenum; member of enum_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for float4; member of float_ops.
Hash operator class for float8; member of float_ops.
Hash operator family containing 2 classes, 4 operator strategies and 4 support functions in this source build.
Hash operator class for inet; member of network_ops.
Hash operator class for int2; member of integer_ops.
Hash operator class for int4; member of integer_ops.
Hash operator class for int8; member of integer_ops.
Hash operator family containing 3 classes, 9 operator strategies and 6 support functions in this source build.
Hash operator class for interval; member of interval_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for jsonb; member of jsonb_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for macaddr8; member of macaddr8_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for macaddr; member of macaddr_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for anymultirange; member of multirange_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for name; member of text_ops.
Hash operator family containing 2 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for numeric; member of numeric_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for oid; member of oid_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for oidvector; member of oidvector_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for pg_lsn; member of pg_lsn_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for anyrange; member of range_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for record; member of record_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for text; member of text_ops.
Hash operator family containing 3 classes, 4 operator strategies and 4 support functions in this source build.
Hash operator class for text; member of text_pattern_ops.
Hash operator family containing 2 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for tid; member of tid_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for time; member of time_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for timestamp; member of timestamp_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for timestamptz; member of timestamptz_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for timetz; member of timetz_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for uuid; member of uuid_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for text; member of text_ops.
Hash operator class for text; member of text_pattern_ops.
Hash operator class for xid8; member of xid8_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
Hash operator class for xid; member of xid_ops.
Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.
SP-GiST operator class for box; member of box_ops.
SP-GiST operator family containing 1 classes, 13 operator strategies and 5 support functions in this source build.
SP-GiST operator class for inet; member of network_ops.
SP-GiST operator class for point; member of kd_point_ops.
SP-GiST operator family containing 1 classes, 9 operator strategies and 5 support functions in this source build.
SP-GiST operator family containing 1 classes, 11 operator strategies and 5 support functions in this source build.
SP-GiST operator class for polygon; member of poly_ops.
SP-GiST operator family containing 1 classes, 13 operator strategies and 6 support functions in this source build.
SP-GiST operator class for point; member of quad_point_ops.
SP-GiST operator family containing 1 classes, 9 operator strategies and 5 support functions in this source build.
SP-GiST operator class for anyrange; member of range_ops.
SP-GiST operator family containing 1 classes, 10 operator strategies and 5 support functions in this source build.
SP-GiST operator class for text; member of text_ops.
SP-GiST operator family containing 1 classes, 10 operator strategies and 5 support functions in this source build.