From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: Dario Bahena Tapia <dario.mx@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Parentheses in FROM clause and evaluation order.
Date: Mon, 15 Aug 2005 22:02:40 -0400
Message-ID: <20489.1124157760@sss.pgh.pa.us> (raw)
In-Reply-To: <20050815183859.U67925@megazone.bigpanda.com>
References: <200508110042.j7B0g1TZ015835@panselmo.fciencias.unam.mx>
<20050815065906.K33261@megazone.bigpanda.com>
<3d104d6f05081509345067d83b@mail.gmail.com>
<20050815183859.U67925@megazone.bigpanda.com>
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Mon, 15 Aug 2005, Dario Bahena Tapia wrote:
>> The final result seems to be the same, I just was curious about the
>> standard behavior. Does the SQl says something about this execution
>> order?
> I believe SQL defines the order to pay attention to parens, so A join (B
> join C) style clauses result in a "table" being derived from B join C and
> another from A joined with that table.
SQL only constrains the results, though. It does not forbid the
implementation from doing the work in whatever way seems best to it,
so long as the results are the same (and "same" does not consider
row ordering).
For example, SQL92 3.3.4.4 says
A conforming implementation is not required to perform the exact
sequence of actions defined in the General Rules, but shall achieve
the same effect on SQL-data and schemas as that sequence.
regards, tom lane
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: tgl@sss.pgh.pa.us, sszabo@megazone.bigpanda.com, dario.mx@gmail.com
Subject: Re: Parentheses in FROM clause and evaluation order.
In-Reply-To: <20489.1124157760@sss.pgh.pa.us>
* 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