webco_8.0
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_res_allocs_on_trigger
Parameters
Name
Type
Mode
Definition
begin IF (TG_OP = 'INSERT') THEN perform update_res_allocs(NEW.scheduled_resource_oid); ELSIF (TG_OP = 'DELETE') THEN perform update_res_allocs(OLD.scheduled_resource_oid); ELSE perform update_res_allocs(OLD.scheduled_resource_oid); perform update_res_allocs(NEW.scheduled_resource_oid); END IF; RETURN NEW; end