summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRobert Haas2011-06-13 16:59:04 +0000
committerRobert Haas2011-06-13 16:59:04 +0000
commit6b02ed66e2856abb1d5eef64747badd4fc78cef9 (patch)
tree3ac3c61a6a232806c4f153636d26fc88d381cf2a
parent2a890421424da5cca4226ee8afd562c356205815 (diff)
Clarify that NATURAL without matching columns is like CROSS JOIN.
As suggested by Grzegorz Szpetkowski.
-rw-r--r--doc/src/sgml/queries.sgml4
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml
index b3cf39a39b0..7ca640e6975 100644
--- a/doc/src/sgml/queries.sgml
+++ b/doc/src/sgml/queries.sgml
@@ -266,7 +266,9 @@ FROM <replaceable>table_reference</replaceable> <optional>, <replaceable>table_r
<literal>USING</>: it forms a <literal>USING</> list
consisting of all column names that appear in both
input tables. As with <literal>USING</>, these columns appear
- only once in the output table.
+ only once in the output table. If there are no common
+ columns, <literal>NATURAL</literal> behaves like
+ <literal>CROSS JOIN</literal>.
</para>
<para>