Re: CROSS JOIN ordering - Mailing list pgsql-sql

From Richard Huxton
Subject Re: CROSS JOIN ordering
Date
Msg-id 4DCBBE15.8030806@archonet.com
Whole thread Raw
In response to CROSS JOIN ordering  (Grzegorz Szpetkowski <gszpetkowski@gmail.com>)
List pgsql-sql
On 12/05/11 00:19, Grzegorz Szpetkowski wrote:
> Is there any "proper", standard ordering that I can assume for sure ?
> Maybe PostgreSQL 8.4/9.0 versions have strict ordering and older
> versions are using mixed ordering depends on something I don't know (I
> am just guessing).

Queries do not have any guaranteed order unless you add an ORDER BY 
clause. None of them, no matter how simple.

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Grzegorz Szpetkowski
Date:
Subject: CROSS JOIN ordering
Next
From: Lew
Date:
Subject: Re: replace " with nothing