Advertisement
Maks140888

Untitled

Jun 6th, 2022
1,126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table list_changes (
  2.     cind_operation varchar(100),
  3.     change_time TIMESTAMP
  4. );
  5.  
  6. CREATE OR REPLACE FUNCTION process_check_changes() RETURNS TRIGGER AS $new_emp$
  7.     BEGIN
  8.         if(TG_OP = 'UPDATE') THEN
  9.             INSERT INTO list_chahges(cind_operation, change_time) VALUES('update row', NOW());
  10.         ELSIF (TG_OP = 'DELETE') THEN
  11.             INSERT INTO list_chahges(cind_operation, change_time) VALUES('delete row', NOW());
  12.         ELSIF (TG_OP = 'INSERT') THEN
  13.             INSERT INTO list_chahges(cind_operation, change_time) VALUES('add new row', NOW());
  14.         END IF;
  15.         RETURN NULL;
  16.     END;
  17. $new_emp$ LANGUAGE plpgsql;
  18.  
  19. CREATE TRIGGER update_list_changes
  20. AFTER INSERT OR UPDATE OR DELETE ON sheldule
  21.     FOR EACH ROW EXECUTE FUNCTION process_check_changes();
  22.  
  23.  
  24.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement