Обсуждение: Jagged/ragged arrays
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 Weimer <fweimer@bfk.de> BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99
Hey Florian,<br /><br />What do you mean by "ragged" arrays?<br /><br />-- <br />Regards,<br />Dmitriy<br /><br /><br />
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-related writing at http://soapyfrogs.blogspot.com/
* 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?
Yes, this is what I'm after.
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
Hey Craig, Florian
Ahh, this. Why not just yes NULLs as values of array?
--
Regards,
Dmitriy
Ahh, this. Why not just yes NULLs as values of array?
2010/9/21 Craig Ringer <craig@postnewspapers.com.au>
On 21/09/2010 3:42 AM, Dmitriy Igrishin wrote:At a guess:Hey Florian,
What do you mean by "ragged" arrays?
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-related writing at http://soapyfrogs.blogspot.com/
--
Regards,
Dmitriy