rules - Mailing list pgsql-sql

From Jie Liang
Subject rules
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB1E1FC8@mail01.stbernard.com
Whole thread Raw
Responses Re: rules
List pgsql-sql
According to the document of rule:

CREATE RULE rulename AS ON delete TO mytablename DO
(
delete from aaa where id=OLD.id;
Delete from bbb where id=OLD.id;
Delete from ccc where id=OLD.id
);


Should work, but it doesn't, what wrong with it?
Even I use { .... }

Jie Liang

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function valid only for one table
Next
From: Martin Knipper
Date:
Subject: Re: Function valid only for one table