CREATE OR REPLACE FUNCTION fun1()
RETURN TRIGGER AS $check_team$
DECLARE msg varchar(100);
BEGIN
IF select team_id from staff where staff_id = NEW.staff_id NOT IN
select team_id from route where route_id = NEW.route_id
THEN
SET msg = CONCAT('该员工所属车队与线路所属车队不同,请重新录入');
SIGNAL SQLSTATE 'HY000' SET MESSAGE_TEXT = msg;
END IF;
END;
$check_team$ LANGUAGE plpgsql;
CREATE TRIGGER check_teamid BEFORE INSERT ON worklist
FOR EACH STATEMENT
EXECUTE FUNCTION fun1();
08-06
08-06
08-06
08-06
08-06
05-31