Postgres Pro
Downloads
Home   >   mailing lists

Thread: Jagged/ragged arrays

Jagged/ragged arrays

From
Florian Weimer
Date:
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

Re: Jagged/ragged arrays

From
Dmitriy Igrishin
Date:
Hey Florian,<br /><br />What do you mean by "ragged" arrays?<br /><br />-- <br />Regards,<br />Dmitriy<br /><br /><br
/>

Re: Jagged/ragged arrays

From
Craig Ringer
Date:
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/

Re: Jagged/ragged arrays

From
Florian Weimer
Date:
* 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

Re: Jagged/ragged arrays

From
Dmitriy Igrishin
Date:
Hey Craig, Florian<br /><br />Ahh, this. Why not just yes NULLs as values of array?<br /><br /><div
class="gmail_quote">2010/9/21Craig Ringer <span dir="ltr"><<a
href="mailto:craig@postnewspapers.com.au">craig@postnewspapers.com.au</a>></span><br/><blockquote
class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left:
1ex;"><divclass="im">On 21/09/2010 3:42 AM, Dmitriy Igrishin wrote:<br /><blockquote class="gmail_quote" style="margin:
0pt0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> Hey Florian,<br /><br /> What do you
meanby "ragged" arrays?<br /></blockquote><br /></div> At a guess:<br /><br /> craig=> SELECT '{ {1}, {1,2}, {1},
{1,2,3}}'::integer[][];<br /> ERROR:  multidimensional arrays must have array expressions with matching dimensions<br
/><br/> (OP) Correct?<br /><font color="#888888"><br /> -- <br /> Craig Ringer<br /><br /> Tech-related writing at <a
href="http://soapyfrogs.blogspot.com/"target="_blank">http://soapyfrogs.blogspot.com/</a><br
/></font></blockquote></div><br/><br clear="all" /><br />-- <br />Regards,<br />Dmitriy<br /><br /><br />