NOT IN and NOT EXIST

Hi,

Postgres optimizer automatically tries to convert an IN clause to Hash Join
(something similar to EXISTS equivalent of that query).

Does a similar translation happen for NOT IN as well? Given that the column
used is NOT NUL.

Select * from emp where deptid not in (select deptid from dept where
deptLocation='New York');

Will this above statement be automatically converted to a plan which would
match below statement?

Select * from emp where not exists (select 1 from dept where
deptLocation='New York' and dept.deptid=emp.deptid);

Regards
Sameer

PS: Sent from my Mobile device. Pls ignore typo n abb