Thanks for your explanation.
From: David G. Johnston
Sent: Wednesday, December 8, 2021 11:39 PM
To: Zhenghua Lyu
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Question on not-in and array-eq
On Wed, Dec 8, 2021 at 8:15 AM Zhenghua Lyu
mailto:z
On Wed, Dec 8, 2021 at 8:15 AM Zhenghua Lyu wrote:
> I run the SQL without array expr in other DBs(orcale, sqlite, ...), they
> all behave
> the same as Postgres.
>
> It seems a bit confusing for me that 'not in' and 'in' the same subquery
> both return 0
> rows, but the table contains data.
>
B
