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

Rotates a geometry object by a specified number of radians about the x-axis.

Syntax

geometry ST_RotateX(geometry geomA, float rotRadians);

Parameter	Description
`geomA`	The geometry object to rotate.
`rotRadians`	The rotation angle, in radians.

ST_RotateX(geomA, rotRadians) is shorthand for ST_Affine(geomA, 1, 0, 0, 0, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), or cos(rotRadians), 0, 0, 0).
Supported geometry types include circular strings, curves, polyhedral surfaces, triangles, triangulated irregular network (TIN) surfaces, and 3D objects.

SELECT ST_AsEWKT(ST_RotateX('LINESTRING (1 2,2 2)'::geometry, pi()));
       st_asewkt
-----------------------
 LINESTRING(1 -2,2 -2)
(1 row)