Wiki / Operators
Operators
Compare versionsOperator overloads with operand and result types, implementation functions and index membership.
Reading PostgreSQL 18.6.
865 entries; 799 recorded in PostgreSQL 18.6.
-
=(xid,int4) Object and transaction identifiers
equal
-
=(xid,xid) Object and transaction identifiers
equal
-
=(xid8,xid8) Object and transaction identifiers
equal
-
>(oid,oid) Object and transaction identifiers
greater than
-
Not recorded in the selected version.
-
>(tid,tid) Object and transaction identifiers
greater than
-
>(xid8,xid8) Object and transaction identifiers
greater than
-
>=(oid,oid) Object and transaction identifiers
greater than or equal
-
Not recorded in the selected version.
-
>=(tid,tid) Object and transaction identifiers
greater than or equal
-
>=(xid8,xid8) Object and transaction identifiers
greater than or equal
-
!~~(bytea,bytea) Other built-in types
does not match LIKE expression
-
&(macaddr,macaddr) Other built-in types
bitwise and
-
&(macaddr8,macaddr8) Other built-in types
bitwise and
-
+(pg_lsn,numeric) Other built-in types
add
-
-(pg_lsn,numeric) Other built-in types
subtract
-
-(pg_lsn,pg_lsn) Other built-in types
minus
-
<(bytea,bytea) Other built-in types
less than
-
<(macaddr,macaddr) Other built-in types
less than
-
<(macaddr8,macaddr8) Other built-in types
less than
-
<(pg_lsn,pg_lsn) Other built-in types
less than
-
<(uuid,uuid) Other built-in types
less than
-
<=(bytea,bytea) Other built-in types
less than or equal
-
<=(macaddr,macaddr) Other built-in types
less than or equal
-
<=(macaddr8,macaddr8) Other built-in types
less than or equal
-
<=(pg_lsn,pg_lsn) Other built-in types
less than or equal
-
<=(uuid,uuid) Other built-in types
less than or equal
-
<>(bytea,bytea) Other built-in types
not equal
-
<>(macaddr,macaddr) Other built-in types
not equal
-
<>(macaddr8,macaddr8) Other built-in types
not equal
-
<>(pg_lsn,pg_lsn) Other built-in types
not equal
-
<>(uuid,uuid) Other built-in types
not equal
-
=(aclitem,aclitem) Other built-in types
equal
-
=(bytea,bytea) Other built-in types
equal
-
=(macaddr,macaddr) Other built-in types
equal
-
=(macaddr8,macaddr8) Other built-in types
equal
-
=(pg_lsn,pg_lsn) Other built-in types
equal
-
=(uuid,uuid) Other built-in types
equal
-
>(bytea,bytea) Other built-in types
greater than
-
>(macaddr,macaddr) Other built-in types
greater than
-
>(macaddr8,macaddr8) Other built-in types
greater than
-
>(pg_lsn,pg_lsn) Other built-in types
greater than
-
>(uuid,uuid) Other built-in types
greater than
-
>=(bytea,bytea) Other built-in types
greater than or equal
-
>=(macaddr,macaddr) Other built-in types
greater than or equal
-
>=(macaddr8,macaddr8) Other built-in types
greater than or equal
-
>=(pg_lsn,pg_lsn) Other built-in types
greater than or equal
-
>=(uuid,uuid) Other built-in types
greater than or equal
-
|(macaddr,macaddr) Other built-in types
bitwise or
-
|(macaddr8,macaddr8) Other built-in types
bitwise or
-
||(bytea,bytea) Other built-in types
concatenate
-
~(none,macaddr) Other built-in types
bitwise not
-
~(none,macaddr8) Other built-in types
bitwise not
-
~~(bytea,bytea) Other built-in types
matches LIKE expression
-
&&(anyarray,anyarray) Pseudo-types
overlaps
-
&&(anymultirange,anymultirange) Pseudo-types
overlaps
-
&&(anymultirange,anyrange) Pseudo-types
overlaps
-
&&(anyrange,anymultirange) Pseudo-types
overlaps
-
&&(anyrange,anyrange) Pseudo-types
overlaps
-
&<(anymultirange,anymultirange) Pseudo-types
overlaps or is left of
-
&<(anymultirange,anyrange) Pseudo-types
overlaps or is left of
-
&<(anyrange,anymultirange) Pseudo-types
overlaps or is left of
-
&<(anyrange,anyrange) Pseudo-types
overlaps or is left of
-
&>(anymultirange,anymultirange) Pseudo-types
overlaps or is right of
-
&>(anymultirange,anyrange) Pseudo-types
overlaps or is right of
-
&>(anyrange,anymultirange) Pseudo-types
overlaps or is right of
-
&>(anyrange,anyrange) Pseudo-types
overlaps or is right of
-
*(anymultirange,anymultirange) Pseudo-types
multirange intersect
-
*(anyrange,anyrange) Pseudo-types
range intersection
-
*<(record,record) Pseudo-types
less than
-
*<=(record,record) Pseudo-types
less than or equal
-
*<>(record,record) Pseudo-types
not identical
-
*=(record,record) Pseudo-types
identical
-
*>(record,record) Pseudo-types
greater than
-
*>=(record,record) Pseudo-types
greater than or equal
-
+(anymultirange,anymultirange) Pseudo-types
multirange union
-
+(anyrange,anyrange) Pseudo-types
range union
-
-(anymultirange,anymultirange) Pseudo-types
multirange minus
-
-(anyrange,anyrange) Pseudo-types
range difference
-
-|-(anymultirange,anymultirange) Pseudo-types
is adjacent to
-
-|-(anymultirange,anyrange) Pseudo-types
is adjacent to
-
-|-(anyrange,anymultirange) Pseudo-types
is adjacent to
-
-|-(anyrange,anyrange) Pseudo-types
is adjacent to
-
<(anyarray,anyarray) Pseudo-types
less than
-
<(anyenum,anyenum) Pseudo-types
less than
-
<(anymultirange,anymultirange) Pseudo-types
less than
-
<(anyrange,anyrange) Pseudo-types
less than
-
<(record,record) Pseudo-types
less than
-
<<(anymultirange,anymultirange) Pseudo-types
is left of
-
<<(anymultirange,anyrange) Pseudo-types
is left of
-
<<(anyrange,anymultirange) Pseudo-types
is left of
-
<<(anyrange,anyrange) Pseudo-types
is left of
-
<=(anyarray,anyarray) Pseudo-types
less than or equal
-
<=(anyenum,anyenum) Pseudo-types
less than or equal
-
<=(anymultirange,anymultirange) Pseudo-types
less than or equal
-
<=(anyrange,anyrange) Pseudo-types
less than or equal
-
<=(record,record) Pseudo-types
less than or equal
-
<>(anyarray,anyarray) Pseudo-types
not equal
-
<>(anyenum,anyenum) Pseudo-types
not equal
-
<>(anymultirange,anymultirange) Pseudo-types
not equal
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.