Bruce Momjian writes: > Well, let's look at the common case. For proper view rules, these would > all return the right values because the UPDATE in the rule would be > returned. Is that what you mean?
I guess that really depends on whether the rules are written to properly constrain the writes to the view to the set of rows visible by the view. For example, if a view v1 selects from a single table t1 constrained by a search condition, and I do UPDATE v1 SET ...; without a condition, does that affect all rows in t1? If not, then both our proposals are equivalent, if yes, then the it's the user's fault, I suppose. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
