Re: Foreign key joins revisited

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Foreign key joins revisited
Дата
Msg-id CADkLM=dBY77FzeXWm6Mq2NmGA81TyowsdDufnKSur==u=X9jFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
Ответы Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
Список pgsql-hackers
Дерево обсуждения


Perhaps this would be more SQL idiomatic:

FROM permission p
   LEFT JOIN ON KEY role IN p AS r
   LEFT JOIN team_role AS tr ON KEY role TO r
   LEFT JOIN ON KEY team IN tr AS t
   LEFT JOIN user_role AS ur ON KEY role TO r
   LEFT JOIN ON KEY user IN ur AS u


My second guess would be:

FROM permission p
LEFT JOIN role AS r ON [FOREIGN] KEY [(p.col1 [, p.col2 ...])]

where the key spec is only required when there are multiple foreign keys in permission pointing to role.

But my first guess would be that the standards group won't get around to it.

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

Предыдущее
От: "Joel Jacobson"
Дата:
Сообщение: Re: Foreign key joins revisited
Следующее
От: "Euler Taveira"
Дата:
Сообщение: Re: row filtering for logical replication