Re: Jagged/ragged arrays

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Florian Weimer <fweimer(at)bfk(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Jagged/ragged arrays
Date: 2010-09-21 07:19:08
Message-ID: AANLkTi=E6wasGSWnczvrVPRb=aMErAvFT-ZBdO2Ngh4s@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hey Craig, Florian

Ahh, this. Why not just yes NULLs as values of array?

2010/9/21 Craig Ringer <craig(at)postnewspapers(dot)com(dot)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} }'::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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michele Petrazzo - Unipex 2010-09-21 08:11:23 Re: all the table values equal
Previous Message Florian Weimer 2010-09-21 07:19:04 Re: Jagged/ragged arrays