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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
