diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-19 23:13:54 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-19 23:13:54 +0000 |
commit | 6d6ca2166c3ae8db9fac2ec7fdadca0c4e6382a1 (patch) | |
tree | 3bd8166e6da16403daa1daa44315a652eee5f1d2 /doc/src | |
parent | 201737168c4ed5b14313d111d8d746c7f072f24e (diff) | |
download | postgresql-6d6ca2166c3ae8db9fac2ec7fdadca0c4e6382a1.tar.gz postgresql-6d6ca2166c3ae8db9fac2ec7fdadca0c4e6382a1.zip |
Change naming rule for ON SELECT rules of views: they're all just
_RETURN now, since there's no need to keep 'em unique anymore.
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/create_rule.sgml | 6 | ||||
-rw-r--r-- | doc/src/sgml/rules.sgml | 8 |
2 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index 1c5786a0c91..ae9571a7c58 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.34 2002/04/19 16:36:08 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.35 2002/04/19 23:13:53 tgl Exp $ PostgreSQL documentation --> @@ -268,12 +268,12 @@ CREATE report an error because the query cycled too many times: <programlisting> -CREATE RULE "_RETemp" AS +CREATE RULE "_RETURN" AS ON SELECT TO emp DO INSTEAD SELECT * FROM toyemp; -CREATE RULE "_RETtoyemp" AS +CREATE RULE "_RETURN" AS ON SELECT TO toyemp DO INSTEAD SELECT * FROM emp; diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml index 5385a900222..f26319c463a 100644 --- a/doc/src/sgml/rules.sgml +++ b/doc/src/sgml/rules.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/rules.sgml,v 1.22 2002/03/22 19:20:26 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/rules.sgml,v 1.23 2002/04/19 23:13:53 tgl Exp $ --> <Chapter Id="rules"> <Title>The Rule System</Title> @@ -289,7 +289,7 @@ CREATE VIEW myview AS SELECT * FROM mytab; <ProgramListing> CREATE TABLE myview (<Replaceable>same attribute list as for mytab</Replaceable>); -CREATE RULE "_RETmyview" AS ON SELECT TO myview DO INSTEAD +CREATE RULE "_RETURN" AS ON SELECT TO myview DO INSTEAD SELECT * FROM mytab; </ProgramListing> @@ -517,7 +517,7 @@ SELECT shoelace.sl_name, shoelace.sl_avail, range table and checks if there are rules in <Filename>pg_rewrite</Filename> for any relation. When processing the range table entry for <Filename>shoelace</Filename> (the only one up to now) it finds the - rule <literal>_RETshoelace</literal> with the parse tree + <literal>_RETURN</literal> rule with the parse tree <ProgramListing> <emphasis>SELECT s.sl_name, s.sl_avail, @@ -1494,7 +1494,7 @@ UPDATE shoelace_data SET Again it's an INSTEAD rule and the previous parse tree is trashed. Note that this query still uses the view <Filename>shoelace</Filename>. But the rule system isn't finished with this loop so it continues - and applies the rule <literal>_RETshoelace</literal> on it and we get + and applies the <literal>_RETURN</literal> rule on it and we get <ProgramListing> UPDATE shoelace_data SET |