"Ole Tange" <postgresql(dot)org(at)tange(dot)dk> writes:
> (modulo NULLs which seem to always cause problems in NOT INs).
> Because it can be rewritten, NOT IN should never be much slower than the
> rewritten solution, as PostgreSQL should simply rewrite NOT IN to the
> above.
Let's see, you understand that the rewrite violates the SQL standard
semantics of NOT IN, but you think we should do it anyway?
regards, tom lane