X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 32224CC5D0 for ; Thu, 10 Jul 2003 09:43:11 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 87355-03 for ; Thu, 10 Jul 2003 06:42:38 -0300 (ADT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id 5E21ACC24E for ; Thu, 10 Jul 2003 05:29:34 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 19aWoD-000BIs-0V; Thu, 10 Jul 2003 09:29:45 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id DEFB016D61; Thu, 10 Jul 2003 09:29:41 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 394BF16D57; Thu, 10 Jul 2003 09:29:41 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: "adivi" , Subject: Re: trigger proceedures in sql Date: Thu, 10 Jul 2003 09:29:47 +0100 User-Agent: KMail/1.4.3 References: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> In-Reply-To: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200307100929.47140.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/128 X-Sequence-Number: 14242 On Thursday 10 Jul 2003 6:40 am, adivi wrote: > hi, > > can trigger proceedures ( procedures to be executed from within a > trigger ) not be written in sql. > > i was looking for examples and can find proceedures in 'c' only. AFAIK you can't use "sql", but you can use "plpgsql". There is an example o= f a=20 trigger function in the docs (chapter "Procedural Languages"). Also check o= ut=20 http://techdocs.postgresql.org/ - there are examples in some of the docs=20 there. --=20 Richard Huxton