create language plpgsql
--创建procedure
CREATE FUNCTION function_equipment_isdue() RETURNS trigger AS $$
BEGIN
update users set username = "administrator" where userid = 1;
return NEW; -- new 等同于oracle中的:new
--注:这里必须返回值, 如果不反悔则会抛出错误.
END;
$$LANGUAGE plpgsql;
如果数据库抛出 没有plpgsql的错误时. 执行
create language plpgsql
语句添加此语言即可.
--创建trigger.
CREATE TRIGGER trigger_equip_isdue
BEFORE INSERT ON userlogin FOR EACH ROW EXECUTE PROCEDURE function_equipment_isdue();