Re: [GENERAL] rule's and trigger's

On 1999-11-25, J. Roeleveld mentioned:

> I was wondering if anyone knows what's being executed first,
> a Rule on a view, or a trigger set to 'before <something>' on a view?
>
> Eg. what's executed first? The RULE, or the TRIGGER?

The rules are done first. The reason is that the rules actually modify the
query before it gets to execution. In case of a view, a trigger would then
act on the query to the base table. Thus a trigger on a view might not
make too much sense.

See also the relevant chapters (39 & 41) in the Programmer's Guide.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden