Postgres Pro
Downloads
Home   >   mailing lists

Re: Parentheses in FROM clause and evaluation order. - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Parentheses in FROM clause and evaluation order.
Date
Msg-id 20050815183859.U67925@megazone.bigpanda.com
Whole thread Raw
In response to Parentheses in FROM clause and evaluation order.  (dario.mx@gmail.com)
Responses Re: Parentheses in FROM clause and evaluation order.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with a Pettern Matching Check
Next
From: Tom Lane
Date:
Subject: Re: Parentheses in FROM clause and evaluation order.