Re: join question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian <Brrrian(at)Excite(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: join question
Date: 2002-02-16 04:38:30
Message-ID: 17965.1013834310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Brian <Brrrian(at)Excite(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message John Herreshoff 2002-02-16 15:54:15 pg_dump and restore
Previous Message Brian 2002-02-16 02:23:12 join question