Re: Outer join with where conditions

From: Michał Otroszczenko <michal(dot)otroszczenko(at)gmail(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Outer join with where conditions
Date: 2005-11-14 16:58:48
Message-ID: 446305c00511140858x5404dbc8p@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johnny Ljunggren 2005-11-14 17:02:03 Re: Choosing PostgreSQL as the database for our next project
Previous Message Bruno Wolff III 2005-11-14 16:29:20 Re: Outer join with where conditions