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.
-
Not recorded in the selected version.
-
>(date,date) Date and time
greater than
-
>(date,timestamp) Date and time
greater than
-
>(date,timestamptz) Date and time
greater than
-
>(interval,interval) Date and time
greater than
-
Not recorded in the selected version.
-
>(time,time) Date and time
greater than
-
>(timestamp,date) Date and time
greater than
-
>(timestamp,timestamp) Date and time
greater than
-
>(timestamp,timestamptz) Date and time
greater than
-
>(timestamptz,date) Date and time
greater than
-
>(timestamptz,timestamp) Date and time
greater than
-
>(timestamptz,timestamptz) Date and time
greater than
-
>(timetz,timetz) Date and time
greater than
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
>=(date,date) Date and time
greater than or equal
-
>=(date,timestamp) Date and time
greater than or equal
-
>=(date,timestamptz) Date and time
greater than or equal
-
>=(interval,interval) Date and time
greater than or equal
-
Not recorded in the selected version.
-
>=(time,time) Date and time
greater than or equal
-
>=(timestamp,date) Date and time
greater than or equal
-
>=(timestamp,timestamp) Date and time
greater than or equal
-
>=(timestamp,timestamptz) Date and time
greater than or equal
-
>=(timestamptz,date) Date and time
greater than or equal
-
>=(timestamptz,timestamp) Date and time
greater than or equal
-
>=(timestamptz,timestamptz) Date and time
greater than or equal
-
>=(timetz,timetz) Date and time
greater than or equal
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
##(line,lseg) Geometric
closest point to A on B
-
##(lseg,box) Geometric
closest point to A on B
-
Not recorded in the selected version.
-
##(lseg,lseg) Geometric
closest point to A on B
-
##(point,box) Geometric
closest point to A on B
-
##(point,line) Geometric
closest point to A on B
-
##(point,lseg) Geometric
closest point to A on B
-
#(box,box) Geometric
box intersection
-
#(line,line) Geometric
intersection point
-
#(lseg,lseg) Geometric
intersection point
-
#(none,path) Geometric
number of points
-
#(none,polygon) Geometric
number of points
-
&&(box,box) Geometric
overlaps
-
&&(circle,circle) Geometric
overlaps
-
&&(polygon,polygon) Geometric
overlaps
-
&<(box,box) Geometric
overlaps or is left of
-
&<(circle,circle) Geometric
overlaps or is left of
-
&<(polygon,polygon) Geometric
overlaps or is left of
-
&<|(box,box) Geometric
overlaps or is below
-
&<|(circle,circle) Geometric
overlaps or is below
-
&<|(polygon,polygon) Geometric
overlaps or is below
-
&>(box,box) Geometric
overlaps or is right of
-
&>(circle,circle) Geometric
overlaps or is right of
-
&>(polygon,polygon) Geometric
overlaps or is right of
-
*(box,point) Geometric
multiply box by point (scale)
-
*(circle,point) Geometric
multiply
-
*(path,point) Geometric
multiply (rotate/scale path)
-
*(point,point) Geometric
multiply points (scale/rotate)
-
+(box,point) Geometric
add point to box (translate)
-
+(circle,point) Geometric
add
-
+(path,path) Geometric
concatenate
-
+(path,point) Geometric
add (translate path)
-
+(point,point) Geometric
add points (translate)
-
-(box,point) Geometric
subtract point from box (translate)
-
-(circle,point) Geometric
subtract
-
-(path,point) Geometric
subtract (translate path)
-
-(point,point) Geometric
subtract points (translate)
-
/(box,point) Geometric
divide box by point (scale)
-
/(circle,point) Geometric
divide
-
/(path,point) Geometric
divide (rotate/scale path)
-
/(point,point) Geometric
divide points (scale/rotate)
-
<(box,box) Geometric
less than by area
-
<(circle,circle) Geometric
less than by area
-
<(lseg,lseg) Geometric
less than by length
-
<(path,path) Geometric
less than
-
<->(box,box) Geometric
distance between
-
Not recorded in the selected version.
-
<->(box,lseg) Geometric
distance between
-
<->(box,point) Geometric
distance between
-
<->(circle,circle) Geometric
distance between
-
<->(circle,point) Geometric
distance between
-
<->(circle,polygon) Geometric
distance between
-
Not recorded in the selected version.
-
<->(line,line) Geometric
distance between
-
<->(line,lseg) Geometric
distance between
-
<->(line,point) Geometric
distance between
-
<->(lseg,box) Geometric
distance between
-
<->(lseg,line) Geometric
distance between
-
<->(lseg,lseg) Geometric
distance between
-
<->(lseg,point) Geometric
distance between
-
<->(path,path) Geometric
distance between
-
<->(path,point) Geometric
distance between
-
<->(point,box) Geometric
distance between
-
<->(point,circle) Geometric
distance between
-
<->(point,line) Geometric
distance between
-
<->(point,lseg) Geometric
distance between
-
<->(point,path) Geometric
distance between
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.