Changeset 5605

Timestamp:

05/03/10 10:35:06 (2 years ago)

Author:

jorgearevalo

Message:

Implemented ST_Polygon function. Related ticket #297.

Files:

• spike/wktraster/rt_pg/rtpostgis.sql.in.c (modified) (1 diff)

spike/wktraster/rt_pg/rtpostgis.sql.in.c

@@ -381 +381 @@
         SELECT st_geomfromtext(wktgeomval.wktgeom, wktgeomval.srid), wktgeomval.val
         FROM dumpaswktpolygons($1, $2) AS wktgeomval;
+    $$ LANGUAGE 'SQL' _IMMUTABLE_STRICT;
+
+CREATEFUNCTION st_polygon(raster, integer) RETURNS geometry AS $$
+        SELECT st_collect(f.geom) as singlegeom from (select
+                (st_dumpaspolygons($1, $2)).geom as geom) as f;
+    $$ LANGUAGE 'SQL' _IMMUTABLE_STRICT;
+
+CREATEFUNCTION st_polygon(raster) RETURNS geometry AS $$        
+        SELECT st_collect(f.geom) as singlegeom from (select
+                (st_dumpaspolygons($1, 1)).geom as geom) as f;
     $$ LANGUAGE 'SQL' _IMMUTABLE_STRICT;