Changes between Version 7 and Version 8 of UsersWikiplpgsqlfunctions

Timestamp:

Apr 19, 2009, 12:41:32 AM (15 years ago)

Author:

robe

Comment:

—

UsersWikiplpgsqlfunctions

@@ -75 +75 @@
 
 {{{
+#!sql
 Example use: - where the_geom is a multipolygon
  SELECT fnpoly_to_rings(the_geom)
@@ -82 +83 @@
  RETURNS geometry AS
  $$
- SELECT collect(the_line)  as multiline
+ SELECT ST_Collect(the_line)  as multiline
  FROM (SELECT ST_ExteriorRing(the_poly) as the_line
         FROM (SELECT ST_GeometryN($1, g.n) As the_poly