-- -- views_by_type_ins_tr/0 -- create or replace function views_by_type_ins_tr( ) returns trigger as $$ BEGIN if not exists (select 1 from view_aggregates_by_type where object_id = new.object_id and view_type = new.view_type) then INSERT INTO view_aggregates_by_type (object_id,view_type,views_count,unique_views,last_viewed) VALUES (new.object_id,new.view_type,1,1,now()); else UPDATE view_aggregates_by_type SET views_count = views_count + 1, unique_views = unique_views + 1, last_viewed = now() WHERE object_id = new.object_id AND view_type = new.view_type; end if; return new; END; $$ language plpgsql;