Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 31 Jul 2007 01:34:08 -0400
=?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
- References:
- Migration from SQLite Help (Left Join)
- From: Mitchell Vincent
- Re: Migration from SQLite Help (Left Join)
- From: Nis Jørgensen
- Migration from SQLite Help (Left Join)
- Prev by Date: Re: [NOVICE] alter table table add column
- Next by Date: Re: Database synchronization
- Previous by thread: Re: Migration from SQLite Help (Left Join)
- Next by thread: hi
- Indexes: