Cross-Product JOIN?

2023-05-24 Thread Atomic_Sheep
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

Re: Cross-Product JOIN?

2023-05-24 Thread Erik Wienhold
> On 24/05/2023 10:22 CEST Atomic_Sheep 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,

Re: Cross-Product JOIN?

2023-05-24 Thread Erik Wienhold
> On 24/05/2023 15:46 CEST Erik Wienhold wrote: > > 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 gr

Re: Cross-Product JOIN?

2023-05-24 Thread Laurenz Albe
On Wed, 2023-05-24 at 21:10 +0200, Erik Wienhold wrote: > > On 24/05/2023 15:46 CEST Erik Wienhold wrote: > > > > 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 > > overal