X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 208819FB252 for ; Wed, 2 Aug 2006 08:04:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31266-01 for ; Wed, 2 Aug 2006 08:03:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 70A1D9FB24F for ; Wed, 2 Aug 2006 08:03:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail009.ownmail.com (unknown [203.199.110.93]) by svr4.postgresql.org (Postfix) with ESMTP id AA0665AF027 for ; Wed, 2 Aug 2006 11:03:50 +0000 (GMT) Received: (from domains@localhost) by mail009.ownmail.com (8.12.11/8.12.10) id k72B3dsU018810; Wed, 2 Aug 2006 16:33:39 +0530 Date: Wed, 2 Aug 2006 16:33:39 +0530 Message-Id: <200608021103.k72B3dsU018810@mail009.ownmail.com> X-Originating-IP: 203.199.110.93 Reply-To: From: To: pgsql-interfaces@postgresql.org Subject: change tuple before insert MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.77 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, NO_REAL_NAME X-Spam-Level: * Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200608/3 X-Sequence-Number: 6217 How do i change the contents of a tuple for a row level trigger? do i have to return tg_trigtuple or tg_newtuple? The doc is confusing. it says a tg_newtuple can only be used in case of an update> With warm regards. Vivek J. Joshi. vivek@staff.ownmail.com Trikon electronics Pvt. Ltd. All science is either physics or stamp collecting. -- Ernest Rutherford