ST_3DMakeBox-ApsaraDB RDS(RDS)-阿里云帮助中心

Constructs a Box3D object from two diagonal corner points: a lower-left point and an upper-right point.

Syntax

box3d ST_3DMakeBox(geometry point3DLowLeftBottom, geometry point3DUpRightTop)

Parameter	Description
`point3DLowLeftBottom`	The point at the lower-left corner.
`point3DUpRightTop`	The point at the upper-right corner.

ST_3DMakeBox supports 3D objects and preserves the Z coordinate of the constructed geometry object.

SELECT ST_3DMakeBox(ST_MakePoint(115, 39, 10), ST_MakePoint(116, 40, 10));

Output:

        st_3dmakebox
----------------------------
 BOX3D(115 39 10,116 40 10)
(1 row)