Guest User

Untitled

a guest
Jun 21st, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION cascade_modify_time() RETURNS trigger AS $cascade_modify_time$
  2. BEGIN
  3. EXECUTE 'UPDATE ' || quote_ident(TG_ARGV[0]) || ' SET modified=CURRENT_TIMESTAMP WHERE id = NEW.' || quote_ident(TG_ARGV[1]);
  4. RETURN NULL;
  5. END;
  6. $cascade_modify_time$ LANGUAGE plpgsql;
  7.  
  8.  
  9.  
  10. CREATE TRIGGER page_modify_trigger
  11. AFTER INSERT OR UPDATE OR DELETE ON pages FOR EACH ROW
  12. EXECUTE PROCEDURE cascade_modify_time('almanacs','almanac_id');
Add Comment
Please, Sign In to add comment