[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] How to Update Geometry table
From:       strk <strk () keybit ! net>
Date:       2010-09-30 13:40:17
Message-ID: 20100930134017.GA48387 () keybit ! net
[Download RAW message or body]

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
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]