Re: Cartesian product bug?

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Cartesian product bug?
Дата
Msg-id Pine.LNX.4.33.0311031040510.25850-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Cartesian product bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Cartesian product bug?
Список pgsql-general
On Fri, 31 Oct 2003, Tom Lane wrote:

> (Personally I think NATURAL JOIN is an evil, bug-prone construct,
> precisely because coincidental matches of column names will mess up your
> results.)

Me too.  When I first saw it, I figured it would "naturally join" the two
tables on their fk/pk relation if there was one.  That seems natural.
Joining on two fields that just happen to have the same name is unnatural
to me.


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

Предыдущее
От: Alexandr S
Дата:
Сообщение: question
Следующее
От: javier garcia - CEBAS
Дата:
Сообщение: transposed query?