Re: NATURAL JOINs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: NATURAL JOINs
Дата
Msg-id 22338.1224086103@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: NATURAL JOINs  ("Richard Broersma" <richard.broersma@gmail.com>)
Ответы Re: NATURAL JOINs  (Reg Me Please <regmeplease@gmail.com>)
Список pgsql-general
"Richard Broersma" <richard.broersma@gmail.com> writes:
> For this reason, clients passing natural joins to the server can have
> dangerous result sets returned with no warning.

Yeah.  A lot of people consider that NATURAL JOIN is simply a bad idea
and shouldn't be used ever --- it's too easy to shoot yourself in the
foot with a careless column addition or rename.  Explicitly spelling out
the join columns with ON or USING is a lot less prone to silent breakage
after a schema change.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Opptimizing projections containing unused columns
Следующее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: Opptimizing projections containing unused columns