Re: Idea: Avoid JOINs by using path expressions to follow FKs

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Idea: Avoid JOINs by using path expressions to follow FKs
Дата
Msg-id CAFj8pRA3W7sO6LhXEf4-YiK+4JYjV=_Z2BCqHGRXqo4nD135ig@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Idea: Avoid JOINs by using path expressions to follow FKs  ("Joel Jacobson" <joel@compiler.org>)
Ответы Re: Idea: Avoid JOINs by using path expressions to follow FKs  (Vik Fearing <vik@postgresfriends.org>)
Список pgsql-hackers
Дерево обсуждения


If using the -> notation, you would only need to manually
inspect the tables involved in the remaining JOINs;
since you could be confident all uses of -> cannot affect cardinality.

I think this would be a win also for an expert SQL consultant working
with a new complex data model never seen before.


I did not feel comfortable when I read about this proprietary extension of SQL.  I can accept and it can be nice to support ANSI/SQL object's referentions, but implementing own syntax for JOIN looks too strange. I  don't see too strong benefit in inventing new syntax and increasing the complexity and possible disorientation of users about correct syntax. Some users didn't adopt a difference between old joins and modern joins, and you are inventing a third syntax.

Pavel


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

Предыдущее
От: Sebastian Cabot
Дата:
Сообщение: Re: Prevent query cancel packets from being replayed by an attacker (From TODO)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: making update/delete of inheritance trees scale better