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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
