yki
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
select_registration_phase(exam_session_id bigint, at_point_in_time timestamp with time zone DEFAULT now())
Parameters
Name
Type
Mode
exam_session_id
bigint
IN
at_point_in_time
timestamp with time zone
IN
Definition
DECLARE registration_phase record; BEGIN SELECT INTO "registration_phase" (SELECT * FROM exam_session_registration_open(exam_session_id, at_point_in_time)) AS admission_active, (SELECT * FROM exam_session_post_registration_open(exam_session_id, at_point_in_time)) AS post_admission_active FROM "exam_session" es LEFT JOIN "exam_date" "ed" ON es."exam_date_id" = "ed"."id" WHERE es."id" = exam_session_id; IF registration_phase.admission_active THEN RETURN 'ADMISSION'; ELSIF registration_phase."post_admission_active" THEN RETURN 'POST_ADMISSION'; ELSE RETURN 'OTHER'; END IF; END;