Josh Berkus <josh(at)agliodbs(dot)com> writes:
> ones. Here's the relevant code:
> IF v_usq > 0 THEN -- Note: v_usq is > 0 for all existing records
> DELETE FROM order_spec WHERE order_usq = v_usq;
> END IF;
> ...
> INSERT INTO order_spec ( job_type, order_usq, no_needed, start_time,
> end_time, pay_rate, bill_rate )
> VALUES ( current_type, new_usq, numbers[spec_loop], sttimes[spec_loop],
> endtimes[spec_loop],
> pays[spec_loop], bills[spec_loop] );
Um, might v_usq be different from new_usq?
regards, tom lane