Name
CG_2DRotate — Rotates a geometry by a given angle around a specified point in 2D.
Synopsis
geometry CG_2DRotate(geometry geom, float8 angle, float8 cx, float8 cy);
Description
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
This method needs SFCGAL backend.
Examples
SELECT ST_AsText(CG_2DRotate('POINT(1 0)', pi()/2, 1, 1));
-- Result: POINT(2 1)