X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E2A5F474E42 for ; Thu, 10 Apr 2003 13:55:04 -0400 (EDT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by postgresql.org (Postfix) with ESMTP id A803047592C for ; Thu, 10 Apr 2003 13:54:58 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 193gGI-000Mr8-0X; Thu, 10 Apr 2003 18:54:58 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 1BFEB16456; Thu, 10 Apr 2003 18:54:57 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 48A18158FD; Thu, 10 Apr 2003 18:54:56 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: "Stefan Sturm" , Subject: Re: Trigger Date: Thu, 10 Apr 2003 18:54:54 +0100 User-Agent: KMail/1.4.3 References: <007401da8b57$925ff9f0$0200a8c0@sturmxp> In-Reply-To: <007401da8b57$925ff9f0$0200a8c0@sturmxp> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200304101854.54532.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Spam-Status: No, hits=-38.9 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/172 X-Sequence-Number: 12873 On Wednesday 10 Apr 2024 3:58 pm, Stefan Sturm wrote: > Hello, > > I switch to PostgreSQL 7.3 and now I try to make some Triggers. But the > triggers are differnt to Oracle. Where can I find a tutorial about using > and creating triggers in PostgreSQL 7.3 > > I just want to update to fields on instert and update with the system > time... You've already got some answers pointing you to the relevant point in the= =20 documentation, but you might like to check out=20 http://techdocs.postgresql.org/ - lots of good stuff there. Especially, it might be worth checking the cookbook (Roberto Mello) and the= =20 Postgresql Notes (me). I think I've got an example of this in the notes,=20 although it's probably out of date. --=20 Richard Huxton