Re: difference between join syntax - Mailing list pgsql-novice

From Tom Lane
Subject Re: difference between join syntax
Date
Msg-id 18155.1093827260@sss.pgh.pa.us
Whole thread Raw
In response to difference between join syntax  (Natan <nvivo@mandic.com.br>)
List pgsql-novice
Natan <nvivo@mandic.com.br> writes:
> Can anyone tell me if there is any difference between these two commands:
> select * from table1, table2 where table1.id = table2.id
>    and
> select * from table1 inner join table 2 on table1.id = table2.id

Nope.

> I checked the query plan for both and they appear exactly the same. But
> in this case, i am working with only two tables in a very simple
> join.... What i would like to know is: in a production environment with
> lots of joins and where clauses, does it make any difference to write in
> one form or in the other, or the joins are like shortcuts to the first form?

With more than two tables, it *can* make a difference.  If using 7.4,
see
http://www.postgresql.org/docs/7.4/static/explicit-joins.html
Earlier versions were a bit different --- make the obvious change in
the URL to see the corresponding docs for your version.

            regards, tom lane

pgsql-novice by date:

Previous
From: Natan
Date:
Subject: difference between join syntax
Next
From: Bruce Momjian
Date:
Subject: Re: Release 7.4.5