| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jaime Casanova <systemguards(at)gmail(dot)com> |
| Cc: | David Rio Deiros <driodeiros(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, is04607(at)salleurl(dot)edu |
| Subject: | Re: swap relations to be able to execute a left join |
| Date: | 2005-12-09 17:47:19 |
| Message-ID: | 29660.1134150439@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jaime Casanova <systemguards(at)gmail(dot)com> writes:
> On 12/9/05, David Rio Deiros <driodeiros(at)gmail(dot)com> wrote:
>> I am sure there is a good reason why you have to swap the relations
>> in PostgreSQL. Anyone?
> Because PostgreSQL is not broken...
> What i see in this SELECT is an LEFT JOIN between AT and U (note that
> the other relations in the FROM are separated by commas so they have
> nothing to do with LEFT JOIN) and is using a JOIN clause from a
> relation that has nothing to do with the LEFT JOIN...
Right. MySQL apparently thinks that JOIN has the same precedence as
comma in a FROM-list, but anyone who has bothered to read the SQL
standard knows that JOIN is supposed to bind tighter than comma.
Your coworker is depending on a flat-out-incorrect behavior of MySQL.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-12-09 18:58:05 | Re: swap relations to be able to execute a left join |
| Previous Message | Jaime Casanova | 2005-12-09 17:36:21 | Re: swap relations to be able to execute a left join |