BUG #13420: Array function contains with null

From: krzysztof(dot)czajka(at)turcom(dot)pl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13420: Array function contains with null
Date: 2015-06-09 11:29:46
Message-ID: 20150609112946.2794.37090@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13420
Logged by: Krzysztof Czajka
Email address: krzysztof(dot)czajka(at)turcom(dot)pl
PostgreSQL version: 9.3.8
Operating system: CentOS release 6.6 (Final)
Description:

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-06-09 13:48:40 Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Previous Message reiner peterke 2015-06-09 08:56:26 9.5 Import foreign schema error with user defined type in schema other than public.