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