Received: from ccis01.baylor.edu (ccis01.baylor.edu [129.62.1.18]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB6Lwem04327 for ; Thu, 6 Dec 2001 16:58:40 -0500 (EST) (envelope-from thornton@cs.baylor.edu) Received: from cs.baylor.edu (ppp-208-189-124-23.dialup.wacotx.swbell.net [208.189.124.23]) by ccis01.baylor.edu (8.9.1/8.9.1) with ESMTP id PAA1372259; Thu, 6 Dec 2001 15:58:35 -0600 (CST) Message-ID: <3C0CCFB3.5A9C614B@cs.baylor.edu> Date: Tue, 04 Dec 2001 07:29:23 -0600 From: James Thornton X-Mailer: Mozilla 4.76C-SGI [en] (X11; I; IRIX 6.5 IP32) X-Accept-Language: en MIME-Version: 1.0 To: Gregory Wood CC: PostgreSQL-General Subject: Re: update returns 1, but no changes have been made References: <3C08A694.86E4153B@cs.baylor.edu> <004301c17e83$365a07d0$7889ffcc@comstock.com> <3C0CBA36.8B0207AF@cs.baylor.edu> <003101c17e95$d0f29430$7889ffcc@comstock.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/271 X-Sequence-Number: 18374 Gregory Wood wrote: > If you return old from an UPDATE, no changes are made (it takes the old > values and puts them into the database rather than your new values). Of > course you need to return old from a DELETE (new doesn't exist in a delete > trigger)... That was it -- thanks for your help Gregory. JT ________________________________________ James Thornton, http://jamesthornton.com