Re: multiple action rules

On Wed, 2005-06-22 at 18:31, Scott Marlowe wrote:
> OK, so I'm trying to make a rule with >1 action.
>
> The docs, not so helpfully, only seem to show a single action rule (at
> least in the rules section, not sure about elsewhere)  The syntax
> diagram:
>
> CREATE RULE rule_name AS ON event
>     TO object [WHERE rule_qualification]
>     DO [INSTEAD] [action | (actions) | NOTHING];
>
> seems to imply to me that >2 actions would look like this:
>
> create rule audit_test as on delete to ntest do (
>     insert into naudit(id,path) values (OLD.id, OLD.path);
>     notify test;
> )
>
> But no matter what flavor of syntax I throw at this, I get:
>
> syntax error at or near "insert" at character xxx
>
> So, what's the magic pixie dust I need to sprinkle on this to make it
> work?


Never mind, I finally figured it out...  About three minutes after
posting this.  sheesh.