Re: Problem with joins - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problem with joins
Date
Msg-id 24919.1012923594@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with joins  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
"Josh Berkus" <josh@agliodbs.com> writes:
> [ mostly good advice ]
>  ... You can't mix explicit JOINs (e.g. TableA JOIN TableB ON
>  Col1 = Col2) with implicit joins (FROM TableA, TableB WHERE col1 =
>  col2).

Sure you can, though the explicit joins will be done first.  See
http://developer.postgresql.org/docs/postgres/explicit-joins.html

            regards, tom lane

pgsql-novice by date:

Previous
From: "Duncan Adams (DNS)"
Date:
Subject: Re: order by question
Next
From: "Joshua b. Jore"
Date:
Subject: SETOF / SETS_FIXED?