<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.26 2001/09/07 20:52:30 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.27 2001/09/14 08:19:55 ishii Exp $

Postgres documentation

-->

<example>

<title>Example of a circular rewrite rule combination:</title>

<programlisting>

CREATE RULEbad_rule_combination_1 AS

CREATE RULE"_RETemp" AS

ON SELECT TO emp

DO INSTEAD

SELECT * FROM toyemp;

</programlisting>

<programlisting>

CREATE RULEbad_rule_combination_2 AS

CREATE RULE"_RETtoyemp" AS

ON SELECT TO toyemp

DO INSTEAD

SELECT * FROM emp;