* Craig Ringer:
On 21/09/2010 3:42 AM, Dmitriy Igrishin wrote:
Hey Florian,
What do you mean by ragged arrays?
At a guess:
craig= SELECT '{ {1}, {1,2}, {1}, {1,2,3} }'::integer[][];
ERROR: multidimensional arrays must have array expressions with
matching dimensions
(OP) Correct?
Hey Craig, Florian
Ahh, this. Why not just yes NULLs as values of array?
2010/9/21 Craig Ringer cr...@postnewspapers.com.au
On 21/09/2010 3:42 AM, Dmitriy Igrishin wrote:
Hey Florian,
What do you mean by ragged arrays?
At a guess:
craig= SELECT '{ {1}, {1,2}, {1}, {1,2,3}
It seems that PostgreSQL 8.4 does not support ragged arrays. Is there
a workaround to get similar functionality (mainly the ability to
extract values in SQL expressions)?
--
Florian Weimerfwei...@bfk.de
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100
Hey Florian,
What do you mean by ragged arrays?
--
Regards,
Dmitriy
On 21/09/2010 3:42 AM, Dmitriy Igrishin wrote:
Hey Florian,
What do you mean by ragged arrays?
At a guess:
craig= SELECT '{ {1}, {1,2}, {1}, {1,2,3} }'::integer[][];
ERROR: multidimensional arrays must have array expressions with
matching dimensions
(OP) Correct?
--
Craig Ringer