create trigger calculate_updated_job_line_insert before insert on public.joblines for each row execute function calculate_job_line();