X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4D0DDD1B267 for ; Wed, 7 Jul 2004 04:28:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13054-02 for ; Wed, 7 Jul 2004 07:27:09 +0000 (GMT) Received: from serwer.skawsoft.com.pl (rtr.skawsoft.com.pl [213.25.37.67]) by svr1.postgresql.org (Postfix) with ESMTP id D44A4D1B26C for ; Wed, 7 Jul 2004 04:19:39 -0300 (ADT) Received: from [192.168.24.1] (unknown [80.51.253.214]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 63E6D2B3CD; Wed, 7 Jul 2004 09:19:12 +0200 (CEST) Message-ID: <40EBA43A.4070802@klaster.net> Date: Wed, 07 Jul 2004 09:20:26 +0200 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.7) Gecko/20040514 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: "Pradeepkumar, Pyatalo (IE10)" Cc: pgsql-sql@postgresql.org Subject: Re: Triggers - need help !!! References: <77ED2BF75D59D1439F90412CC5B109740E88BEC1@ie10-sahara.hiso.honeywell.com> In-Reply-To: <77ED2BF75D59D1439F90412CC5B109740E88BEC1@ie10-sahara.hiso.honeywell.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.4 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM, PLING_PLING X-Spam-Level: ** X-Archive-Number: 200407/29 X-Sequence-Number: 18281 On 2004-07-07 08:45, Użytkownik Pradeepkumar, Pyatalo (IE10) napisał: > Hi, > > I am writing some triggers for my project. > I am writing a trigger on a table after delete....I want to know how u refer > to the row that is being deleted. > > For example for a trigger function after INSERT/UPDATE u refer to the row > being inserted/updated using NEW like this.... Use OLD instead of NEW. You can also use OLD inside UPDATE triggers - you have access to row before update. Regards, Tomasz Myrta