Re: Question on OUTER JOINS. - Mailing list pgsql-sql

Ludwig Lim <lud_nowhere_man@yahoo.com> writes:
>   1) Is the ON clause of an OUTER JOIN always
> evaluated first before the WHERE clause?

No; the planner will do whatever it thinks is the most efficient way
(assuming it can prove that the reordering it wants to do won't change
the query result).

>   Is there a way to rewrite the query as a view such
> that one can do:

I'm really not clear on what you want here.  Better example please?
        regards, tom lane