-- -- 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;