Search Postgresql Archives

Re: change the order of FROM selection to make query work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Thomas Peter" <usenet@xxxxxxxxxxxxxxx>
Subject: Re: change the order of FROM selection to make query work
From: "Brandon Aiken" <BAiken@xxxxxxxxxxxxxxx>
Date: Tue, 26 Sep 2006 11:32:21 -0400
Cc: <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <nFfTliMb.1159276529.1504170.sol00-thomas@xxxxxxxxxxxxxxxxxxxxx>
Thread-index: AcbhcAklWDMVWurIQPeR+VNjyRDlBQAD83Zg
Thread-topic: [GENERAL] change the order of FROM selection to make query work

I think you're doing different join types.  SQLite is probably doing
CROSS JOINs.  PostgreSQL is probably doing at least one INNER JOIN.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- change the order of FROM selection to make query work
  - From: Thomas Peter

Prev by Date: Re: copy losing information
Next by Date: Re: Good books about PL/PGSQL programming?
Previous by thread: Re: change the order of FROM selection to make query work
Next by thread: Re: change the order of FROM selection to make query work
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux