Cross-Product JOIN?

From: Atomic_Sheep <atomic(dot)sheep(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Cross-Product JOIN?
Date: 2023-05-24 08:22:47
Message-ID: CAL3CXNMes1r4s78QnMAekj9W1nchGH7dbq86wyEFB2gxqQrJ-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi, I'm reading the documentation and I'm trying to wrap my head
around this statement:

"Finally, NATURAL is a shorthand form of 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. If there are no common column names, NATURAL JOIN
behaves like JOIN ...
ON TRUE, producing a cross-product join."

Did it mean cartesian product and not cross-product?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Erik Wienhold 2023-05-24 13:46:28 Re: Cross-Product JOIN?
Previous Message David G. Johnston 2023-05-24 04:35:55 Re: Typo