yki
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
error_if_reviewed_quarantine_is_deleted()
Parameters
Name
Type
Mode
IN
Definition
DECLARE existing_quarantine NUMERIC := ( SELECT count(*) FROM quarantine WHERE id = NEW.quarantine_id AND deleted_at IS NULL ); BEGIN IF existing_quarantine > 0 THEN RETURN NEW; ELSE RAISE EXCEPTION 'Reviewed quarantine non-existing or deleted'; END IF; END;