Changes between Version 1 and Version 2 of UsersWikiComputeMultiCentroid

Timestamp:

May 26, 2009, 3:23:53 AM (15 years ago)

Author:

Mike Taves

Comment:

clean up

UsersWikiComputeMultiCentroid

@@ -1 +1 @@
 = Compute Multi Centroid =
-
-
 
 {{{
@@ -10 +8 @@
  --
  -- Usage:
- -- postgis=# select [ST_AsText|http://postgis.refractions.net/documentation/manual-svn/ST_AsText.html](ST_!MultiCentroid(
+ -- postgis=# select ST_AsText.html(ST_MultiCentroid(
  -- postgis(#       'MULTIPOLYGON (
  -- postgis'#         (( 0 0, 0 1, 1 1, 1 0, 0 0 )),
@@ -20 +18 @@
  --( 1 row)
  --
- -- DROP FUNCTION ST_!MultiCentroid(geometry);
+ -- DROP FUNCTION ST_MultiCentroid(geometry);
 
- CREATE OR REPLACE FUNCTION ST_!MultiCentroid(geometry)
+ CREATE OR REPLACE FUNCTION ST_MultiCentroid(geometry)
    RETURNS geometry AS
- $BODY$SELECT [ST_Collect|http://postgis.refractions.net/documentation/manual-svn/ST_Collect.html](the_geom)
+ $BODY$SELECT ST_Collect(the_geom)
  FROM (
-  SELECT [ST_Centroid|http://postgis.refractions.net/documentation/manual-svn/ST_Centroid.html](([ST_Dump|http://postgis.refractions.net/documentation/manual-svn/ST_Dump.html]([ST_Multi|http://postgis.refractions.net/documentation/manual-svn/ST_Multi.html]($1))).geom) AS the_geom
+  SELECT ST_Centroid((ST_Dump(ST_Multi($1))).geom) AS the_geom
  ) AS foo;$BODY$
    LANGUAGE 'sql' IMMUTABLE
    COST 100;
-
 }}}