Re: Migration from SQLite Help (Left Join)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nis Jørgensen <nis(at)superlativ(dot)dk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Migration from SQLite Help (Left Join)
Date: 2007-07-31 05:34:08
Message-ID: 6967.1185860048@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?ISO-8859-1?Q?Nis_J=F8rgensen?= <nis(at)superlativ(dot)dk> writes:
> The problem seems to be that you expect

> SELECT a
> FROM b,c LEFT JOIN d

> to be interpreted as

> SELECT a
> FROM (b CROSS JOIN c) LEFT JOIN d

The depressing part of this report is that it sounds like sqlite has
emulated this bit of mysql brain-damage ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2007-07-31 05:56:11 Re: [NOVICE] alter table table add column
Previous Message Ronald Rojas 2007-07-31 05:23:11 Re: [NOVICE] alter table table add column