Re: BUG #13420: Array function contains with null

krzysztof.czajka@turcom.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