UNNEST is a table function; therefore, it can only appear in the FROM clause of an SQL SELECT statement.
If the ARRAY expression argument evaluates to NULL, then no rows will be returned in the result table. If the ARRAY expression argument is not NULL but has one or more elements that are not present, then the column value for the array element in the corresponding result row will be NULL.