Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group