ACS3 Data Model

     1: function activity_since (v_user_id IN INTEGER, since IN DATE)
     2: return INTEGER
     3: as
     4:   n_posts	INTEGER;
     5:   n_comments	INTEGER;
     6: begin
     7:   select count(*) into n_posts from bboard where user_id = v_user_id and posting_time > since;
     8:   select count(*) into n_comments from comments where user_id = v_user_id and posting_time > since;
     9:   return n_posts + n_comments;
    10: end activity_since;