Date: Tue, 22 Nov 2005 18:25:50 +0200 (EET)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: "Leif B. Kristensen" <leif@solumslekt.org>
cc: pgsql-sql@postgresql.org
Subject: Re: Triggers
In-Reply-To: <200511221543.47979.leif@solumslekt.org>
Message-ID: <Pine.LNX.4.44.0511221825001.24697-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-7
Content-Transfer-Encoding: 8BIT

O Leif B. Kristensen έγραψε στις Nov 22, 2005 :

> I'm trying to understand triggers. I have read the documentation in the 
> manual as well as the few pages in the Douglas book about the subject, 
> but I don't see how to implement a trigger that simply updates a 
> 'last_edit' date field in my 'persons' table whenever I do an insert or 
> update into my 'participants' table; that is a trigger that basically 
> does an "UPDATE persons SET 'last_edit' = NOW() WHERE persons.person_id 
> = participants.person_fk". Is that even possible?
> 

smth like:
foodb=# CREATE or REPLACE FUNCTION upd_dad() RETURNS "trigger" AS '
foodb'# BEGIN
foodb'# UPDATE dad set lastedit=now() where id=new.dadid;
foodb'# RETURN new;
foodb'# END;
foodb'# '
foodb-# LANGUAGE plpgsql;
CREATE FUNCTION
foodb=# CREATE TRIGGER upd_dad_tg AFTER INSERT OR UPDATE ON kid FOR EACH 
ROW EXECUTE PROCEDURE upd_dad();


-- 
-Achilleus