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 по дате отправления
От: PostgreSQL Bugs List
Дата: