From: "fabio" <penguin@email.it>
Subject: Re: Executing SQL commands via triggers without the use of procedures
Date: Thu, 27 Mar 2003 00:04:48 +0100
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 21
Message-ID: <pan.2003.03.26.23.04.45.243238@email.it>
References: <001501c2def2$fe2fe9c0$1f84fea9@oemcomputer>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
User-Agent: Pan/0.13.4 (She had eyes like strange sins. (Debian GNU/Linux))
To: pgsql-sql@postgresql.org
Content-Transfer-Encoding: quoted-printable


>=20
> Having scoured the relevant documentation I cannot find anything which in=
di=3D
> cates how I simply create a database trigger to insert into a second tabl=
e =3D
> after insert on a first table, without the use of a procedure.  As I do n=
ot=3D
>  want return values etc. this seems like overkill.  Is it possible to cre=
at=3D
> e a trigger which executes SQL directly without the need to create a proc=
ed=3D
> ure?  If so, what is the syntax?
>=20

hello! I had the same problem, is possible to solve it with a rules but
depend. In my db i used a trigger because,i have multiple insert in
cascade and the rules dont handle this=20

manual for trigger procedure:
http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Dplpgs=
ql-trigger.html

trigger vs rules
http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Drules=
-triggers.html

fabio