casting strings to multidimensional arrays yields strange results - Mailing list pgsql-bugs

From Kris Jurka
Subject casting strings to multidimensional arrays yields strange results
Date
Msg-id Pine.BSO.4.56.0407270110260.14015@leary.csoft.net
Whole thread Raw
Responses Re: casting strings to multidimensional arrays yields strange results
List pgsql-bugs
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1200: VACUUM ANALYZE bug
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1201: void functions called through jdbc driver return error