CREATE OR REPLACE PROCEDURE number_students() LANGUAGE 'plpgsql' AS $BODY$ BEGIN IF (SELECT COUNT(student_id) FROM student) IF (number > 25) THEN SET MESSAGE_TEXT = 'enough students'; COMMIT; END; $BODY$; CALL number_students();
10/24/2020 4:03:40 PM
W. Khalid0 Answers
New AnswerSololearn Inc.
535 Mission Street, Suite 1591Send us a message