gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
get_commune
Parameters
Name
Type
Mode
Definition
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;