Re: Anti join confusion

On Mon, Feb 24, 2025 at 8:08 AM wenhui qiu <qiuwenhuifx@gmail.com> wrote:
>     Actually ,Many fork postgresql databases have already implemented ,For example, if the relevant field has a
non-nullconstraint ，Many databases can do the same thing as not exist （ MySQL ，SQL Server，Oracle） 

I'm not surprised to hear it. Long-time PostgreSQL users just don't
use NOT IN, so it's fine, but anyone coming from another database gets
hosed. I think it would be good to put some effort into improving this
area, but I do not have time to work on it myself.

--
Robert Haas
EDB: http://www.enterprisedb.com