opengauss创建函数和触发器

最新推荐文章于 2024-07-09 11:16:21 发布

叔本华的尼采

最新推荐文章于 2024-07-09 11:16:21 发布

阅读量960

点赞数

文章标签： postgresql

本文链接：https://blog.csdn.net/m0_51605778/article/details/128129355

版权

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();