BUG #8150: NULL emements lost when casting result of unnest()
От | brandstetter@falter.at |
---|---|
Тема | BUG #8150: NULL emements lost when casting result of unnest() |
Дата | |
Msg-id | E1Ub8p6-0006NC-Ja@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #8150: NULL emements lost when casting result of unnest()
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 8150 Logged by: Erwin Brandstetter Email address: brandstetter@falter.at PostgreSQL version: 9.2.4 Operating system: Multiple Description: = PostgreSQL allows to cast the result of unnest() directly. However, I found inconsistent results with NULL elements in the array. With some array types NULL element are lost, while they are retained with others: SELECT unnest('{4,NULL,1}'::int[])::text; i --- 4 (null) 1 SELECT unnest('{1,NULL,4}'::int[])::int8; i --- 1 4 The NULL element is lost in the second case, which is unwarranted as far as I can tell. Tested with the latest PostgreSQL 9.1.9 and 9.2.4. Identical results. I presented the case with more details in this question on Stackoverflow: http://stackoverflow.com/questions/16452501/null-emements-lost-when-casting= -result-of-unnest Accompanied by this demo on SQLfiddle: http://www.sqlfiddle.com/#!12/d41d8/930 As advised by Pavel, I am reporting this as possible bug now. Regards Erwin
В списке pgsql-bugs по дате отправления: