Re: join question - Mailing list pgsql-novice

From Tom Lane
Subject Re: join question
Date
Msg-id 17965.1013834310@sss.pgh.pa.us
Whole thread Raw
In response to join question  (Brian <Brrrian@Excite.com>)
List pgsql-novice
Brian <Brrrian@Excite.com> writes:
> AND Part.Part_ID         = Device.Part_ID
> AND Traveler.Traveler_ID = Device.Traveler_ID

> -OR- do you turn around the Joins like this?

> AND Device.Part_ID     = Part.Part_ID
> AND Device.Traveler_ID = Traveler.Traveler_ID

The above should be equivalent.  If you have an example where it makes a
difference, then it's probably a bug --- let's see the details.

            regards, tom lane

pgsql-novice by date:

Previous
From: Brian
Date:
Subject: join question
Next
From: John Herreshoff
Date:
Subject: pg_dump and restore