X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 948B153853 for ; Mon, 2 May 2005 01:26:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28367-03 for ; Mon, 2 May 2005 04:26:30 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 2E7EA53539 for ; Mon, 2 May 2005 01:26:29 -0300 (ADT) Received: (qmail invoked by alias); 02 May 2005 04:26:28 -0000 Received: from ip26.65.1311D-CUD12K-02.ish.de (EHLO [192.168.1.1]) [62.143.65.26] by mail.gmx.net (mp023) with SMTP; 02 May 2005 06:26:28 +0200 X-Authenticated: #3894346 Mime-Version: 1.0 (Apple Message framework v622) In-Reply-To: <10431.1115007066@sss.pgh.pa.us> References: <178c0af58f0514c54835d2e0723c525a@gmx.net> <10431.1115007066@sss.pgh.pa.us> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <60948b9fc1ee07c0f106ed4585a08f84@gmx.net> Content-Transfer-Encoding: 7bit From: Leo Fink Subject: Re: Array of Arrays of int Date: Mon, 2 May 2005 06:26:28 +0200 To: pgsql-sql@postgresql.org X-Mailer: Apple Mail (2.622) X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/9 X-Sequence-Number: 21322 Hello Tom. Am 02.05.2005 um 06:11 schrieb Tom Lane: > Leo Fink writes: >> Why does >> select array(select array[1,2]); >> give me an error: "could not find array type for data type integer[]"? > > We don't do arrays of arrays. You seem to be hoping for a 2-D array, > which is something fundamentally different (even though some > programming > languages consider them the same ;-)) Actually, I don't. In my application I can work around the problem by using an array of string representations of these pairs, or by using two arrays of ints. I just thought that was less elegant and I was missing something obvious. Thanks for your quick response. Best, Leo