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 D30ABCE518 for ; Fri, 11 Jul 2003 09:23:38 +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 87741-01 for ; Fri, 11 Jul 2003 06:23:26 -0300 (ADT) Received: from irko.smoothcorp.com (unknown [208.49.241.41]) by svr1.postgresql.org (Postfix) with ESMTP id E4433CE837 for ; Thu, 10 Jul 2003 16:15:53 -0300 (ADT) Received: from jgardner.ifloor.com ([10.0.1.63]) by irko.smoothcorp.com with esmtp (Exim 4.12) id 19agtj-0007iu-00; Thu, 10 Jul 2003 12:16:07 -0700 Received: from jgardner.ifloor.com (localhost.localdomain [127.0.0.1]) by jgardner.ifloor.com (8.12.8/8.12.8) with ESMTP id h6AJG8HK019481; Thu, 10 Jul 2003 12:16:08 -0700 Received: from localhost (localhost [[UNIX: localhost]]) by jgardner.ifloor.com (8.12.8/8.12.8/Submit) id h6AJG8SF019479; Thu, 10 Jul 2003 12:16:08 -0700 From: Jonathan Gardner To: "adivi" , Subject: Re: trigger proceedures in sql Date: Thu, 10 Jul 2003 12:16:06 -0700 User-Agent: KMail/1.5 References: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> In-Reply-To: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200307101216.07977.jgardner@jonathangardner.net> X-SA-Exim-Rcpt-To: adivi@maximizelearning.com, pgsql-sql@postgresql.org X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/142 X-Sequence-Number: 14256 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 09 July 2003 22:40, 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. > You may write them in PL/pgSQL, PL/Python, etc... Each language has example= s=20 on how to set up triggers. So you will need to read about PL/pgSQL and=20 PL/Python to figure out how to write triggers in those languages. I don't think you can write triggers in pure SQL. - --=20 Jonathan Gardner (was jgardn@alumni.washington.edu) Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/Dbt3WgwF3QvpWNwRAiRvAJ4ojWIGRGeuTQHY5ckOnepy0LBu9gCgoTl1 XaM7clW3uelccH/w0iaAA/k=3D =3DR7do -----END PGP SIGNATURE-----