> 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.
The difference is how other db's work. They all ignore triggers and constraints in the sqlca.sqlerrd[2] "number of processed rows" count, that I see identical to our affected rows count. They all have views, but not many have rules :-) Pg's "instead rules" are the toolkit for views, and as such need special handling, imho. Andreas ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster