Question on OUTER JOINS. - Mailing list pgsql-sql

Hi:
 1) Is the ON clause of an OUTER JOIN always
evaluated first before the WHERE clause?
2) Given the ff SQL statement :
  SELECT employee_id,         a.status as status  FROM permissions a LEFT JOIN      (select * from employee where
employee_id= 3)
 
as b on (a.status=b.status)  WHERE a.status='test';
 Is there a way to rewrite the query as a view such
that one can do:
  select *  from test_view  where employee_id=3 and status='test';

Thank you very much,

ludwig lim

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com