The functions given next expand the bounding boxes on the value and the time dimension or set the precision of the value dimension. These functions raise an error if the corresponding dimension is not present.
Expand the numeric value dimension of the bounding box by a float value
expandValue(tbox,float): tbox
SELECT expandValue(tbox 'TBOX((1,2012-01-01),(2,2012-01-03))', 1); -- "TBOX((0,2012-01-01),(3,2012-01-03))" SELECT expandValue(tbox 'TBOX((,2012-01-01),(,2012-01-03))', 1); -- The box must have value dimension
Expand the spatial value dimension of the bounding box by a float value
expandSpatial(stbox,float): stbox
SELECT expandSpatial(stbox 'STBOX ZT((1,1,1,2012-01-01),(2,2,2,2012-01-03))', 1); -- "STBOX ZT((0,0,0,2012-01-01),(3,3,3,2012-01-03))" SELECT expandSpatial(stbox 'STBOX T((,2012-01-01),(,2012-01-03))', 1); -- The box must have XY dimension
Expand the temporal dimension of the bounding box by a time interval
expandTemporal(box,interval): box
SELECT expandTemporal(tbox 'TBOX((1,2012-01-01),(2,2012-01-03))', interval '1 day'); -- "TBOX((1,2011-12-31),(2,2012-01-04))" SELECT expandTemporal(stbox 'STBOX ZT((1,1,1,2012-01-01),(2,2,2,2012-01-03))', interval '1 day'); -- "STBOX ZT((1,1,1,2011-12-31),(2,2,2,2012-01-04))"
Round the value or the coordinates of the bounding box to a number of decimal places
setPrecision(box,integer): box
SELECT setPrecision(tbox 'TBOX((1.12345, 2000-01-01), (2.12345, 2000-01-02))', 2); -- "TBOX((1.12,2000-01-01),(2.12,2000-01-02))" SELECT setPrecision(stbox 'STBOX T((1.12345, 1.12345, 2000-01-01), (2.12345, 2.12345, 2000-01-02))', 2); -- "STBOX T((1.12,1.12,2000-01-01),(2.12,2.12,2000-01-02))"