Ludwig Lim <lud_nowhere_man(at)yahoo(dot)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