Wiki / Operators

Operator overloads with operand and result types, implementation functions and index membership.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsBit strings (19)Boolean (6)Character strings (73)Date and time (134)Geometric (179)Internal and special-purpose (10)JSON (30)Network addresses (17)Numeric (214)Object and transaction identifiers (29)Other built-in types (43)Pseudo-types (88)Text search (23) Apply

865 entries; 799 recorded in PostgreSQL 18.6.

• <>(anyrange,anyrange) Pseudo-types

  not equal

  1011121314151617181920
• <>(record,record) Pseudo-types

  not equal

  1011121314151617181920
• <@(anyarray,anyarray) Pseudo-types

  is contained by

  1011121314151617181920
• <@(anyelement,anymultirange) Pseudo-types

  is contained by

  1011121314151617181920
• <@(anyelement,anyrange) Pseudo-types

  is contained by

  1011121314151617181920
• <@(anymultirange,anymultirange) Pseudo-types

  is contained by

  1011121314151617181920
• <@(anymultirange,anyrange) Pseudo-types

  is contained by

  1011121314151617181920
• <@(anyrange,anymultirange) Pseudo-types

  is contained by

  1011121314151617181920
• <@(anyrange,anyrange) Pseudo-types

  is contained by

  1011121314151617181920
• =(anyarray,anyarray) Pseudo-types

  equal

  1011121314151617181920
• =(anyenum,anyenum) Pseudo-types

  equal

  1011121314151617181920
• =(anymultirange,anymultirange) Pseudo-types

  equal

  1011121314151617181920
• =(anyrange,anyrange) Pseudo-types

  equal

  1011121314151617181920
• =(record,record) Pseudo-types

  equal

  1011121314151617181920
• >(anyarray,anyarray) Pseudo-types

  greater than

  1011121314151617181920
• >(anyenum,anyenum) Pseudo-types

  greater than

  1011121314151617181920
• >(anymultirange,anymultirange) Pseudo-types

  greater than

  1011121314151617181920
• >(anyrange,anyrange) Pseudo-types

  greater than

  1011121314151617181920
• >(record,record) Pseudo-types

  greater than

  1011121314151617181920
• >=(anyarray,anyarray) Pseudo-types

  greater than or equal

  1011121314151617181920
• >=(anyenum,anyenum) Pseudo-types

  greater than or equal

  1011121314151617181920
• >=(anymultirange,anymultirange) Pseudo-types

  greater than or equal

  1011121314151617181920
• >=(anyrange,anyrange) Pseudo-types

  greater than or equal

  1011121314151617181920
• >=(record,record) Pseudo-types

  greater than or equal

  1011121314151617181920
• >>(anymultirange,anymultirange) Pseudo-types

  is right of

  1011121314151617181920
• >>(anymultirange,anyrange) Pseudo-types

  is right of

  1011121314151617181920
• >>(anyrange,anymultirange) Pseudo-types

  is right of

  1011121314151617181920
• >>(anyrange,anyrange) Pseudo-types

  is right of

  1011121314151617181920
• @>(anyarray,anyarray) Pseudo-types

  contains

  1011121314151617181920
• @>(anymultirange,anyelement) Pseudo-types

  contains

  1011121314151617181920
• @>(anymultirange,anymultirange) Pseudo-types

  contains

  1011121314151617181920
• @>(anymultirange,anyrange) Pseudo-types

  contains

  1011121314151617181920
• @>(anyrange,anyelement) Pseudo-types

  contains

  1011121314151617181920
• @>(anyrange,anymultirange) Pseudo-types

  contains

  1011121314151617181920
• @>(anyrange,anyrange) Pseudo-types

  contains

  1011121314151617181920
• ||(anyarray,anyarray) Pseudo-types not in 18

  Not recorded in the selected version.

  1011121314151617181920
• ||(anyarray,anyelement) Pseudo-types not in 18

  Not recorded in the selected version.

  1011121314151617181920
• ||(anycompatible,anycompatiblearray) Pseudo-types

  prepend element onto front of array

  1011121314151617181920
• ||(anycompatiblearray,anycompatible) Pseudo-types

  append element onto end of array

  1011121314151617181920
• ||(anycompatiblearray,anycompatiblearray) Pseudo-types

  concatenate

  1011121314151617181920
• ||(anyelement,anyarray) Pseudo-types not in 18

  Not recorded in the selected version.

  1011121314151617181920
• ||(anynonarray,text) Pseudo-types

  concatenate

  1011121314151617181920
• !!(none,tsquery) Text search

  NOT tsquery

  1011121314151617181920
• &&(tsquery,tsquery) Text search

  AND-concatenate

  1011121314151617181920
• <(tsquery,tsquery) Text search

  less than

  1011121314151617181920
• <(tsvector,tsvector) Text search

  less than

  1011121314151617181920
• <->(tsquery,tsquery) Text search

  phrase-concatenate

  1011121314151617181920
• <=(tsquery,tsquery) Text search

  less than or equal

  1011121314151617181920
• <=(tsvector,tsvector) Text search

  less than or equal

  1011121314151617181920
• <>(tsquery,tsquery) Text search

  not equal

  1011121314151617181920
• <>(tsvector,tsvector) Text search

  not equal

  1011121314151617181920
• <@(tsquery,tsquery) Text search

  is contained by

  1011121314151617181920
• =(tsquery,tsquery) Text search

  equal

  1011121314151617181920
• =(tsvector,tsvector) Text search

  equal

  1011121314151617181920
• >(tsquery,tsquery) Text search

  greater than

  1011121314151617181920
• >(tsvector,tsvector) Text search

  greater than

  1011121314151617181920
• >=(tsquery,tsquery) Text search

  greater than or equal

  1011121314151617181920
• >=(tsvector,tsvector) Text search

  greater than or equal

  1011121314151617181920
• @>(tsquery,tsquery) Text search

  contains

  1011121314151617181920
• @@(tsquery,tsvector) Text search

  text search match

  1011121314151617181920
• @@(tsvector,tsquery) Text search

  text search match

  1011121314151617181920
• @@@(tsquery,tsvector) Text search

  deprecated, use @@ instead

  1011121314151617181920
• @@@(tsvector,tsquery) Text search

  deprecated, use @@ instead

  1011121314151617181920
• ||(tsquery,tsquery) Text search

  OR-concatenate

  1011121314151617181920
• ||(tsvector,tsvector) Text search

  concatenate

  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

Every core bootstrap overload in the sampled builds has its own operand signature. Operator-family membership identifies a specific strategy or ordering purpose; it does not guarantee that an arbitrary query can use an index.