触发器

参考：http://blog.csdn.net/neo_liu0000/article/details/6255623

http://www.cnblogs.com/stephen-liu74/archive/2012/06/08/2315679.html

 

1，案例

===定义触发器函数============================

-- Function: td_student_sms()

-- DROP FUNCTION td_student_sms();

CREATE OR REPLACE FUNCTION td_student_sms()
  RETURNS trigger AS
$BODY$
BEGIN
  IF NEW.warn_level <> '00' THEN
    insert into td_student_sms(phone_num,message_content,send_status,create_time,warn_level) values('66666666666',NEW.rule_result,0,current_timestamp,to_number(NEW.warn_level,'99'));
  END IF;
  RETURN NULL;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION td_student_sms()
  OWNER TO postgres;

 

====为表添加插入的触发器事件=======
-- Trigger: td_student_sms on td_student_result

-- DROP TRIGGER td_student_sms ON td_student_result;

CREATE TRIGGER td_student_sms
  AFTER INSERT
  ON td_student_result
  FOR EACH ROW
  EXECUTE PROCEDURE td_student_sms();