Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Are we anywhere with optimizing IN to EXISTS? I didn't think there was
> any work being done in that area.
I don't think it's that hard to do within the outer-join mechanism,
except for this little issue about NULLs. The planner already makes
querytree alterations of comparable complexity, to deal with views and
subselects...
regards, tom lane