-- -- views_views_upd_tr/0 -- create or replace function views_views_upd_tr( ) returns trigger as $$ BEGIN UPDATE view_aggregates SET views_count = views_count + 1, last_viewed = now() WHERE object_id = new.object_id; return new; END; $$ language plpgsql;