CG_2DRotate — Rotates a geometry by a given angle around a specified point in 2D.
geometry CG_2DRotate(
geometry geom, float8 angle, float8 cx, float8 cy)
;
Rotates the input geometry geom
by angle
radians around the point (cx
, cy
). The rotation is performed in 2D space; Z coordinates are dropped. Positive angles rotate the geometry counter-clockwise.
Availability: 3.6.0 - requires SFCGAL >= 2.0.0
Questo metodo richiede il backend SFCGAL.
SELECT ST_AsText(CG_2DRotate('POINT(1 0)', pi()/2, 1, 1)); -- Result: POINT(2 1)