Re: CROSS JOIN ordering

From: Richard Huxton <dev(at)archonet(dot)com>
To: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: CROSS JOIN ordering
Date: 2011-05-12 11:01:41
Message-ID: 4DCBBE15.8030806@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2011-05-12 20:45:21 Re: ordering by date for each ID
Previous Message Nguyen,Diep T 2011-05-12 01:59:08 ordering by date for each ID