How to determine if NULL is contained in an array in Postgres?

Question

How do I determine if NULL is contained in an array in Postgres? Currently using Postgres 9.3.3.

If I test with the following select it returns contains_null = false.

select ARRAY[NULL,1,2,3,4,NULL]::int[] @> ARRAY[NULL]::int[] AS contains_null
select ARRAY[NULL,1,2,3,4,NULL]::int[] @> NULL AS contains_null

Accepted Answer

select exists (    select 1     from unnest(array[1, null]) s(a)    where a is null); exists -------- tOr shorter:select bool_or(a is null)from unnest(array[1, null]) s(a); bool_or --------- t

Advertisement

Answer