Re: BUG #3778: Natural join with filter problem

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: BUG #3778: Natural join with filter problem
Дата
Msg-id 474AD080.3050702@enterprisedb.com
обсуждение исходный текст
Ответ на Re: BUG #3778: Natural join with filter problem  (Laurent HERVE <laurentjpherve@orange.fr>)
Список pgsql-bugs
Laurent HERVE wrote:
> ok thank you... and sorry for not having checked enough time in the
> documentation.
> anyway, i think a kind of JOIN ... USING (primary key columns) could be
> useful.
> if you change a primary key, because of design choice, you won't have to
> rewrite all rules and views for example, just simple execute would be
> required. This is why i used NATURAL.

Yeah, I see what you mean. NATURAL JOIN is part of the SQ standard, so
we're just following that. Matching by foreign keys would make more
sense to me as well.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Laurent HERVE
Дата:
Сообщение: Re: BUG #3778: Natural join with filter problem
Следующее
От: "Ning Li"
Дата:
Сообщение: BUG #3780: Error message happen when Starting Services