diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-12-12 16:47:52 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-12-12 16:47:52 +0000 |
| commit | 36da236eb313384a8996f2bfd4b51117c34e9344 (patch) | |
| tree | 4db2ad07186893bc368fd69786ed22a945a8825a | |
| parent | 1045304a3bd8c0279dffdf5b4b71897240ada3c3 (diff) | |
In 'Joins between classes' in Section 5 of the tutorial we have, in
the first paragraph:
As an example, say we wish to find all the records that
are in the temperature range of other records. In
effect, we need to compare the temp_lo and temp_hi
attributes of each EMP instance to the temp_lo and
temp_hi attributes of all other EMP instances.
I believe that EMP should read WEATHER, as the example query that
follows joins WEATHER to itself.
EMP is often used in Oracle examples.
Regards,
Graham
Other RULE cleanups
| -rw-r--r-- | doc/src/sgml/query.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_rule.sgml | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/doc/src/sgml/query.sgml b/doc/src/sgml/query.sgml index 32b9b9a2c15..f6c86b930d8 100644 --- a/doc/src/sgml/query.sgml +++ b/doc/src/sgml/query.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/query.sgml,v 1.13 2000/09/29 20:21:34 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/query.sgml,v 1.14 2000/12/12 16:47:52 momjian Exp $ --> <chapter id="query"> @@ -273,8 +273,8 @@ SELECT * INTO TABLE temp FROM weather; As an example, say we wish to find all the records that are in the temperature range of other records. In effect, we need to compare the temp_lo and temp_hi - attributes of each EMP instance to the temp_lo and - temp_hi attributes of all other EMP instances. + attributes of each WEATHER instance to the temp_lo and + temp_hi attributes of all other WEATHER instances. <note> <para> This is only a conceptual model. The actual join may diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index 2717037aa89..52b2e9117ac 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.19 2000/10/05 19:48:17 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.20 2000/12/12 16:47:52 momjian Exp $ Postgres documentation --> @@ -208,14 +208,14 @@ ON UPDATE TO emp-1.salary WHERE emp-2.name = "Joe" CREATE RULE bad_rule_combination_1 AS ON SELECT TO emp DO INSTEAD - SELECT TO toyemp; + SELECT * FROM toyemp; </programlisting> <programlisting> CREATE RULE bad_rule_combination_2 AS ON SELECT TO toyemp DO INSTEAD - SELECT TO emp; + SELECT * FROM emp; </programlisting> <para> This attempt to select from EMP will cause |