DECLARE
leid integer;
BEGIN
SELECT c.id_com into leid FROM adresse.commune c WHERE st_intersects(New.geom,c.geom);
NEW.id_commune = leid;
RETURN NEW;
END;