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

[Clifford Snow]

On Fri, May 24, 2013 at 11:21 AM, Hugues François <hugues.francois at irstea.fr
> wrote:

> You should try :
>
> update nodes a
> set outline_id = b.outline_id
> from outlines b
> where st_contains(b.geom, a.geom)
>
> Hugues.
>

That worked perfectly. I must have been trying to over think the problem.
Thanks


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