Table of Contents
- 4.1. Input/Output of Bounding Box Types
- 4.2. Constructor Functions
- 4.3. Casting
- 4.4. Accessor Functions
- 4.5. Modification Functions
- 4.6. Spatial Reference System Functions
- 4.7. Aggregate Functions
- 4.8. Comparison Operators
- 4.9. Set Operators
- 4.10. Topological Operators
- 4.11. Relative Position Operators
- 4.12. Indexing of Box Types
We present next the functions and operators for bounding box types. These functions and operators are polimorhic, that is, their argumentos can be of various types and their result type may depend on the type of the arguments. To express this in the signature of the operators, we use the following notation:
boxrepresents any bounding box type, that is,tboxorstbox.
In the following, we specify with the symbol 
that the function supports 3D points and with the symbol 
that the function is available for geographies.
A tbox is composed of a numeric value and/or time dimensions. For each dimension, minimum and maximum values are given. Examples of input of tbox values are as follows:
-- Both value and time dimensions SELECT tbox 'TBOX((1.0, 2000-01-01), (2.0, 2000-01-02))'; -- Only value dimension SELECT tbox 'TBOX((1.0,), (2.0,))'; -- Only time dimension SELECT tbox 'TBOX((, 2000-01-01), (, 2000-01-02))';
An stbox is composed of a spatial value and/or time dimensions, where the coordinates of the spatial value dimension may be 2D or 3D. For each dimension, minimum and maximum values are given. The coordinates may be Cartesian (planar) or geodetic (spherical). The SRID of the coordinates may be specified; if it is not the case, a value of 0 (unknown) and 4326 (corresponding to WGS84) is assumed, respectively, for planar and geodetic boxes. Examples of input of stbox values are as follows:
-- Only value dimension with X and Y coordinates SELECT stbox 'STBOX((1.0, 2.0), (1.0, 2.0))'; -- Only value dimension with X, Y, and Z coordinates SELECT stbox 'STBOX Z((1.0, 2.0, 3.0), (1.0, 2.0, 3.0))'; -- Both value (with X and Y coordinates) and time dimensions SELECT stbox 'STBOX T((1.0, 2.0, 2001-01-03), (1.0, 2.0, 2001-01-03))'; -- Both value (with X, Y, and Z coordinates) and time dimensions SELECT stbox 'STBOX ZT((1.0, 2.0, 3.0, 2001-01-04), (1.0, 2.0, 3.0, 2001-01-04))'; -- Only time dimension SELECT stbox 'STBOX T(( , , 2001-01-03), ( , , 2001-01-03))'; -- Only value dimension with X, Y, and Z geodetic coordinates SELECT stbox 'GEODSTBOX((1.0, 2.0, 3.0), (1.0, 2.0, 3.0))'; -- Both value (with X, Y and Z geodetic coordinates) and time dimension SELECT stbox 'GEODSTBOX T((1.0, 2.0, 3.0, 2001-01-04), (1.0, 2.0, 3.0, 2001-01-04))'; -- Only time dimension for geodetic box SELECT stbox 'GEODSTBOX T(( , , 2001-01-03), ( , , 2001-01-03))'; -- SRID is given SELECT stbox 'SRID=5676;STBOX T((1.0, 2.0, 2001-01-04), (1.0, 2.0, 2001-01-04))'; SELECT stbox 'SRID=4326;GEODSTBOX((1.0, 2.0, 3.0), (1.0, 2.0, 3.0))';