Re: unnest

On Fri, 5 Nov 2004, John Hansen wrote:

> Does anyone know how to check individual array elements for NULL values?
> PG_ARG_ISNULL() seems to return true if ANY array element is null; ex::
> array[1,2,3,null,4,5]

Arrays cannot store NULL elements, check your above statement and see that
the whole thing is NULL when you introduce a NULL element:

# select array[1,2,3,null,4,5];
array
-------

(1 row)

or

# select array[1,2,3,null,4,5] IS NULL;
?column?
----------
t
(1 row)

Kris Jurka