Has X dimension?
hasX(box): boolean
SELECT hasX(tbox 'TBOX((, 2000-01-01), (, 2000-01-03))'); -- false SELECT hasX(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- true
Has Z dimension?
hasZ(stbox): boolean
SELECT hasZ(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- false
Has T dimension?
hasT(box): boolean
SELECT hasT(tbox 'TBOX((1.0, 2000-01-01), (3.0, 2000-01-03))'); -- true SELECT hasT(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- false
Get the minimum X value
Xmin(box): float
SELECT Xmin(tbox 'TBOX((1.0, 2000-01-01), (3.0, 2000-01-03))'); -- 1 SELECT Xmin(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 1
Get the maximum X value
Xmax(box): float
SELECT Xmax(tbox 'TBOX((1.0, 2000-01-01), (3.0, 2000-01-03))'); -- 3 SELECT Xmax(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 3
Get the minimum Y value
Ymin(stbox): float
SELECT Ymin(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 2
Get the maximum Y value
Ymax(stbox): float
SELECT Ymax(stbox 'STBOX((1.0, 2.0), (3.0, 4.0))'); -- 4
Get the minimum Z value
Zmin(stbox): float
SELECT Zmin(stbox 'STBOX Z((1.0, 2.0, 3.0), (4.0, 5.0, 6.0))'); -- 3
Get the maximum Z value
Zmax(stbox): float
SELECT Zmax(stbox 'STBOX Z((1.0, 2.0, 3.0), (4.0, 5.0, 6.0))'); -- 6
Get the minimum T value
Tmin(box): timestamptz
SELECT Tmin(stbox 'GEODSTBOX T(( , , 2001-01-01), ( , , 2001-01-03))'); -- "2001-01-01"
Get the maximum T value
Tmax(box): timestamptz
SELECT Tmax(stbox 'GEODSTBOX T(( , , 2001-01-01), ( , , 2001-01-03))'); -- "2001-01-03"