casting strings to multidimensional arrays yields strange results

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: casting strings to multidimensional arrays yields strange results
Date: 2004-07-27 06:16:47
Message-ID: Pine.BSO.4.56.0407270110260.14015@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-patches


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-07-27 06:19:37 BUG #1201: void functions called through jdbc driver return error
Previous Message Tom Lane 2004-07-26 18:19:10 Re: BUG #1200: VACUUM ANALYZE bug

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2004-07-27 06:39:49 Re: Binary Cursors, and the COPY command
Previous Message Marc G. Fournier 2004-07-27 04:13:00 Re: cvsweb upgraded

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-27 12:55:27 Re: win32 version info
Previous Message Tom Lane 2004-07-27 05:22:55 Re: [subxacts] Savepoint syntax