ahmet temiz wrote:
hello
I couldn't manage to update a table containing line geometry.
I want to update id_no of these line with the polygons' id_no that
contain these lines.
something like:
line id will be polygon id, where polygons contain lines involved.
update line as a set a.id_no=b.id_no from polygons b where a.the_geom
<relationship> b.the_geom;
Replace <relationship> with the spatial relationship you are interested
in. This will likely fail if the where clause returns more than one
record. For example you have two overlapping polygons and both of them
contain the line you are testing.
-Steve
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
