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.

• hash/cid_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/date_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/enum_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/float_ops (family) Hash families

  Hash operator family containing 2 classes, 4 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• hash/integer_ops (family) Hash families

  Hash operator family containing 3 classes, 9 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• hash/interval_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/jsonb_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/macaddr8_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/macaddr_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/multirange_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/name_ops (family) Hash families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/network_ops (family) Hash families

  Hash operator family containing 2 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/numeric_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/oid8_ops (family) Hash families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/oid_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/oidvector_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/pg_lsn_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/range_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/record_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/reltime_ops (family) Hash families not in 18

  Not recorded in the selected version.

  1011121314151617181920
• hash/text_ops (family) Hash families

  Hash operator family containing 3 classes, 4 operator strategies and 4 support functions in this source build.

  1011121314151617181920
• hash/text_pattern_ops (family) Hash families

  Hash operator family containing 2 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/tid_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/time_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/timestamp_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/timestamptz_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/timetz_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/uuid_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/xid8_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• hash/xid_ops (family) Hash families

  Hash operator family containing 1 classes, 1 operator strategies and 2 support functions in this source build.

  1011121314151617181920
• spgist/box_ops (class) SP-GiST classes

  SP-GiST operator class for box; member of box_ops.

  1011121314151617181920
• spgist/inet_ops (class) SP-GiST classes

  SP-GiST operator class for inet; member of network_ops.

  1011121314151617181920
• spgist/kd_point_ops (class) SP-GiST classes

  SP-GiST operator class for point; member of kd_point_ops.

  1011121314151617181920
• spgist/poly_ops (class) SP-GiST classes

  SP-GiST operator class for polygon; member of poly_ops.

  1011121314151617181920
• spgist/quad_point_ops (class) SP-GiST classes

  SP-GiST operator class for point; member of quad_point_ops.

  1011121314151617181920
• spgist/range_ops (class) SP-GiST classes

  SP-GiST operator class for anyrange; member of range_ops.

  1011121314151617181920
• spgist/text_ops (class) SP-GiST classes

  SP-GiST operator class for text; member of text_ops.

  1011121314151617181920
• spgist/box_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 13 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• spgist/kd_point_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 9 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• spgist/network_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 11 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• spgist/poly_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 13 operator strategies and 6 support functions in this source build.

  1011121314151617181920
• spgist/quad_point_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 9 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• spgist/range_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 10 operator strategies and 5 support functions in this source build.

  1011121314151617181920
• spgist/text_ops (family) SP-GiST families

  SP-GiST operator family containing 1 classes, 10 operator strategies and 5 support functions in this source build.

  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.