tww
.tww_app
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
symbology_on_wastewater_structure_update()
Parameters
Name
Type
Mode
IN
Definition
DECLARE _ws_obj_id TEXT; BEGIN -- Prevent recursion IF COALESCE(OLD.identifier, '') = COALESCE(NEW.identifier, '') THEN RETURN NEW; END IF; _ws_obj_id = OLD.obj_id; SELECT tww_app.update_wastewater_structure_label(_ws_obj_id) INTO NEW._label; IF OLD.fk_main_cover != NEW.fk_main_cover THEN EXECUTE tww_app.update_depth(_ws_obj_id); END IF; RETURN NEW; END;