egdb3_11_7
.action
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
age_parent_circ_on_delete()
Parameters
Name
Type
Mode
IN
Definition
BEGIN -- Having deleted a renewal, we can delete the original circulation (or a previous -- renewal, if that's what parent_circ is pointing to). That deletion will trigger -- deletion of any prior parents, etc. recursively. IF OLD.parent_circ IS NOT NULL THEN DELETE FROM action.circulation WHERE id = OLD.parent_circ; END IF; RETURN OLD; END;