Wiki / Operator Families

Index operator classes and families, strategy operators and support functions.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsB-tree classes (48)B-tree families (40)BRIN classes (74)BRIN families (59)GIN classes (4)GIN families (4)GiST classes (9)GiST families (10)Hash classes (44)Hash families (38)SP-GiST classes (7)SP-GiST families (7) Apply

344 entries; 323 recorded in PostgreSQL 18.6.

• btree/abstime_ops (class) B-tree classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/array_ops (class) B-tree classes

  B-tree operator class for anyarray; member of array_ops.

  1011121314151617181920
• btree/bit_ops (class) B-tree classes

  B-tree operator class for bit; member of bit_ops.

  1011121314151617181920
• btree/bool_ops (class) B-tree classes

  B-tree operator class for bool; member of bool_ops.

  1011121314151617181920
• btree/bpchar_ops (class) B-tree classes

  B-tree operator class for bpchar; member of bpchar_ops.

  1011121314151617181920
• btree/bpchar_pattern_ops (class) B-tree classes

  B-tree operator class for bpchar; member of bpchar_pattern_ops.

  1011121314151617181920
• btree/bytea_ops (class) B-tree classes

  B-tree operator class for bytea; member of bytea_ops.

  1011121314151617181920
• btree/char_ops (class) B-tree classes

  B-tree operator class for char; member of char_ops.

  1011121314151617181920
• btree/cidr_ops (class) B-tree classes

  B-tree operator class for inet; member of network_ops.

  1011121314151617181920
• btree/date_ops (class) B-tree classes

  B-tree operator class for date; member of datetime_ops.

  1011121314151617181920
• btree/enum_ops (class) B-tree classes

  B-tree operator class for anyenum; member of enum_ops.

  1011121314151617181920
• btree/float4_ops (class) B-tree classes

  B-tree operator class for float4; member of float_ops.

  1011121314151617181920
• btree/float8_ops (class) B-tree classes

  B-tree operator class for float8; member of float_ops.

  1011121314151617181920
• btree/inet_ops (class) B-tree classes

  B-tree operator class for inet; member of network_ops.

  1011121314151617181920
• btree/int2_ops (class) B-tree classes

  B-tree operator class for int2; member of integer_ops.

  1011121314151617181920
• btree/int4_ops (class) B-tree classes

  B-tree operator class for int4; member of integer_ops.

  1011121314151617181920
• btree/int8_ops (class) B-tree classes

  B-tree operator class for int8; member of integer_ops.

  1011121314151617181920
• btree/interval_ops (class) B-tree classes

  B-tree operator class for interval; member of interval_ops.

  1011121314151617181920
• btree/jsonb_ops (class) B-tree classes

  B-tree operator class for jsonb; member of jsonb_ops.

  1011121314151617181920
• btree/macaddr8_ops (class) B-tree classes

  B-tree operator class for macaddr8; member of macaddr8_ops.

  1011121314151617181920
• btree/macaddr_ops (class) B-tree classes

  B-tree operator class for macaddr; member of macaddr_ops.

  1011121314151617181920
• btree/money_ops (class) B-tree classes

  B-tree operator class for money; member of money_ops.

  1011121314151617181920
• btree/multirange_ops (class) B-tree classes

  B-tree operator class for anymultirange; member of multirange_ops.

  1011121314151617181920
• btree/name_ops (class) B-tree classes

  B-tree operator class for name; member of text_ops.

  1011121314151617181920
• btree/numeric_ops (class) B-tree classes

  B-tree operator class for numeric; member of numeric_ops.

  1011121314151617181920
• btree/oid8_ops (class) B-tree classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/oid_ops (class) B-tree classes

  B-tree operator class for oid; member of oid_ops.

  1011121314151617181920
• btree/oidvector_ops (class) B-tree classes

  B-tree operator class for oidvector; member of oidvector_ops.

  1011121314151617181920
• btree/pg_lsn_ops (class) B-tree classes

  B-tree operator class for pg_lsn; member of pg_lsn_ops.

  1011121314151617181920
• btree/range_ops (class) B-tree classes

  B-tree operator class for anyrange; member of range_ops.

  1011121314151617181920
• btree/record_image_ops (class) B-tree classes

  B-tree operator class for record; member of record_image_ops.

  1011121314151617181920
• btree/record_ops (class) B-tree classes

  B-tree operator class for record; member of record_ops.

  1011121314151617181920
• btree/reltime_ops (class) B-tree classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/text_ops (class) B-tree classes

  B-tree operator class for text; member of text_ops.

  1011121314151617181920
• btree/text_pattern_ops (class) B-tree classes

  B-tree operator class for text; member of text_pattern_ops.

  1011121314151617181920
• btree/tid_ops (class) B-tree classes

  B-tree operator class for tid; member of tid_ops.

  1011121314151617181920
• btree/time_ops (class) B-tree classes

  B-tree operator class for time; member of time_ops.

  1011121314151617181920
