Bounding Box Operations

Bounding Box Operations
Prev	Chapter 18. Writing Portable Queries	Next

These operations compare the bounding boxes of their arguments: the span of a set or of a span set, or the box of a temporal value, tbox, stbox or tpcbox.

Topological Operations

Whether two bounding boxes overlap, contain one another, are adjacent or are the same. The last rows test the time span of a temporal JSONB value and the route identifiers of network points.

Category	Operator	Portable function
Bounding box	&&	setOverlaps / spanOverlaps / spansetOverlaps / tboxOverlaps / stboxOverlaps / tpcboxOverlaps (a, b)
	@>	setContains / spanContains / spansetContains / tboxContains / stboxContains / tpcboxContains (a, b)
	<@	setContained / spanContained / spansetContained / tboxContained / stboxContained / tpcboxContained (a, b)
	-\|-	spanAdjacent / spansetAdjacent / tboxAdjacent / stboxAdjacent / tpcboxAdjacent (a, b)
	~=	spanSame / tboxSame / stboxSame / tpcboxSame (a, b), cbufferSame / npointSame / poseSame / posechainSame (a, b)
Time span of a temporal JSONB value	#@>	tjsonbContains(a, b)
	<@#	tjsonbContained(a, b)
Route identifier (network point)	@=	sameRid(a, b)
	@?	containsRid(a, b)
	?@	containedRid(a, b)
	@@	overlapsRid(a, b)

Position Operations

Whether a bounding box is strictly before, after, left of, right of, below, above, in front of or behind another, and, in the forms starting with over, whether it does not extend beyond it on that side.

Category	Operator	Portable function
Time position	<<#	setBefore / spanBefore / spansetBefore / tboxBefore / stboxBefore / tpcboxBefore (a, b)
	#>>	setAfter / spanAfter / spansetAfter / tboxAfter / stboxAfter / tpcboxAfter (a, b)
	&<#	setOverbefore / spanOverbefore / spansetOverbefore / tboxOverbefore / stboxOverbefore / tpcboxOverbefore (a, b)
	#&>	setOverafter / spanOverafter / spansetOverafter / tboxOverafter / stboxOverafter / tpcboxOverafter (a, b)
Space, X axis	<<	setLeft / spanLeft / spansetLeft / tboxLeft / stboxLeft / tpcboxLeft (a, b)
	>>	setRight / spanRight / spansetRight / tboxRight / stboxRight / tpcboxRight (a, b)
	&<	setOverleft / spanOverleft / spansetOverleft / tboxOverleft / stboxOverleft / tpcboxOverleft (a, b)
	&>	setOverright / spanOverright / spansetOverright / tboxOverright / stboxOverright / tpcboxOverright (a, b)
Space, Y axis	<<\|	stboxBelow / tpcboxBelow (a, b)
	\|>>	stboxAbove / tpcboxAbove (a, b)
	&<\|	stboxOverbelow / tpcboxOverbelow (a, b)
	\|&>	stboxOverabove / tpcboxOverabove (a, b)
Space, Z axis	<</	stboxFront / tpcboxFront (a, b)
	/>>	stboxBack / tpcboxBack (a, b)
	&</	stboxOverfront / tpcboxOverfront (a, b)
	/&>	stboxOverback / tpcboxOverback (a, b)