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 > 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[][]; > ERRO

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

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 Tech

Re: [SQL] Jagged/ragged arrays

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