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.
-
|>>(polygon,polygon) Geometric
is above
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
~=(box,box) Geometric
same as
-
~=(circle,circle) Geometric
same as
-
~=(point,point) Geometric
same as
-
~=(polygon,polygon) Geometric
same as
-
+(_aclitem,aclitem) Internal and special-purpose
add/update ACL item
-
-(_aclitem,aclitem) Internal and special-purpose
remove ACL item
-
<(oidvector,oidvector) Internal and special-purpose
less than
-
<=(oidvector,oidvector) Internal and special-purpose
less than or equal
-
<>(oidvector,oidvector) Internal and special-purpose
not equal
-
=(oidvector,oidvector) Internal and special-purpose
equal
-
>(oidvector,oidvector) Internal and special-purpose
greater than
-
>=(oidvector,oidvector) Internal and special-purpose
greater than or equal
-
@>(_aclitem,aclitem) Internal and special-purpose
contains
-
Not recorded in the selected version.
-
#-(jsonb,_text) JSON
delete path
-
#>(json,_text) JSON
get value from json with path elements
-
#>(jsonb,_text) JSON
get value from jsonb with path elements
-
#>>(json,_text) JSON
get value from json as text with path elements
-
#>>(jsonb,_text) JSON
get value from jsonb as text with path elements
-
-(jsonb,_text) JSON
delete object fields
-
-(jsonb,int4) JSON
delete array element
-
-(jsonb,text) JSON
delete object field
-
->(json,int4) JSON
get json array element
-
->(json,text) JSON
get json object field
-
->(jsonb,int4) JSON
get jsonb array element
-
->(jsonb,text) JSON
get jsonb object field
-
->>(json,int4) JSON
get json array element as text
-
->>(json,text) JSON
get json object field as text
-
->>(jsonb,int4) JSON
get jsonb array element as text
-
->>(jsonb,text) JSON
get jsonb object field as text
-
<(jsonb,jsonb) JSON
less than
-
<=(jsonb,jsonb) JSON
less than or equal
-
<>(jsonb,jsonb) JSON
not equal
-
<@(jsonb,jsonb) JSON
is contained by
-
=(jsonb,jsonb) JSON
equal
-
>(jsonb,jsonb) JSON
greater than
-
>=(jsonb,jsonb) JSON
greater than or equal
-
?&(jsonb,_text) JSON
all keys exist
-
?(jsonb,text) JSON
key exists
-
?|(jsonb,_text) JSON
any key exists
-
@>(jsonb,jsonb) JSON
contains
-
@?(jsonb,jsonpath) JSON
jsonpath exists
-
@@(jsonb,jsonpath) JSON
jsonpath match
-
||(jsonb,jsonb) JSON
concatenate
-
&&(inet,inet) Network addresses
overlaps (is subnet or supernet)
-
&(inet,inet) Network addresses
bitwise and
-
+(inet,int8) Network addresses
add
-
-(inet,inet) Network addresses
subtract
-
-(inet,int8) Network addresses
subtract
-
<(inet,inet) Network addresses
less than
-
<<(inet,inet) Network addresses
is subnet
-
<<=(inet,inet) Network addresses
is subnet or equal
-
<=(inet,inet) Network addresses
less than or equal
-
<>(inet,inet) Network addresses
not equal
-
=(inet,inet) Network addresses
equal
-
>(inet,inet) Network addresses
greater than
-
>=(inet,inet) Network addresses
greater than or equal
-
>>(inet,inet) Network addresses
is supernet
-
>>=(inet,inet) Network addresses
is supernet or equal
-
|(inet,inet) Network addresses
bitwise or
-
~(none,inet) Network addresses
bitwise not
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
#(int2,int2) Numeric
bitwise exclusive or
-
#(int4,int4) Numeric
bitwise exclusive or
-
#(int8,int8) Numeric
bitwise exclusive or
-
%(int2,int2) Numeric
modulus
-
%(int4,int4) Numeric
modulus
-
%(int8,int8) Numeric
modulus
-
%(numeric,numeric) Numeric
modulus
-
&(int2,int2) Numeric
bitwise and
-
&(int4,int4) Numeric
bitwise and
-
&(int8,int8) Numeric
bitwise and
-
*(float4,float4) Numeric
multiply
-
*(float4,float8) Numeric
multiply
-
*(float4,money) Numeric
multiply
-
*(float8,float4) Numeric
multiply
-
*(float8,float8) Numeric
multiply
-
*(float8,interval) Numeric
multiply
-
*(float8,money) Numeric
multiply
-
*(int2,int2) Numeric
multiply
-
*(int2,int4) Numeric
multiply
-
*(int2,int8) Numeric
multiply
-
*(int2,money) Numeric
multiply
-
*(int4,int2) Numeric
multiply
-
*(int4,int4) Numeric
multiply
-
*(int4,int8) Numeric
multiply
-
*(int4,money) Numeric
multiply
-
*(int8,int2) Numeric
multiply
-
*(int8,int4) Numeric
multiply
-
*(int8,int8) Numeric
multiply
-
*(int8,money) Numeric
multiply
-
*(money,float4) Numeric
multiply
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.