From: Richard Huxton <dev@archonet.com>
To: Grzegorz Szpetkowski <gszpetkowski@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: CROSS JOIN ordering
Date: Thu, 12 May 2011 12:01:41 +0100
Message-ID: <4DCBBE15.8030806@archonet.com> (raw)
In-Reply-To: <BANLkTinuD-nSNJ0LVWaSgBNRGsYZ2QJYoQ@mail.gmail.com>
References: <BANLkTinuD-nSNJ0LVWaSgBNRGsYZ2QJYoQ@mail.gmail.com>
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
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: dev@archonet.com, gszpetkowski@gmail.com
Subject: Re: CROSS JOIN ordering
In-Reply-To: <4DCBBE15.8030806@archonet.com>
* 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