CG_RotateY — Rotates a geometry around the Y-axis by a given angle.
geometry CG_RotateY(geometry geom, float8 angle);
Rotates the input geometry geom by angle radians around the Y-axis passing. 
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_RotateY('POINT(1 0 0)', pi()/2));
-- Result: POINT(0 0 -1)