Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9EF29475DDB for ; Mon, 21 Oct 2002 18:44:25 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id F390A475C26 for ; Mon, 21 Oct 2002 18:44:24 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9LMiChR009895; Mon, 21 Oct 2002 18:44:12 -0400 (EDT) To: josh@agliodbs.com Cc: pgsql-sql@postgresql.org Subject: Re: Delete/Replace Bug in Functions? In-reply-to: <200210211531.19436.josh@agliodbs.com> References: <200210211531.19436.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Mon, 21 Oct 2002 15:31:19 -0700" Date: Mon, 21 Oct 2002 18:44:11 -0400 Message-ID: <9894.1035240251@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/264 X-Sequence-Number: 9981 Josh Berkus 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