Create version of ST_RotateY with pointOrigin like ST_Rotate()

[smathermather]

geometry ST_RotateY(geometry geomA, float rotRadians, geometry pointOrigin)

— Function: ST_RotateY(geometry, double precision, geometry) CREATE OR REPLACE FUNCTION ST_RotateY(geomA geometry, rotRadians double precision, pointOrigin geometry)

RETURNS geometry AS

$BODY$

— Transform geometry to nullsville (0,0,0) so rotRadians will take place around the pointOrigin WITH transformed AS (

SELECT ST_Translate(geomA, -1 * ST_X(pointOrigin), -1 * ST_Y(pointOrigin), -1 * ST_Z(pointOrigin)) AS the_geom ),

— Rotate in place rotated AS (

SELECT ST_RotateY(the_geom, rotRadians) AS the_geom FROM transformed ),

— Translate back home rotTrans AS (

SELECT ST_Translate(the_geom, ST_X(pointOrigin), ST_Y(pointOrigin), ST_Z(pointOrigin)) AS the_geom

FROM rotated

)

— profit SELECT the_geom from rotTrans

;

$BODY$

LANGUAGE sql VOLATILE COST 100;

[pramsey]

Assigning the SQL / API ticket to Regina

[robe]

Given that this patch doesn't include documentation and I think some things in the related functions have changed that would make this code easier, I'm pushing this to 2.4 consideration. I want to release 2.3 very soon.

[robe]

smathermather,

rework this patch as a C function.

[robe]

Milestone renamed