Changes between Version 35 and Version 36 of UsersWikiplpgsqlfunctions

Timestamp:

Aug 5, 2020, 3:52:51 PM (4 years ago)

Author:

mdavis

Comment:

—

UsersWikiplpgsqlfunctions

@@ -3 +3 @@
  
 This is an area to put utility functions or wrappers around PostGIS.
-
-== Rotate Geometry around a Point ==
-{{{
-#!sql
-CREATE OR REPLACE FUNCTION RotateAtPoint(
-  geom geometry, pt_x double precision, pt_y double precision, angle double precision)
- RETURNS geometry AS 
-$$
-SELECT ST_Translate( ST_Rotate( ST_Translate( $1, -1*$2, -1*$3), $4), $2, $3)
-$$
-   LANGUAGE 'sql';
-}}}
 
 == Construct Ellipse ==
@@ -185 +173 @@
 }}}
 
+== Rotate Geometry around a Point ==
+
+Superseded by [https://postgis.net/docs/manual-3.0/ST_Rotate.html ST_Rotate].
+
+{{{
+#!sql
+CREATE OR REPLACE FUNCTION RotateAtPoint(
+  geom geometry, pt_x double precision, pt_y double precision, angle double precision)
+ RETURNS geometry AS 
+$$
+SELECT ST_Translate( ST_Rotate( ST_Translate( $1, -1*$2, -1*$3), $4), $2, $3)
+$$
+   LANGUAGE 'sql';
+}}}
 
 == Construct a multilinestring consisting of the interior and exterior rings of a polygon/multipolygon ==