Re: Outer join with where conditions - Mailing list pgsql-general

From Michał Otroszczenko
Subject Re: Outer join with where conditions
Date
Msg-id 446305c00511140858x5404dbc8p@mail.gmail.com
Whole thread Raw
In response to Re: Outer join with where conditions  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Outer join with where conditions
Next
From: Johnny Ljunggren
Date:
Subject: Re: Choosing PostgreSQL as the database for our next project