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 391FECD699 for ; Fri, 11 Jul 2003 02:00:25 +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 38495-07 for ; Thu, 10 Jul 2003 23:00:13 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 6547CCB687 for ; Thu, 10 Jul 2003 12:55:59 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h6AFsjRo005329; Thu, 10 Jul 2003 09:54:46 -0600 (MDT) Date: Thu, 10 Jul 2003 09:47:57 -0600 (MDT) From: "scott.marlowe" To: adivi Cc: Subject: Re: trigger proceedures in sql In-Reply-To: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailScanner: Found to be clean X-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/136 X-Sequence-Number: 14250 On Thu, 10 Jul 2003, 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. they can be written in pl/pgsql for sure, as I've written a few. :-) Here's the section in the developer docs on triggers in plpgsql: http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html