krzysztof(dot)czajka(at)turcom(dot)pl writes:
> Function contains on array with null element isn't work correctly.
> SELECT ARRAY[1,4,3] @> ARRAY[3,1]
> true
> SELECT ARRAY[ NULL ] @> ARRAY[ NULL ]
> false
> SELECT ARRAY[ NULL::varchar,'2' ] @> ARRAY[ NULL::varchar ]
> false
That looks fine to me, because NULL isn't equal to NULL.
regards, tom lane