Re: RULES - Difference between DO and DO INSTEAD

Luis,

> I'm building some rules for some views that I have, but I did'nt
> understand yet what's the difference between doing a rule with DO or
> with DO INSTEAD.
> What's the diference ?

Simple:

CREATE RULE xxx ON UPDATE TO yyy WHERE www=zzz ...

DO ACTION: do the action, then go ahead and update the table.
DO INSTEAD ACTION: do the action, and *do not* update the table.

IMHO, the online docs on Rules and Triggers are quite good. However,
they are scattered around the online documentation; some is in SQL
Commands, some in Programmer's Guide. Put in some effort into finding
all the articles, it's worth it.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco