Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13420: Array function contains with null - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13420: Array function contains with null
Date
Msg-id 29941.1433857802@sss.pgh.pa.us
Whole thread Raw
In response to BUG #13420: Array function contains with null  (krzysztof.czajka@turcom.pl)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Next
From: Dmitri.Bourlatchkov@software.dell.com
Date:
Subject: BUG #13427: postgres.exe fails to start on Korean Windows Server 2008: cannot perform encoding conversion outsid