Received: from hotmail.com (f184.pav2.hotmail.com [64.4.37.184]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB55l0m39090 for ; Wed, 5 Dec 2001 00:47:00 -0500 (EST) (envelope-from hihajime@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 4 Dec 2001 21:47:05 -0800 Received: from 210.160.156.177 by pv2fd.pav2.hotmail.msn.com with HTTP; Wed, 05 Dec 2001 05:47:05 GMT X-Originating-IP: [210.160.156.177] From: "kiyo taka" To: pgsql-sql@postgresql.org Subject: plpgsql before insert update delete Date: Tue, 04 Dec 2001 22:47:05 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-2022-jp; format=flowed Message-ID: X-OriginalArrivalTime: 05 Dec 2001 05:47:05.0305 (UTC) FILETIME=[45169C90:01C17D50] X-Archive-Number: 200112/71 X-Sequence-Number: 5894 hi all. i'd like to noe how to create trigger which will insert tablez old data into an archive table before any(insert,update,delete) operation is executed. i've tried "if inserting ...." but it didnt work. is there any function that will do it? any help will be greatly appreciated. thanx. _________________________________________________________________ かわいい & 使えるブラウザで、インターネット生活もっと楽しくなる! http://explorer.msn.co.jp/