<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Apenas para referência futura na BD da mailing list, deixo aqui a função tigger que permite inserir os dois campos (dicofre e freguesia):</span></div><div><br><span></span></div><div><span><font size="2">CREATE OR REPLACE FUNCTION preenche_dicofre_freguesia_plantas()<br>RETURNS TRIGGER AS<br>$BODY$<br>BEGIN <br>SELECT dicofre INTO NEW.dicofre<br>FROM caop_2010<br>WHERE st_contains(caop_2010.the_geom, NEW.the_geom);<br>SELECT freguesia INTO NEW.freguesia<br>FROM caop_2010<br>WHERE st_contains(caop_2010.the_geom, NEW.the_geom);<br>RETURN NEW;<br>END;<br>$BODY$<br>LANGUAGE plpgsql VOLATILE </font><br></span></div><div><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font
face="Arial" size="2"><font style="font-family: times new roman,new york,times,serif;" size="3">e a trigger para a tabela de pontos</font>:<br><br><font style="font-family: times new roman,new york,times,serif;" size="2">CREATE TRIGGER update_dicofre_freguesia_plantas<br> BEFORE INSERT OR UPDATE<br> ON plantas_emitidas<br> FOR EACH ROW<br> EXECUTE PROCEDURE </font></font><font style="font-family: times new roman,new york,times,serif;" size="2"><span>preenche_dicofre_freguesia_plantas()</span></font><br><br><br><div id="yiv1611905280"><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: times new roman,new york,times,serif; font-size: 12pt;"><br>Abraço!<br>Pedro<br></div></div><br><br></div></div></div></body></html>