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.
-
<=(int8,int8) Numeric
less than or equal
-
<=(money,money) Numeric
less than or equal
-
<=(numeric,numeric) Numeric
less than or equal
-
<>(float4,float4) Numeric
not equal
-
<>(float4,float8) Numeric
not equal
-
<>(float8,float4) Numeric
not equal
-
<>(float8,float8) Numeric
not equal
-
<>(int2,int2) Numeric
not equal
-
<>(int2,int4) Numeric
not equal
-
<>(int2,int8) Numeric
not equal
-
<>(int4,int2) Numeric
not equal
-
<>(int4,int4) Numeric
not equal
-
<>(int4,int8) Numeric
not equal
-
<>(int8,int2) Numeric
not equal
-
<>(int8,int4) Numeric
not equal
-
<>(int8,int8) Numeric
not equal
-
<>(money,money) Numeric
not equal
-
<>(numeric,numeric) Numeric
not equal
-
=(float4,float4) Numeric
equal
-
=(float4,float8) Numeric
equal
-
=(float8,float4) Numeric
equal
-
=(float8,float8) Numeric
equal
-
=(int2,int2) Numeric
equal
-
=(int2,int4) Numeric
equal
-
=(int2,int8) Numeric
equal
-
=(int4,int2) Numeric
equal
-
=(int4,int4) Numeric
equal
-
=(int4,int8) Numeric
equal
-
=(int8,int2) Numeric
equal
-
=(int8,int4) Numeric
equal
-
=(int8,int8) Numeric
equal
-
=(money,money) Numeric
equal
-
=(numeric,numeric) Numeric
equal
-
>(float4,float4) Numeric
greater than
-
>(float4,float8) Numeric
greater than
-
>(float8,float4) Numeric
greater than
-
>(float8,float8) Numeric
greater than
-
>(int2,int2) Numeric
greater than
-
>(int2,int4) Numeric
greater than
-
>(int2,int8) Numeric
greater than
-
>(int4,int2) Numeric
greater than
-
>(int4,int4) Numeric
greater than
-
>(int4,int8) Numeric
greater than
-
>(int8,int2) Numeric
greater than
-
>(int8,int4) Numeric
greater than
-
>(int8,int8) Numeric
greater than
-
>(money,money) Numeric
greater than
-
>(numeric,numeric) Numeric
greater than
-
>=(float4,float4) Numeric
greater than or equal
-
>=(float4,float8) Numeric
greater than or equal
-
>=(float8,float4) Numeric
greater than or equal
-
>=(float8,float8) Numeric
greater than or equal
-
>=(int2,int2) Numeric
greater than or equal
-
>=(int2,int4) Numeric
greater than or equal
-
>=(int2,int8) Numeric
greater than or equal
-
>=(int4,int2) Numeric
greater than or equal
-
>=(int4,int4) Numeric
greater than or equal
-
>=(int4,int8) Numeric
greater than or equal
-
>=(int8,int2) Numeric
greater than or equal
-
>=(int8,int4) Numeric
greater than or equal
-
>=(int8,int8) Numeric
greater than or equal
-
>=(money,money) Numeric
greater than or equal
-
>=(numeric,numeric) Numeric
greater than or equal
-
>>(int2,int4) Numeric
bitwise shift right
-
>>(int4,int4) Numeric
bitwise shift right
-
>>(int8,int4) Numeric
bitwise shift right
-
@(none,float4) Numeric
absolute value
-
@(none,float8) Numeric
absolute value
-
@(none,int2) Numeric
absolute value
-
@(none,int4) Numeric
absolute value
-
@(none,int8) Numeric
absolute value
-
@(none,numeric) Numeric
absolute value
-
^(float8,float8) Numeric
exponentiation
-
^(numeric,numeric) Numeric
exponentiation
-
|(int2,int2) Numeric
bitwise or
-
|(int4,int4) Numeric
bitwise or
-
|(int8,int8) Numeric
bitwise or
-
|/(none,float8) Numeric
square root
-
||/(none,float8) Numeric
cube root
-
~(none,int2) Numeric
bitwise not
-
~(none,int4) Numeric
bitwise not
-
~(none,int8) Numeric
bitwise not
-
<(oid,oid) Object and transaction identifiers
less than
-
Not recorded in the selected version.
-
<(tid,tid) Object and transaction identifiers
less than
-
<(xid8,xid8) Object and transaction identifiers
less than
-
<=(oid,oid) Object and transaction identifiers
less than or equal
-
Not recorded in the selected version.
-
<=(tid,tid) Object and transaction identifiers
less than or equal
-
<=(xid8,xid8) Object and transaction identifiers
less than or equal
-
<>(oid,oid) Object and transaction identifiers
not equal
-
Not recorded in the selected version.
-
<>(tid,tid) Object and transaction identifiers
not equal
-
<>(xid,int4) Object and transaction identifiers
not equal
-
<>(xid,xid) Object and transaction identifiers
not equal
-
<>(xid8,xid8) Object and transaction identifiers
not equal
-
=(cid,cid) Object and transaction identifiers
equal
-
=(oid,oid) Object and transaction identifiers
equal
-
Not recorded in the selected version.
-
=(tid,tid) Object and transaction identifiers
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.