<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.15 2000/04/12 20:07:13 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.16 2000/05/20 11:38:25 momjian Exp $

Postgres documentation

-->

CREATE RULE example_5 AS

ON INERT TO emp WHERE new.salary > 5000

DO

UPDATE NEWSET SET salary = 5000;

UPDATE emp SET salary = 5000

WHERE emp.oid = new.oid;

</programlisting>

</para>

</refsect1>