Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

Outer join with where conditions - Mailing list pgsql-general

From Michał Otroszczenko
Subject Outer join with where conditions
Date
Msg-id 446305c00511140545p1fbfa57bl@mail.gmail.com
Whole thread Raw
Responses Re: Outer join with where conditions
Re: Outer join with where conditions
List pgsql-general
Hello,

I wonder If I could move additional join condition from ON part of
query to where part.

For example instead of:

SELECT *  FROM
    booking_load AS bload
    LEFT OUTER JOIN dict_load_type_tsl AS load_tsl ON (
                    load_tsl.dict_load_type_id = bload.dict_load_type_id
                    AND load_tsl.dict_language_id = 'EN' ))

Could I write:

SELECT *  FROM
    booking_load AS bload
    LEFT OUTER JOIN dict_load_type_tsl AS load_tsl USING (dict_load_type_id)
WHERE
     load_tsl.dict_language_id = 'EN'

I thought that second query could be more 'optimizable', but gave no results.
Where is the problem ?

Best regards,
Michal

pgsql-general by date:

Previous
From: Hugo
Date:
Subject: odbc and psql 8.1.0
Next
From: Stephan Szabo
Date:
Subject: Re: Outer join with where conditions