| 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
| 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. |