"johnlumby@hotmail.com" <johnlumby@hotmail.com> writes:
> But I suppose that my next question, given what you both say about the
> RULE system being a dead-end, is whether there is any likelihood of
> supporting an INSTEAD OF trigger on a view at statement level? Maybe
> that stands more chance of going somewhere?
Perhaps, but I don't know of anyone working on it.
IIRC, the row-level-only restriction dates from before we had
implemented transition tables, so that at the time there was
nothing very meaningful that a statement-level trigger could do.
Maybe that problem has gone away, though I've not thought
about it very hard.
regards, tom lane