Rahmadnet

add Trigger

Aug 30th, 2019
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION log_last_name_changes()
  2.     RETURNS TRIGGER AS
  3. $BODY$
  4. BEGIN
  5.     IF NEW.last_name <> OLD.last_name THEN
  6.     INSERT INTO ht_salarycomponent_audit(ht_salarycomponent_audit_id, ad_client_id, ad_org_id, createdby, updatedby,
  7.                 ht_salarycomponent_id, first_name, last_name, changed_on)
  8.                 VALUES (get_uuid(), OLD.ad_client_id, OLD.ad_org_id, OLD.createdby, OLD.updatedby,
  9.                 OLD.ht_salarycomponent_id, OLD.first_name, OLD.last_name, now());
  10.            
  11.             END IF;
  12.         RETURN NEW;
  13. END;
  14. $BODY$ LANGUAGE plpgsql;
  15.  
  16. CREATE TRIGGER last_name_changes
  17.     BEFORE UPDATE
  18.     ON ht_salarycomponent
  19.     FOR EACH ROW
  20.     EXECUTE PROCEDURE log_last_name_changes();
Advertisement
Add Comment
Please, Sign In to add comment