Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AE1D59FBC69 for ; Wed, 25 Jul 2007 20:23:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 71097-02 for ; Wed, 25 Jul 2007 20:23:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54306.mail.re2.yahoo.com (web54306.mail.re2.yahoo.com [206.190.49.116]) by postgresql.org (Postfix) with SMTP id E7F919FB5B8 for ; Wed, 25 Jul 2007 20:23:07 -0300 (ADT) Received: (qmail 88038 invoked by uid 60001); 25 Jul 2007 23:23:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=MOjuukVn0VXxDHw1Mo7Qzc7sDyoaEsbJz6QTMDmMmZE9jeFN2Tkdk5plaR+86mgGAjdvj0vyYg4ZKUpL7fM+UJUXcRrKpcSLzbBloD2TXLQszuwInei5d2B6FgB0QcmCt78kBKlqS9juSNRhiPv5I+dt9YDubg7H6mWU+my2G/k=; X-YMail-OSG: .gFkmCgVM1l55rM8wZQ0CAreojiYT1THnsI2EM.SOcTE3QXqs_ez8ju49vdBNe5UM8KX2kBkaEL4fjWkFXEx6xjBqTDVimLrG4DeVCm5IzUV5CfLgMU1kP3gtgGDKA-- Received: from [75.41.74.118] by web54306.mail.re2.yahoo.com via HTTP; Wed, 25 Jul 2007 16:23:06 PDT Date: Wed, 25 Jul 2007 16:23:06 -0700 (PDT) From: chester c young Subject: Re: Assistance with a trigger To: Paul Lambert Cc: sql pgsql In-Reply-To: <46A7CEB6.90607@autoledgers.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <664441.87993.qm@web54306.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/148 X-Sequence-Number: 28883 --- Paul Lambert wrote: > I have some triggers in an MS SQL server database which I need to > copy > across to a PG database. I've not yet done triggers in PG so I was > hoping to get a little bit of a pointer on the first one as a place > to > start and work my way through from there. http://www.postgresql.org/docs/8.2/interactive/plpgsql.html I found the doc to be quite good. I'd start there, and then, if you have problems, email again. ____________________________________________________________________________________ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/