ST_RotateY-PolarDB(PolarDB)-阿里云帮助中心

Rotates a geometry object about the Y-axis by the specified angle in radians.

Syntax

geometry ST_RotateY(geometry geomA, float rotRadians)

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

ST_RotateY(geomA, rotRadians) is shorthand for:

ST_Affine(geomA, 1, 0, 0, 0, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), cos(rotRadians), 0, 0, 0)

Supported geometry types: circular strings, curves, polyhedral surfaces, triangles, triangulated irregular network (TIN) surfaces, and 3D objects.

SELECT ST_AsEWKT(ST_RotateY('LINESTRING (1 2,2 2)'::geometry, pi()));

Result:

       st_asewkt
-----------------------
 LINESTRING(-1 2,-2 2)
(1 row)