X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9DB23D1B513 for ; Fri, 19 Sep 2003 10:56:24 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 12576-05 for ; Fri, 19 Sep 2003 07:55:55 -0300 (ADT) Received: from seabird.siptech.co.in (unknown [202.54.64.126]) by svr1.postgresql.org (Postfix) with ESMTP id E1745D1B50B for ; Fri, 19 Sep 2003 07:55:40 -0300 (ADT) Received: from hornet2.siptech.co.in (hornet2 [192.168.64.197]) Received: from hornet2.siptech.co.in (hornet2.siptech.co.in [127.0.0.1]) by hornet2.siptech.co.in (8.12.8/8.12.8) with ESMTP id h8JB1BF3026497 for ; Fri, 19 Sep 2003 16:31:11 +0530 Received: (from apache@localhost) by hornet2.siptech.co.in (8.12.8/8.12.8/Submit) id h8JB1A33026495; Fri, 19 Sep 2003 16:31:10 +0530 X-Authentication-Warning: hornet2.siptech.co.in: apache set sender to thilakbabu@siptech.co.in using -f Received: from 192.168.64.193 (SquirrelMail authenticated user thilakbabu) by mail2.siptech.co.in with HTTP; Fri, 19 Sep 2003 16:31:10 +0530 (IST) Message-ID: <63970.192.168.64.193.1063969270.squirrel@mail2.siptech.co.in> Date: Fri, 19 Sep 2003 16:31:10 +0530 (IST) Subject: Reg: Firing Trigger when a particular column value get changed From: "Thilak babu" To: pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: SIP - Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/229 X-Sequence-Number: 15207 Hi All, I have a scnerio as to fire a trigger when i update a particular column in a table. Please do help me out in getting thro this. Thanks in advance, Thilak .