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
_______________________________________________ Portugal mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/portugal
