[HACKERS] Array comparisons involving NULL

[Michael Fuhr]

Is there a built-in way to look for NULL array elements?  I was
thinking of something like NULL IS DISTINCT FROM ALL (array expression)
but that doesn't work:

test=> SELECT NULL IS DISTINCT FROM ALL (ARRAY[1, 2, 3]);
ERROR:  syntax error at or near "ALL" at character 30
LINE 1: SELECT NULL IS DISTINCT FROM ALL (ARRAY[1, 2, 3]);
                                     ^

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster