Re: Migration from SQLite Help (Left Join) - Mailing list pgsql-sql

From Tom Lane
Subject Re: Migration from SQLite Help (Left Join)
Date
Msg-id 6967.1185860048@sss.pgh.pa.us
Whole thread Raw
In response to Re: Migration from SQLite Help (Left Join)  (Nis Jørgensen <nis@superlativ.dk>)
List pgsql-sql
Nis Jørgensen <nis@superlativ.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


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: [NOVICE] alter table table add column
Next
From: "Jyoti Seth"
Date:
Subject: Re: Database synchronization