Changes between Version 29 and Version 30 of UsersWikiplpgsqlfunctions

Timestamp:

Aug 5, 2020, 10:38:19 AM (4 years ago)

Author:

mdavis

Comment:

—

UsersWikiplpgsqlfunctions

@@ -1 +1 @@
 
-= Additional User-contributed Functions =
+= User-contributed Functions =
  
-This is an area to put utility functions or wrappers around PostGIS
-[wiki:UsersWikiplpgsqlfunctionsDistance Distance /Spatial Reference support functions PL/PGSQL/SQL Functions]
+This is an area to put utility functions or wrappers around PostGIS.
 
 == Construct an arc given two points on the arc, the centre point and direction or size ==
@@ -9 +8 @@
 {{{
 #!sql
- CREATE FUNCTION st_createarc(startpoint geometry, endpoint geometry, arcenter geometry, direction text) RETURNS geometry
+ CREATE FUNCTION ST_Arc(startpoint geometry, endpoint geometry, arcenter geometry, direction text) RETURNS geometry
     AS $$
   DECLARE
@@ -179 +178 @@
 }}}
 
-== Construct Ellipse (x,y,rx,ry,rotation,#of segments in 1/4 of ellipse) ==
-{{{
-#!sql
-CREATE OR REPLACE FUNCTION ST_Ellipse(double precision, double precision, double precision, double precision, double precision, integer)
+== Construct Ellipse ( x,y, rx,ry [,rotation [,#of segments in 1/4 of ellipse] ] ) ==
+{{{
+#!sql
+CREATE OR REPLACE FUNCTION ST_Ellipse(x double precision, y double precision, 
+  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, $6), $3, $4), $5), $1, $2)
+   SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, quadSeg), rx, ry), rotation), x, y)
 $$
  LANGUAGE 'sql';