> On 24/05/2023 10:22 CEST Atomic_Sheep <atomic.sh...@gmail.com> wrote: > > "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?
Cross product means cartesian product in this context. So technically correct. Personally, I think it should read cartesian product because cross product is an overloaded term and cartesian product is used more often in the documentation overall. But the same page [0] also uses cross product when talking about grouping sets. The source code uses cross product in a couple of comments, though. [0] https://www.postgresql.org/docs/15/queries-table-expressions.html -- Erik
