Postgres Pro
Downloads
Home   >   mailing lists

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

From krzysztof.czajka@turcom.pl
Subject BUG #13420: Array function contains with null
Date
Msg-id 20150609112946.2794.37090@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13420: Array function contains with null  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13420
Logged by:          Krzysztof Czajka
Email address:      krzysztof.czajka@turcom.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

pgsql-bugs by date:

Previous
From: reiner peterke
Date:
Subject: 9.5 Import foreign schema error with user defined type in schema other than public.
Next
From: nnd@go.com
Date:
Subject: BUG #13419: could not adopt C locale