diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-06-13 12:59:04 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-06-13 12:59:04 -0400 |
| commit | 6b02ed66e2856abb1d5eef64747badd4fc78cef9 (patch) | |
| tree | 3ac3c61a6a232806c4f153636d26fc88d381cf2a /doc/src | |
| parent | 2a890421424da5cca4226ee8afd562c356205815 (diff) | |
| download | postgresql-6b02ed66e2856abb1d5eef64747badd4fc78cef9.tar.gz postgresql-6b02ed66e2856abb1d5eef64747badd4fc78cef9.zip | |
Clarify that NATURAL without matching columns is like CROSS JOIN.
As suggested by Grzegorz Szpetkowski.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/queries.sgml | 4 |
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> |