--
-- views_by_type_upd_tr/0
--
create or replace function views_by_type_upd_tr(
  
) returns trigger as $$

BEGIN
    UPDATE view_aggregates_by_type 
       SET views_count = views_count + 1, last_viewed = now() 
     WHERE object_id = new.object_id
       AND view_type = new.view_type;

    return new;
END;
$$ language plpgsql;