CG_RotateZ — Rotates a geometry around the Z-axis by a given angle.
geometry CG_RotateZ(
geometry geom, float8 angle)
;
Rotates the input geometry geom
by angle
radians around the Z-axis.
Availability: 3.6.0 - requires SFCGAL >= 2.0.0
该方法需要SFCGAL后端。
该函数支持 3d 并且不会丢失 z-index。
SELECT ST_AsText(CG_RotateZ('POINT(1 0 0)', pi()/2)); -- Result: POINT(0 1 0)