Re: [SQL] Parentheses in FROM clause and evaluation order.

2005-08-18 Thread Dario Bahena Tapia
Hi, 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? Thanks for your response. salu2 dario estepario ... 2005/8/15, Stephan Szabo <[EMAIL PROTECTED]>: > On Wed, 10 Aug 2005 [EMAIL PROTECTED] wrote: >

Re: [SQL] Parentheses in FROM clause and evaluation order.

2005-08-18 Thread Dario Bahena Tapia
Ok, thanks for the responses guys. Then, in the case where the final result is the same, could we think the parentheses in the FROM clause, as a tool to clarify the query to the user? Since in the end, this order could be changed by the implementation for performance reasons. salu2 dario estepari

Re: [SQL] Parentheses in FROM clause and evaluation order.

2005-08-15 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> 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 p

Re: [SQL] Parentheses in FROM clause and evaluation order.

2005-08-15 Thread Stephan Szabo
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

Re: [SQL] Parentheses in FROM clause and evaluation order.

2005-08-15 Thread Stephan Szabo
On Wed, 10 Aug 2005 [EMAIL PROTECTED] wrote: > I thought that the parenthesis in the table expression > (FROM clause), could be used to indicate the desired > evaluation order. But, I tried with a couple of samples > and the explain command returned me the same result; no matter > what parentheses

[SQL] Parentheses in FROM clause and evaluation order.

2005-08-14 Thread dario . mx
Hi, I thought that the parenthesis in the table expression (FROM clause), could be used to indicate the desired evaluation order. But, I tried with a couple of samples and the explain command returned me the same result; no matter what parentheses association I used. I am using only INNER JOINs.