Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4E4851337B4F for ; Tue, 21 Sep 2010 04:19:16 -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 05520-10 for ; Tue, 21 Sep 2010 07:19:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by mail.postgresql.org (Postfix) with ESMTP id 40D701337B4C for ; Tue, 21 Sep 2010 04:19:09 -0300 (ADT) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) id 1Oxx84-00079z-LA; Tue, 21 Sep 2010 07:19:04 +0000 Received: by bfk.de with local id 1Oxx84-0000VZ-D7; Tue, 21 Sep 2010 07:19:04 +0000 To: Craig Ringer Cc: Dmitriy Igrishin , pgsql-sql@postgresql.org Subject: Re: Jagged/ragged arrays References: <828w2wlrqr.fsf@mid.bfk.de> <4C983B59.3000909@postnewspapers.com.au> From: Florian Weimer Date: Tue, 21 Sep 2010 07:19:04 +0000 In-Reply-To: <4C983B59.3000909@postnewspapers.com.au> (Craig Ringer's message of "Tue\, 21 Sep 2010 12\:58\:01 +0800") Message-ID: <82mxrbh8d3.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/58 X-Sequence-Number: 34589 * 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=3D> 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. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99