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.
-
*(money,float8) Numeric
multiply
-
*(money,int2) Numeric
multiply
-
*(money,int4) Numeric
multiply
-
*(money,int8) Numeric
multiply
-
*(numeric,numeric) Numeric
multiply
-
+(float4,float4) Numeric
add
-
+(float4,float8) Numeric
add
-
+(float8,float4) Numeric
add
-
+(float8,float8) Numeric
add
-
+(int2,int2) Numeric
add
-
+(int2,int4) Numeric
add
-
+(int2,int8) Numeric
add
-
+(int4,date) Numeric
add
-
+(int4,int2) Numeric
add
-
+(int4,int4) Numeric
add
-
+(int4,int8) Numeric
add
-
+(int8,inet) Numeric
add
-
+(int8,int2) Numeric
add
-
+(int8,int4) Numeric
add
-
+(int8,int8) Numeric
add
-
+(money,money) Numeric
add
-
+(none,float4) Numeric
unary plus
-
+(none,float8) Numeric
unary plus
-
+(none,int2) Numeric
unary plus
-
+(none,int4) Numeric
unary plus
-
+(none,int8) Numeric
unary plus
-
+(none,numeric) Numeric
unary plus
-
+(numeric,numeric) Numeric
add
-
+(numeric,pg_lsn) Numeric
add
-
-(float4,float4) Numeric
subtract
-
-(float4,float8) Numeric
subtract
-
-(float8,float4) Numeric
subtract
-
-(float8,float8) Numeric
subtract
-
-(int2,int2) Numeric
subtract
-
-(int2,int4) Numeric
subtract
-
-(int2,int8) Numeric
subtract
-
-(int4,int2) Numeric
subtract
-
-(int4,int4) Numeric
subtract
-
-(int4,int8) Numeric
subtract
-
-(int8,int2) Numeric
subtract
-
-(int8,int4) Numeric
subtract
-
-(int8,int8) Numeric
subtract
-
-(money,money) Numeric
subtract
-
-(none,float4) Numeric
negate
-
-(none,float8) Numeric
negate
-
-(none,int2) Numeric
negate
-
-(none,int4) Numeric
negate
-
-(none,int8) Numeric
negate
-
-(none,numeric) Numeric
negate
-
-(numeric,numeric) Numeric
subtract
-
/(float4,float4) Numeric
divide
-
/(float4,float8) Numeric
divide
-
/(float8,float4) Numeric
divide
-
/(float8,float8) Numeric
divide
-
/(int2,int2) Numeric
divide
-
/(int2,int4) Numeric
divide
-
/(int2,int8) Numeric
divide
-
/(int4,int2) Numeric
divide
-
/(int4,int4) Numeric
divide
-
/(int4,int8) Numeric
divide
-
/(int8,int2) Numeric
divide
-
/(int8,int4) Numeric
divide
-
/(int8,int8) Numeric
divide
-
/(money,float4) Numeric
divide
-
/(money,float8) Numeric
divide
-
/(money,int2) Numeric
divide
-
/(money,int4) Numeric
divide
-
/(money,int8) Numeric
divide
-
/(money,money) Numeric
divide
-
/(numeric,numeric) Numeric
divide
-
<(float4,float4) Numeric
less than
-
<(float4,float8) Numeric
less than
-
<(float8,float4) Numeric
less than
-
<(float8,float8) Numeric
less than
-
<(int2,int2) Numeric
less than
-
<(int2,int4) Numeric
less than
-
<(int2,int8) Numeric
less than
-
<(int4,int2) Numeric
less than
-
<(int4,int4) Numeric
less than
-
<(int4,int8) Numeric
less than
-
<(int8,int2) Numeric
less than
-
<(int8,int4) Numeric
less than
-
<(int8,int8) Numeric
less than
-
<(money,money) Numeric
less than
-
<(numeric,numeric) Numeric
less than
-
<<(int2,int4) Numeric
bitwise shift left
-
<<(int4,int4) Numeric
bitwise shift left
-
<<(int8,int4) Numeric
bitwise shift left
-
<=(float4,float4) Numeric
less than or equal
-
<=(float4,float8) Numeric
less than or equal
-
<=(float8,float4) Numeric
less than or equal
-
<=(float8,float8) Numeric
less than or equal
-
<=(int2,int2) Numeric
less than or equal
-
<=(int2,int4) Numeric
less than or equal
-
<=(int2,int8) Numeric
less than or equal
-
<=(int4,int2) Numeric
less than or equal
-
<=(int4,int4) Numeric
less than or equal
-
<=(int4,int8) Numeric
less than or equal
-
<=(int8,int2) Numeric
less than or equal
-
<=(int8,int4) Numeric
less than or 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.