From 6b02ed66e2856abb1d5eef64747badd4fc78cef9 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Mon, 13 Jun 2011 12:59:04 -0400 Subject: [PATCH] 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 b3cf39a39b..7ca640e697 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -266,7 +266,9 @@ FROM table_reference , table_r USING: it forms a USING list consisting of all column names that appear in both input tables. As with USING, these columns appear - only once in the output table. + only once in the output table. If there are no common + columns, NATURAL behaves like + CROSS JOIN. -- 2.40.0