[postgis-devel] polygonize

Carl Anderson carl.anderson at vadose.org
Sun Dec 19 08:22:09 PST 2004


Since polygonize() seems to able to act as a general polygon cleaning 
function
how about adding a direct function to call it, in addition to the 
aggregate form.

update shapes set the_geom = polygonize(the_geom);

so we don't have to

update shapes set the_geom = f.new_geom
     from ( select polygonize(the_geom) as new_geom, gid
                     from shapes
                     group by gid ) as f
   where
          f.gid = shapes.gid;

btw

select polygonize_garray(array_append('{}',the_geom) from shapes;
Causes a backend ABEND;


   C.                



More information about the postgis-devel mailing list