gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_appartenir_com
Parameters
Name
Type
Mode
Definition
DECLARE leid integer; BEGIN INSERT INTO adresse.appartenir_com(id_voie, id_com) SELECT NEW.id_voie, c.id_com from adresse.commune c where ST_intersects(NEW.geom, c.geom); RETURN NEW; END;