gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
edit_com_lieux_dits
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN SELECT c.id_com into NEW.id_com FROM adresse.commune c WHERE ST_DWithin(NEW.geom, c.geom, 0.01); NEW.numero = 99999 ; NEW.date_der_maj = NOW(); RETURN NEW; END;