Cross-Product JOIN?

Поиск
Список
Период
Сортировка
От Atomic_Sheep
Тема Cross-Product JOIN?
Дата
Msg-id CAL3CXNMes1r4s78QnMAekj9W1nchGH7dbq86wyEFB2gxqQrJ-g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cross-Product JOIN?  (Erik Wienhold <ewie@ewie.name>)
Список 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?



В списке pgsql-docs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Typo
Следующее
От: Erik Wienhold
Дата:
Сообщение: Re: Cross-Product JOIN?