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 CA024CC168 for ; Fri, 11 Jul 2003 05:46:39 +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 12944-07 for ; Fri, 11 Jul 2003 02:46:28 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by svr1.postgresql.org (Postfix) with ESMTP id 9ACC4CD586 for ; Thu, 10 Jul 2003 11:27:04 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id ADE91D61B; Thu, 10 Jul 2003 07:27:18 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A3A2B5C0D; Thu, 10 Jul 2003 07:27:18 -0700 (PDT) Date: Thu, 10 Jul 2003 07:27:18 -0700 (PDT) From: Stephan Szabo To: adivi Cc: Subject: Re: trigger proceedures in sql In-Reply-To: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> Message-ID: <20030710072543.O35479-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/137 X-Sequence-Number: 14251 On Thu, 10 Jul 2003, adivi wrote: > can trigger proceedures ( procedures to be executed from within a trigger ) > not be written in sql. AFAICT, no, sql functions cannot return opaque/trigger. However you can write trigger functions in most/all of the pl languages (plpgsql, pltcl, etc...) I think the trigger examples for plpgsql are in plpgsql's documentation.