On Thu, Sep 30, 2010 at 06:09:27PM +0530, venkat wrote: > Dear All, > > How can I update geometry table...Please anyone guide me. > > I am trying below query ,but i am getting error. > > update split_polys10 > set geom =( SELECT geom FROM dump (( > SELECT polygonize(geomunion(boundary(poly.geom),'LINESTRING (34.99 > 7.055,2.74 0.936)')) > FROM poly > ))); > > ERROR: more than one row returned by a subquery used as an expression
FYI: PostGIS development version has an ST_Split function Anyway your query above (select geom from dump) returns a set, which you can't assign to a single record (geom =). Maybe you meant to *create* split_polys10 from that subquery ? --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
