[postgis-users] Need help with update table from a select query

[Clifford Snow]

I need some help figuring out how to update a table. I'm trying to get the
polygon id that a node resides in. I have two tables, one of outlines and
another with nodes. I want to add the id of the outline the node is
contained in to the node.

my thought was this query:
update nodes set outline_id = (select outline_id from oulines, nodes where
st_contains(outline.geom, nodes,geom))

But this query returns more than one row. What am I doing wrong?

Thanks
-- 
Clifford
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130524/e38965b7/attachment.html>