1 CREATE OR REPLACE FUNCTION comment_aggregates_comment ()
6 IF (TG_OP = 'INSERT') THEN
7 INSERT INTO comment_aggregates (comment_id)
9 ELSIF (TG_OP = 'DELETE') THEN
10 DELETE FROM comment_aggregates
11 WHERE comment_id = OLD.id;
17 CREATE OR REPLACE FUNCTION post_aggregates_post ()
22 IF (TG_OP = 'INSERT') THEN
23 INSERT INTO post_aggregates (post_id)
25 ELSIF (TG_OP = 'DELETE') THEN
26 DELETE FROM post_aggregates
27 WHERE post_id = OLD.id;
33 CREATE OR REPLACE FUNCTION community_aggregates_community ()
38 IF (TG_OP = 'INSERT') THEN
39 INSERT INTO community_aggregates (community_id)
41 ELSIF (TG_OP = 'DELETE') THEN
42 DELETE FROM community_aggregates
43 WHERE community_id = OLD.id;