Changes between Version 38 and Version 39 of UsersWikiplpgsqlfunctions

Timestamp:

09/20/21 15:34:28 (3 years ago)

Author:

mdavis

Comment:

--

UsersWikiplpgsqlfunctions

@@ -17 +17 @@
  $$
    SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, quadSeg), rx, ry), rotation), x, y)
+$$
+ LANGUAGE 'sql';
+}}}
+
+Alternate:
+{{{
+#!sql
+-- pt - center point
+-- rx, ry - X radius, Y radius
+-- rotation - CW rotation in radians
+-- quadSeg - number of segments in a quadrant
+ 
+CREATE OR REPLACE FUNCTION ST_Ellipse(
+  pt geometry, 
+  rx double precision, ry double precision, 
+  rotation double precision DEFAULT 0.0, 
+  quadSeg integer DEFAULT 8)
+ RETURNS geometry AS
+ $$
+   SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, quadSeg), rx, ry), rotation), ST_X(pt), ST_Y(pt))
 $$
  LANGUAGE 'sql';