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.
-
<->(point,point) Geometric
distance between
-
<->(point,polygon) Geometric
distance between
-
<->(polygon,circle) Geometric
distance between
-
<->(polygon,point) Geometric
distance between
-
<->(polygon,polygon) Geometric
distance between
-
<<(box,box) Geometric
is left of
-
<<(circle,circle) Geometric
is left of
-
<<(point,point) Geometric
is left of
-
<<(polygon,polygon) Geometric
is left of
-
<<|(box,box) Geometric
is below
-
<<|(circle,circle) Geometric
is below
-
<<|(point,point) Geometric
is below
-
<<|(polygon,polygon) Geometric
is below
-
<=(box,box) Geometric
less than or equal by area
-
<=(circle,circle) Geometric
less than or equal by area
-
<=(lseg,lseg) Geometric
less than or equal by length
-
<=(path,path) Geometric
less than or equal
-
<>(circle,circle) Geometric
not equal by area
-
<>(lseg,lseg) Geometric
not equal
-
<>(point,point) Geometric
not equal
-
<@(box,box) Geometric
is contained by
-
<@(circle,circle) Geometric
is contained by
-
<@(lseg,box) Geometric
is contained by
-
<@(lseg,line) Geometric
lseg on line
-
<@(point,box) Geometric
point inside box
-
<@(point,circle) Geometric
is contained by
-
<@(point,line) Geometric
point on line
-
<@(point,lseg) Geometric
is contained by
-
<@(point,path) Geometric
point within closed path, or point on open path
-
<@(point,polygon) Geometric
is contained by
-
<@(polygon,polygon) Geometric
is contained by
-
<^(box,box) Geometric
is below (allows touching)
-
<^(point,point) Geometric
deprecated, use <<| instead
-
=(box,box) Geometric
equal by area
-
=(circle,circle) Geometric
equal by area
-
=(line,line) Geometric
equal
-
=(lseg,lseg) Geometric
equal
-
=(path,path) Geometric
equal
-
>(box,box) Geometric
greater than by area
-
>(circle,circle) Geometric
greater than by area
-
>(lseg,lseg) Geometric
greater than by length
-
>(path,path) Geometric
greater than
-
>=(box,box) Geometric
greater than or equal by area
-
>=(circle,circle) Geometric
greater than or equal by area
-
>=(lseg,lseg) Geometric
greater than or equal by length
-
>=(path,path) Geometric
greater than or equal
-
>>(box,box) Geometric
is right of
-
>>(circle,circle) Geometric
is right of
-
>>(point,point) Geometric
is right of
-
>>(polygon,polygon) Geometric
is right of
-
>^(box,box) Geometric
is above (allows touching)
-
>^(point,point) Geometric
deprecated, use |>> instead
-
?#(box,box) Geometric
deprecated, use && instead
-
?#(line,box) Geometric
intersect
-
?#(line,line) Geometric
intersect
-
?#(lseg,box) Geometric
intersect
-
?#(lseg,line) Geometric
intersect
-
?#(lseg,lseg) Geometric
intersect
-
?#(path,path) Geometric
intersect
-
?-(none,line) Geometric
horizontal
-
?-(none,lseg) Geometric
horizontal
-
?-(point,point) Geometric
horizontally aligned
-
?-|(line,line) Geometric
perpendicular
-
?-|(lseg,lseg) Geometric
perpendicular
-
?|(none,line) Geometric
vertical
-
?|(none,lseg) Geometric
vertical
-
?|(point,point) Geometric
vertically aligned
-
?||(line,line) Geometric
parallel
-
?||(lseg,lseg) Geometric
parallel
-
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.
-
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.
-
@-@(none,lseg) Geometric
distance between endpoints
-
@-@(none,path) Geometric
sum of path segment lengths
-
@>(box,box) Geometric
contains
-
@>(box,point) Geometric
contains
-
@>(circle,circle) Geometric
contains
-
@>(circle,point) Geometric
contains
-
@>(path,point) Geometric
contains
-
@>(polygon,point) Geometric
contains
-
@>(polygon,polygon) Geometric
contains
-
@@(none,box) Geometric
center of
-
@@(none,circle) Geometric
center of
-
@@(none,lseg) Geometric
center of
-
Not recorded in the selected version.
-
@@(none,polygon) Geometric
center of
-
|&>(box,box) Geometric
overlaps or is above
-
|&>(circle,circle) Geometric
overlaps or is above
-
|&>(polygon,polygon) Geometric
overlaps or is above
-
|>>(box,box) Geometric
is above
-
|>>(circle,circle) Geometric
is above
-
|>>(point,point) Geometric
is above
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.