rules over multiple tables

Hi all,

I'm new to Postgresql (using Postgresql 7.1.3) and I want to create rules.

I have a Database which has two tables (Addresses and Contacts) and I
created views (like in the documentation, it works), and I want to create rules for
insert, update and delete.

The syntax for the insert-rule I found (and it works), but nothing about how
to create update and delete rules over two tables. In the documentation, I
only found examples how to create rules over one table (this works, but I want
it over two tables).

The syntax I used for insert in two tables:

create rule view_test_insert as on insert to view_test do instead (
insert into "ADDRESSES" ("ID_ADDR" , "COMPANY" , etc...)
values (new."ID_ADDR" , new."COMPANY" , etc...);
insert into "CONTACTS" ("ID" , "C_CATEGORY" , etc...)
values (new."ID" , new."C_CATEGORY" , etc...);
);

I tried update and delete whit that syntax but it dosn't work ERROR:
parser: parse error at or near "(".

Does anyone know the solution for my problem?

Thank you!

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net