Received: from kcpgw.kcp.com (kcpgw.kcp.com [198.62.69.65]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eB1BjEF83961 for ; Fri, 1 Dec 2000 06:45:14 -0500 (EST) (envelope-from hook@kcp.com) Message-Id: <200012011145.eB1BjEF83961@mail.postgresql.org> Received: by kcpgw.kcp.com id FAA16271 (InterLock SMTP Gateway 4.2 for pgsql-sql@postgresql.org); Fri, 1 Dec 2000 05:45:29 -0600 Received: by kcpgw.kcp.com (Internal Mail Agent-2); Fri, 1 Dec 2000 05:45:29 -0600 Received: by kcpgw.kcp.com (Internal Mail Agent-1); Fri, 1 Dec 2000 05:45:29 -0600 Date: Fri, 01 Dec 2000 11:44:29 +0000 From: "A. Van Hook" Organization: AlliedSignal X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.0.36 i686) X-Accept-Language: en Mime-Version: 1.0 To: pgsql-sql@postgresql.org Subject: arhiving rule Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/4 X-Sequence-Number: 335 I have, what I think is a simple rule to arrive transactions: create rule usageupdt as on update to usage do insert into usageHistory (lkey, jan, feb, mar, bowner, penalty, prepay, bal, notes, change) values (new.lkey, old.jan, old.feb, old.mar, old.bowner, old.penalty, old.prepay, old.bal, old.notes, 'now') the only problem is that once is rule is created, new rows in the archive table all have the same date! -the date when the rule was created.... thanks art