CG_RotateX — Rotates a geometry around the X-axis by a given angle.
geometry CG_RotateX(
geometry geom, float8 angle)
;
Rotates the input geometry geom
by angle
radians around the X-axis.
Availability: 3.6.0 - requires SFCGAL >= 2.0.0
Questo metodo richiede il backend SFCGAL.
Questa funzione supporta il 3d e non distrugge gli z-index.
SELECT ST_AsText(CG_RotateX('POINT(0 1 0)', pi()/2)); -- Result: POINT(0 0 1)