Re: Compatibility Issue of CREATE RULE in 7.2 - Mailing list pgsql-sql

From Tom Lane
Subject Re: Compatibility Issue of CREATE RULE in 7.2
Date
Msg-id 23741.1022075735@sss.pgh.pa.us
Whole thread Raw
In response to Compatibility Issue of CREATE RULE in 7.2  (Bhuvan A <bhuvansql@yahoo.com>)
List pgsql-sql
Bhuvan A <bhuvansql@yahoo.com> writes:
> bhuvan=# CREATE RULE rule_test_rule AS ON insert TO rule_test do
> delete from rule_test where key = new.key; 

You could probably make this work by doing it in a BEFORE INSERT
trigger, instead of a rule.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Wm. G. Urquhart"
Date:
Subject: Re: Turning column into row (More...)
Next
From: Tom Lane
Date:
Subject: Re: Bug with ORDER BY expression [ ASC | DESC ] ?