Advertisement
Guest User

Untitled

a guest
May 28th, 2020
410
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION function1() RETURNS trigger AS
  2. $$
  3. BEGIN
  4. SELECT a.field_1
  5. into new.field_1
  6. FROM relation_a a
  7. WHERE a.id_a = new.fk_a;
  8.  
  9. RETURN new;
  10. END
  11. $$
  12. LANGUAGE PLPGSQL;
  13.  
  14. DROP TRIGGER IF EXISTS trigger1 on relation_b;
  15. CREATE TRIGGER trigger1
  16. BEFORE UPDATE OR INSERT
  17. ON relation_b
  18. FOR EACH ROW EXECUTE PROCEDURE function1();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement