Re: [SQL] Jagged/ragged arrays

2010-09-21 Thread Florian Weimer
* 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?

Re: [SQL] Jagged/ragged arrays

2010-09-21 Thread Dmitriy Igrishin
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}

[SQL] Jagged/ragged arrays

2010-09-20 Thread Florian Weimer
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

Re: [SQL] Jagged/ragged arrays

2010-09-20 Thread Dmitriy Igrishin
Hey Florian, What do you mean by ragged arrays? -- Regards, Dmitriy

Re: [SQL] Jagged/ragged arrays

2010-09-20 Thread 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? -- Craig Ringer