Received: from mercury.sterlingdi.com (mercury.sterlingdi.com [204.183.83.11]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA49292 for ; Mon, 20 Dec 1999 10:01:27 -0500 (EST) (envelope-from linderdm@ironhilltech.com) Received: from stargate.sterlingdi.com (stargate.sterlingdi.com [204.183.83.3]) by mercury.sterlingdi.com (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with SMTP id KAA03361 for ; Mon, 20 Dec 1999 10:02:19 -0500 Received: from hermes.gg.sterlingdi.com by stargate.sterlingdi.com via smtpd (for mercury.sterlingdi.com [204.183.83.11]) with SMTP; 20 Dec 1999 14:29:12 UT Received: from brewmaster.eng.ironhilltech.com (IDENT:root@brewmaster.eng.sterlingdi.com [207.169.171.37]) by hermes.gg.sterlingdi.com (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with ESMTP id KAA31725 for ; Mon, 20 Dec 1999 10:01:07 -0500 Received: from guinness (guinness.eng.ironhilltech.com [192.168.140.230]) by brewmaster.eng.ironhilltech.com (8.9.3/8.9.3) with SMTP id KAA19185 for ; Mon, 20 Dec 1999 10:09:30 -0500 Message-ID: <005601bf4afb$2cf7b060$e68ca8c0@eng.ironhilltech.com> From: "Dan Linderman" To: Subject: Trigger tables Date: Mon, 20 Dec 1999 10:02:03 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-Mimeole: Produced By Microsoft MimeOLE V5.00.2314.1300 Does PostgreSQL have tables to store current rows for use in Triggers like Sybase has? Sybase has a "deleted" and an "inserted" table that stores the rown being worked on in an insert or deleter so the data can be used in a trigger. Dan Linderman Web Programmer Iron Hill Technology linderdm@ironhilltech.com 302-369-9750 x23 www.ironhilltech.com