Re: Delete/Replace Bug in Functions?

Josh Berkus <josh@agliodbs.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