From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Leif B. Kristensen <leif@solumslekt.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Triggers
Date: Tue, 22 Nov 2005 18:25:50 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0511221825001.24697-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <200511221543.47979.leif@solumslekt.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, leif@solumslekt.org
Subject: Re: Triggers
In-Reply-To: <Pine.LNX.4.44.0511221825001.24697-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox