From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nis Jørgensen <nis@superlativ.dk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Migration from SQLite Help (Left Join)
Date: Tue, 31 Jul 2007 01:34:08 -0400
Message-ID: <6967.1185860048@sss.pgh.pa.us> (raw)
In-Reply-To: <f8jt1r$7sp$1@sea.gmane.org>
References: <173c46830707291928p1b701e31u444782ee3e439c96@mail.gmail.com>
<f8jt1r$7sp$1@sea.gmane.org>
=?ISO-8859-1?Q?Nis_J=F8rgensen?= <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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, nis@superlativ.dk
Subject: Re: Migration from SQLite Help (Left Join)
In-Reply-To: <6967.1185860048@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox