diff options
| -rw-r--r-- | doc/src/sgml/queries.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 7 |
2 files changed, 7 insertions, 4 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 30792f45f15..0588da2912c 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -391,8 +391,8 @@ FROM <replaceable>table_reference</replaceable> <optional>, <replaceable>table_r consisting of all column names that appear in both input tables. As with <literal>USING</>, these columns appear only once in the output table. If there are no common - column names, <literal>NATURAL</literal> behaves like - <literal>CROSS JOIN</literal>. + column names, <literal>NATURAL JOIN</literal> behaves like + <literal>JOIN ... ON TRUE</literal>, producing a cross-product join. </para> <note> diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 211e4c320ce..57f11e66fb6 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -603,9 +603,12 @@ TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] <varlistentry> <term><literal>NATURAL</literal></term> <listitem> - <para><literal>NATURAL</literal> is shorthand for a + <para> + <literal>NATURAL</literal> is shorthand for a <literal>USING</> list that mentions all columns in the two - tables that have the same names. + tables that have matching names. If there are no common + column names, <literal>NATURAL</literal> is equivalent + to <literal>ON TRUE</>. </para> </listitem> </varlistentry> |