Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 11.19 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-16), 64-bit

SELECT 1

create table t (tid int primary key);

CREATE TABLE

select * from t ;

tid

SELECT 0

create table one (oneid int primary key);

CREATE TABLE

insert into one (oneid)
values (1) ;

INSERT 0 1

select * from one ;

oneid

1

SELECT 1

SELECT 1
FROM one
WHERE NULL IN (SELECT 1 FROM t WHERE 1 = 0);

?column?

SELECT 0

SELECT 1
FROM one
WHERE NULL NOT IN (SELECT 1 FROM t WHERE 1 = 0);

?column?

1

SELECT 1

select NULL IN (SELECT 1 FROM t WHERE 1 = 0) ;

?column?

f

SELECT 1

select NULL NOT IN (SELECT 1 FROM t WHERE 1 = 0) ;

?column?

t

SELECT 1