Re: Triggers

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