Re: Rule updates and PQcmdstatus() issue

On Mon, 9 Sep 2002, Bruce Momjian wrote:

> Jan Wieck wrote:
> > We should surely keep this on a much more technical level and avoid any
> > personal offendings. To do so, please explain to me why you think that
> > triggers and constraints are out of focus here? What is the difference
> > between a trigger, a rule and an instead rule from a business process
> > oriented point of view? I think there is none at all. They are just
> > different techniques to do one and the same, implement business logic in
> > the database system.
>
> All the problems here are coming from INSTEAD rules.  We don't have
> INSTEAD triggers or contraints.

Sure we do, well sort of. :)
Make a before trigger that does a different statement and returns NULL
to abort the original action on that row.