Re: Outer join with where conditions

Поиск
Список
Период
Сортировка
От Michał Otroszczenko
Тема Re: Outer join with where conditions
Дата
Msg-id 446305c00511140858x5404dbc8p@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Outer join with where conditions  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
> Conditions in WHERE are conditions logically applied after the join, so
> the second query is join rows of booking_load with rows of
> dict_load_type_tsl that have the same dict_load_type_id and if no such
> rows in dict_load_type_tsl are found extend with NULLs then throw out any
> rows for which dict_language_id is not equal to 'EN'.
>

Thank you for extensive explanation. I supposed that it is like that,
but I couldn't find confirmation in docs.

Regards,
Michal

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Outer join with where conditions
Следующее
От: Johnny Ljunggren
Дата:
Сообщение: Re: Choosing PostgreSQL as the database for our next project