Description

Rotates a geometry geomA - rotRadians about the X axis.

	ST_RotateX(geomA, rotRadians) is short-hand for ST_Affine(geomA, 1, 0, 0, 0, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), cos(rotRadians), 0, 0, 0).

Enhanced: 2.0.0 support for Polyhedral surfaces, Triangles and TIN was introduced.

Availability: 1.1.2. Name changed from RotateX to ST_RotateX in 1.2.2

This function supports Polyhedral surfaces.

This function supports 3d and will not drop the z-index.

This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).

Examples

This example rotates a line 90 degrees around the X axis.

SELECT ST_RotateX('LINESTRING(1 2 3,1 1 1)', pi()/2);

LINESTRING(1 -3 2,1 -1 1)

010200008002000000000000000000F03F00000000000008C00000000000000040000000000000F03FFFFFFFFFFFFFEFBF000000000000F03F

Figure

See Also

ST_Affine, ST_RotateY, ST_RotateZ