yki
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
error_if_exceeds_participant_limit()
Parameters
Name
Type
Mode
IN
Definition
DECLARE actual_kind TEXT := ( select_registration_kind(NEW.exam_session_id) ); BEGIN IF NEW.kind = 'QUEUE' AND actual_kind = 'ADMISSION' THEN RAISE EXCEPTION 'registration to queue is not available'; ELSIF NEW.kind = 'ADMISSION' AND actual_kind = 'QUEUE' THEN RAISE EXCEPTION 'max_participants of exam_session exceeded.'; ELSE RETURN NEW; END IF; END;