Postgres 17

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

select version();

version

PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

SELECT 1 IN (SELECT id::integer FROM (VALUES(1, NULL)) v(id))

?column?

t

SELECT 1

SELECT 1 NOT IN (SELECT id::integer FROM (VALUES(1, NULL)) v(id))

?column?

f

SELECT 1

SELECT 1 IN (SELECT id::integer FROM (VALUES(NULL, 1)) v(id))

?column?

null

SELECT 1

SELECT 1 NOT IN (SELECT id::integer FROM (VALUES(NULL, 1)) v(id))

?column?

null

SELECT 1

SELECT 1 IN (SELECT id::integer FROM (VALUES(NULL, 1)) v(id) WHERE id IS NOT NULL)

?column?

f

SELECT 1

SELECT 1 NOT IN (SELECT id::integer FROM (VALUES(NULL, 1)) v(id) WHERE id IS NOT NULL)

?column?

t

SELECT 1