gis
.gobs
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_observation_on_spatial_object_change()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF TG_OP = 'UPDATE' AND NOT ST_Equals(NEW.geom, OLD.geom) THEN UPDATE gobs.observation SET updated_at = now() WHERE fk_id_spatial_object = NEW.id ; END IF; RETURN NEW; END;