Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 2A9581337B50
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 21 Sep 2010 04:19:17 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 29199-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 21 Sep 2010 07:19:10 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com
	[209.85.216.181])
	by mail.postgresql.org (Postfix) with ESMTP id D740F1337B4E
	for <pgsql-sql@postgresql.org>; Tue, 21 Sep 2010 04:19:09 -0300 (ADT)
Received: by qyk33 with SMTP id 33so5155361qyk.19
	for <pgsql-sql@postgresql.org>; Tue, 21 Sep 2010 00:19:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=vRNHCQ9mrI+Te9gTpTokMpUzW0WOtBLCabV8ioXNwzs=;
	b=OcRPwD2OlfN29KiOPwIFJan/OA0lp+a76DZx80CflPmetY5psI8SZIcmYJsBGy75AM
	N1TkGxuKWVzpHw2HYLN4jVQuieueKWocyVa98cZaxSKDI4OhPaCOSAQbv100lysajubj
	Pwk1VCcOT2ZVDTCfGi/j13frBKRyakEXdWMEw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=UUw7mcVijpzUepPYRW12GHJplRA7ScR59RyhSUxznUregDkpGqahviGbETl/juFKN5
	mxfS/f+1Z1k3ce/layNifPEQpbOXzTREV++EvpszCOIL8OFCSZMgQkeSYFjlVrS5exfr
	A/uR3TCkAtwj23r7sexUxMS9sG0y7pOlJTQCQ=
MIME-Version: 1.0
Received: by 10.224.67.75 with SMTP id q11mr6634235qai.289.1285053549422; Tue,
	21 Sep 2010 00:19:09 -0700 (PDT)
Received: by 10.229.219.201 with HTTP; Tue, 21 Sep 2010 00:19:08 -0700 (PDT)
In-Reply-To: <4C983B59.3000909@postnewspapers.com.au>
References: <828w2wlrqr.fsf@mid.bfk.de>
	<AANLkTiktR_u-pSaV1BnqdvzOXPqJ-QehM4zB77E8tWyg@mail.gmail.com>
	<4C983B59.3000909@postnewspapers.com.au>
Date: Tue, 21 Sep 2010 11:19:08 +0400
Message-ID: <AANLkTi=E6wasGSWnczvrVPRb=aMErAvFT-ZBdO2Ngh4s@mail.gmail.com>
Subject: Re: Jagged/ragged arrays
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: Florian Weimer <fweimer@bfk.de>, pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0015175d672054b7460490bfd8be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201009/59
X-Sequence-Number: 34590

--0015175d672054b7460490bfd8be
Content-Type: text/plain; charset=ISO-8859-1

Hey Craig, Florian

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

--0015175d672054b7460490bfd8be
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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

--0015175d672054b7460490bfd8be--