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

Forces a geometry into 3D by adding Z coordinates.

Syntax

geometry ST_Force3D(geometry geomA);

Parameter	Description
`geomA`	The geometry object to convert.

ST_Force3D is an alias for ST_Force_3DZ.
If the input geometry does not have Z coordinates, the Z coordinates of the output are set to 0.
Supports circular strings, curves, polyhedral surfaces, and 3D geometries.

SELECT ST_AsEWKT(ST_Force3D(ST_GeomFromEWKT('POINT(1 2)')));

Output:

  st_asewkt
--------------
 POINT(1 2 0)
(1 row)