casting strings to multidimensional arrays yields strange results

Поиск
Список
Период
Сортировка
Искать
От
Kris Jurka
Тема
casting strings to multidimensional arrays yields strange results
Дата
Msg-id
Pine.BSO.4.56.0407270110260.14015@leary.csoft.net
Список
Дерево обсуждения
casting strings to multidimensional arrays yields strange results Kris Jurka <books@ejurka.com>
Re: casting strings to multidimensional arrays yields strange results Tom Lane <tgl@sss.pgh.pa.us>
Re: casting strings to multidimensional arrays yields strange Joe Conway <mail@joeconway.com>
Re: casting strings to multidimensional arrays yields strange results Tom Lane <tgl@sss.pgh.pa.us>
Re: casting strings to multidimensional arrays yields strange Kris Jurka <books@ejurka.com>
Re: casting strings to multidimensional arrays yields strange results Tom Lane <tgl@sss.pgh.pa.us>
Casting strings to multidimensional arrays yields strange results.  In one 
case there are discard values and the other a value magically appears.  
Trying both of these with the array[] constructor syntax yields the 
expected:
ERROR:  multidimensional arrays must have array expressions with matching 
dimensions

Tested on both 7.4.3 and 7.5dev.

Kris Jurka

jurka=# SELECT '{{1,2},{2,3},{4}}'::int[][];
     int4      
---------------
 {{1},{2},{4}}

jurka=# SELECT '{{1},{2,3},{4,5}}'::int[][];
        int4         
---------------------
 {{1,0},{2,3},{4,5}}
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: PostgreSQL Bugs List
Дата:
FAQ