Parentheses in FROM clause and evaluation order.

From: dario(dot)mx(at)gmail(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Parentheses in FROM clause and evaluation order.
Date: 2005-08-11 00:42:01
Message-ID: 200508110042.j7B0g1TZ015835@panselmo.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In fact, I thought that the whole table expression was gonna be
evaluated before the WHERE filter. Does the stantard says something
about this evaluation order when the parentheses are present?
Does PostgreSQL implements this behavior?

Thanks in advance.

salu2
dario estepario ...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message nori 2005-08-11 09:48:28 Re: How to alias table columns in result?
Previous Message Mischa Sandberg 2005-08-10 23:09:04 Re: How to alias table columns in result?