Postgres 16

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

create table t (id int, value int);

CREATE TABLE

insert into t (id, value) values (1, 1), (2, null), (3, 3);

INSERT 0 3

select * from t;

id
value

1
1

2
null

3
3

SELECT 3

select *
from t
where not false or value in (1, 3);

id
value

1
1

2
null

3
3

SELECT 3

select *
from t
where not true or value in (1, 3);

id
value

1
1

3
3

SELECT 2

id	value
1	1
2	null
3	3

id	value
1	1
2	null
3	3