X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EABBAD1CB35 for ; Fri, 5 Mar 2004 16:33:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85560-09 for ; Fri, 5 Mar 2004 12:33:23 -0400 (AST) Received: from dervish.jonathangardner.net (dervish.jonathangardner.net [66.92.192.241]) by svr1.postgresql.org (Postfix) with ESMTP id EC55BD1B470 for ; Fri, 5 Mar 2004 12:33:00 -0400 (AST) Received: from atlas.jonathangardner.net (atlas.jonathangardner.net [66.92.192.166]) (authenticated bits=0) by dervish.jonathangardner.net (8.12.10/8.12.10) with ESMTP id i25GWmxJ032502 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Fri, 5 Mar 2004 08:32:59 -0800 From: "Jonathan M. Gardner" To: Subject: Re: Triggers Date: Fri, 5 Mar 2004 08:32:37 -0800 User-Agent: KMail/1.6 Cc: References: In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Content-Type: Text/Plain; charset="windows-1252" Content-Transfer-Encoding: quoted-printable Message-Id: <200403050832.40529.jgardner@jonathangardner.net> Received-SPF: pass (dervish.jonathangardner.net: sender at 66.92.192.166 was authenticated) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/45 X-Sequence-Number: 17144 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 26 February 2004 2:18 am, Philip J. Boonzaaier wrote: > The technical reference gives an example of a trigger on a table - > employee Just to test this, I have created the following table, > CREATE TABLE employee > (name VARCHAR(30), > age int4, > state VARCHAR(2), > manager VARCHAR(3), > adult VARCHAR(3)); > > The I created a simple Function, as follows : > > CREATE FUNCTION trig_insert_update_check_emp() RETURNS opaque AS ' > BEGIN > IF new.age > 20 THEN > new.adult =3D ''yes''; > ELSE > new.adult =3D ''no''; > END IF; > END; > ' LANGUAGE 'plpgsql'; Couple of comments: 1) Your trigger functions needs to return something. In this case, you=20 would "RETURN NEW". 2) I believe trigger functions need to "RETURNS TRIGGER", not "RETURNS=20 opaque", but I could be wrong. Give that a try. Question: 1) What version of PostgreSQL are you running? - --=20 Jonathan Gardner jgardner@jonathangardner.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFASKulqp6r/MVGlwwRAgpLAKCycwL/i+/mb6bW1W4QjHKBO9e0xQCgl42q pmohSw7PZiuIWgOQXxtgvI0=3D =3D4iDJ -----END PGP SIGNATURE-----