CREATE OR REPLACE FUNCTION process_del_dept() RETURNS TRIGGER AS $new_dept$
    BEGIN
        if(TG_OP = 'DELETE') THEN
            DELETE FROM new_Emp WHERE new_Emp.deptno = OLD.deptno;
        END IF;
        RETURN NULL;
    END;
$new_dept$ LANGUAGE plpgsql;


CREATE OR REPLACE TRIGGER del_dept
AFTER DELETE ON new_dept
    FOR EACH ROW EXECUTE FUNCTION process_del_dept();