On Mon, Feb 24, 2025 at 8:08 AM wenhui qiu <qiuwenhu...@gmail.com> wrote: > Actually ,Many fork postgresql databases have already implemented ,For > example, if the relevant field has a non-null constraint ，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