• btree/timestamp_ops (class) B-tree classes

  B-tree operator class for timestamp; member of datetime_ops.

  1011121314151617181920
• btree/timestamptz_ops (class) B-tree classes

  B-tree operator class for timestamptz; member of datetime_ops.

  1011121314151617181920
• btree/timetz_ops (class) B-tree classes

  B-tree operator class for timetz; member of timetz_ops.

  1011121314151617181920
• btree/tinterval_ops (class) B-tree classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/tsquery_ops (class) B-tree classes

  B-tree operator class for tsquery; member of tsquery_ops.

  1011121314151617181920
• btree/tsvector_ops (class) B-tree classes

  B-tree operator class for tsvector; member of tsvector_ops.

  1011121314151617181920
• btree/uuid_ops (class) B-tree classes

  B-tree operator class for uuid; member of uuid_ops.

  1011121314151617181920
• btree/varbit_ops (class) B-tree classes

  B-tree operator class for varbit; member of varbit_ops.

  1011121314151617181920
• btree/varchar_ops (class) B-tree classes

  B-tree operator class for text; member of text_ops.

  1011121314151617181920
• btree/varchar_pattern_ops (class) B-tree classes

  B-tree operator class for text; member of text_pattern_ops.

  1011121314151617181920
• btree/xid8_ops (class) B-tree classes

  B-tree operator class for xid8; member of xid8_ops.

  1011121314151617181920
• btree/abstime_ops (family) B-tree families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/array_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/bit_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/bool_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/bpchar_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/bpchar_pattern_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/bytea_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/char_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/datetime_ops (family) B-tree families

  B-tree operator family containing 3 classes, 45 operator strategies and 21 support functions in this source build.

  1011121314151617181920
• btree/enum_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/float_ops (family) B-tree families

  B-tree operator family containing 2 classes, 20 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• btree/integer_ops (family) B-tree families

  B-tree operator family containing 3 classes, 45 operator strategies and 25 support functions in this source build.

  1011121314151617181920
• btree/interval_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/jsonb_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/macaddr8_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/macaddr_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/money_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/multirange_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/name_ops (family) B-tree families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/network_ops (family) B-tree families

  B-tree operator family containing 2 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/numeric_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/oid8_ops (family) B-tree families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/oid_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• btree/oidvector_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/pg_lsn_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/range_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/record_image_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/record_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/reltime_ops (family) B-tree families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/text_ops (family) B-tree families

  B-tree operator family containing 3 classes, 20 operator strategies and 8 support functions in this source build.

  1011121314151617181920
• btree/text_pattern_ops (family) B-tree families

  B-tree operator family containing 2 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/tid_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/time_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/timetz_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build.

  1011121314151617181920
• btree/tinterval_ops (family) B-tree families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• btree/tsquery_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/tsvector_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build.

  1011121314151617181920
• btree/uuid_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• btree/varbit_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• btree/xid8_ops (family) B-tree families

  B-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• brin/abstime_minmax_ops (class) BRIN classes not in 18

  Not recorded in the selected version.

  1011121314151617181920
• brin/bit_minmax_ops (class) BRIN classes

  BRIN operator class for bit; member of bit_minmax_ops.

  1011121314151617181920
• brin/box_inclusion_ops (class) BRIN classes

  BRIN operator class for box; member of box_inclusion_ops.

  1011121314151617181920
• brin/bpchar_bloom_ops (class) BRIN classes

  BRIN operator class for bpchar; member of bpchar_bloom_ops.

  1011121314151617181920
• brin/bpchar_minmax_ops (class) BRIN classes

  BRIN operator class for bpchar; member of bpchar_minmax_ops.

  1011121314151617181920
• brin/bytea_bloom_ops (class) BRIN classes

  BRIN operator class for bytea; member of bytea_bloom_ops.

  1011121314151617181920
• brin/bytea_minmax_ops (class) BRIN classes

  BRIN operator class for bytea; member of bytea_minmax_ops.

  1011121314151617181920
• brin/char_bloom_ops (class) BRIN classes

  BRIN operator class for char; member of char_bloom_ops.

  1011121314151617181920
• brin/char_minmax_ops (class) BRIN classes

  BRIN operator class for char; member of char_minmax_ops.

  1011121314151617181920
• brin/date_bloom_ops (class) BRIN classes

  BRIN operator class for date; member of datetime_bloom_ops.

  1011121314151617181920
• brin/date_minmax_multi_ops (class) BRIN classes

  BRIN operator class for date; member of datetime_minmax_multi_ops.

  1011121314151617181920
• brin/date_minmax_ops (class) BRIN classes

  BRIN operator class for date; member of datetime_minmax_ops.

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

Reading this collection

Classes and families are separate identities. Family operators include cross-type members; strategy and support-function numbers have meanings specific to the index method. Extension-created objects are outside the core inventory.