gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
get_code_postal
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN SELECT a.cp into NEW.code_postal FROM adresse.codes_postaux a WHERE ST_intersects(NEW.geom, a.geom); RETURN NEW; END;