Re: simple trigger question ... - Mailing list pgsql-sql

From Tom Lane
Subject Re: simple trigger question ...
Date
Msg-id 28222.1049380687@sss.pgh.pa.us
Whole thread Raw
In response to Re: simple trigger question ...  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-sql
"Marc G. Fournier" <scrappy@hub.org> writes:
> 'K, that makes it workable ... final question (I hope!) ... RULEs vs
> TRIGGERs?  I ended up doing it as a RULE, since I could do it without a
> function ... but is there a reason why that is a Bad Idea?  Or in a case
> like this, it doesn't really matter?

A lot of people have found that rules don't behave quite the way they
want, particularly with regard to things like the number of times that
side-effects happen.  Better test it out.
        regards, tom lane



pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: simple trigger question ...
Next
From: "AndreT"
Date:
Subject: string variable with spaces in psql