[postgis-users] How to Update Geometry table

[strk]

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