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