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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
