postgres.git / summary / log / commit / refs

commit    6b02ed66e2856abb1d5eef64747badd4fc78cef9
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Mon Jun 13 16:59:04 2011 +0000
First released in: 9.2.0, 9.1.0

    Clarify that NATURAL without matching columns is like CROSS JOIN.
    
    As suggested by Grzegorz Szpetkowski.


 doc/src/sgml/queries.sgml | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

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>


[parent: 2a890421424d]