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