How to i make a procedure in PostgreSQL using IF-statements and a print?
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();
I have tried every way I could find but still I can't display my local images ..what am I doing wrong?
Pls rectify the errors.
I cant understand what the problem here is. Can anyone help me out? the system in sololearn called it an error in test case 1
Izzy the iguana code coach