On Thu, 26 Apr 2001, [iso-8859-1] Mart�n Marqu�s wrote:
> Is it posible to make a rule execute more then one query?
>
> Something like:
>
> CREATE RULE rule_name AS ON INSERT TO table1
> DO INSTEAD
> INSERT INTO table2 VALUES
> (new.value1,new.value2)
> INSERT INTO table3 VALUES
> (x,y)
test=# \h create rule
Command: CREATE RULE
Description: Defines a new rule
Syntax:
CREATE RULE name AS ON event TO object [ WHERE condition ] DO [ INSTEAD ] action
where action can be:
NOTHING
|
query
|
( query ; query ... )
|
[ query ; query ... ]
ie
CREATE RULE snog AS ON UPDATE TO foo DO INSTEAD ( ...; ... );
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington