触发器函数:
CREATE FUNCTION order_status () RETURNS TRIGGER AS $status$
BEGIN
IF ( NEW.status = 3 ) THEN
NEW.status := 3;
ELSE
NEW.status := 2;
END IF;
RETURN NEW;
END $status$ LANGUAGE plpgsql;
创建触发器:
CREATE TRIGGER order_status BEFORE UPDATE OF status ON public.hd_order FOR EACH ROW EXECUTE PROCEDURE public.order_status();
删除函数:DROOP function order_status ();