[Portugal] Intersectar tabelas Postgis

[Pedro Monteiro]

Falta a referencia às plantas_emitas na clausula FROM

Será assim

UPDATE plantas_emitidas
SET (dicofre_plantas, freguesia) =
(SELECT a.dicofre, a.freguesia
             FROM caop_2010 as a, plantas_emitidas as b
            WHERE ST_CONTAINS(a.the_
geom, b.the_geom));


Cumprimentos,
Pedro Monteiro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/portugal/attachments/20110714/059124e6/attachment-0001.html