This topic describes the INCLUDED operators. These operators are used to check whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in a specified dimension.
Syntax
{geometry, trajectory, boxndf} /<@/ {geometry, trajectory, boxndf}
{trajectory, boxndf} #<@# {trajectory, boxndf}
{geometry, trajectory, boxndf} <@ {geometry, trajectory, boxndf}
{geometry, trajectory, boxndf} </@ {geometry, trajectory, boxndf}
{trajectory, boxndf} <#@ {trajectory, boxndf}
{trajectory, boxndf} </#@ {trajectory, boxndf}Parameters
| Parameter | Description |
|---|
| Parameter | Description |
|---|---|
| Left operand | The object whose bounding box you want to compare. |
| Right operand | The object whose bounding box you want to compare. |
Description
The INCLUDED operators allow you to check whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in a specified dimension. These bounding boxes are generated by the ST_MakeBox function. For more information, see ST_MakeBox. The effect of the INCLUDED operators is opposite to that of the INCLUDE operators. For more information, see INCLUDE operators.
The following INCLUDED operators are supported:
/<@/: checks whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in the z dimension.#<@#: checks whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in the t dimension.<@: checks whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in the x and y dimensions.<&@: checks whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in the x, y, and z dimensions.<#@: checks whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in the x, y, and t dimensions.</#@: checks whether the bounding box of the left operand-specified object is included in the bounding box of the right operand-specified object in the x, y, z, and t dimensions.
Example
WITH box AS(
SELECT ST_MakeBox3dt(0,0,0, '2010-01-01 00:00:00',10,10,10, '2012-01-01 00:00:00') a,
ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00') b
)
SELECT b /<@/ a AS OpZ, b #<@# a AS OpT, b <@ a AS Op2D, b </@ a AS Op3D, b <#@ a AS Op2DT, b </#@ a AS Op3DT from box;
opz | opt | op2d | op3d | op2dt | op3dt
-----+-----+------+------+-------+-------
t | f | t | t | f | f