Re: Parentheses in FROM clause and evaluation order.

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Dario Bahena Tapia <dario(dot)mx(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Parentheses in FROM clause and evaluation order.
Date: 2005-08-16 01:48:28
Message-ID: 20050815183859.U67925@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-08-16 02:02:40 Re: Parentheses in FROM clause and evaluation order.
Previous Message Tom Lane 2005-08-16 01:14:58 Re: Problem with a Pettern Matching Check