X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 57935D1E93B for ; Wed, 21 Jan 2004 19:16:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17544-03 for ; Wed, 21 Jan 2004 15:16:16 -0400 (AST) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id 8EF6BD1EC2D for ; Wed, 21 Jan 2004 14:49:38 -0400 (AST) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 781151; Wed, 21 Jan 2004 10:46:44 -0800 Message-ID: <400EC94F.7010703@joeconway.com> Date: Wed, 21 Jan 2004 10:47:43 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Rajesh Kumar Mallah , pgsql-sql@postgresql.org Subject: Re: array_lower /array_prepend doubt References: <400E85EC.4000106@trade-india.com> <1648.1074705270@sss.pgh.pa.us> <400EBEF0.6060005@joeconway.com> <2597.1074708698@sss.pgh.pa.us> <400EC6A2.20007@joeconway.com> <8803.1074710460@sss.pgh.pa.us> In-Reply-To: <8803.1074710460@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/201 X-Sequence-Number: 16594 Tom Lane wrote: > Of course; I suppose this bug goes back to Berkeley days. We just > hadn't recognized it before (or at least I hadn't). > Neither had I. But the changes in 7.4 probably make it more likely people will bump into this as a problem. Without looking to confirm, I believe SQL99 defines an array as always having a lower bound of 1, making our behavior an extension to the standard. We may need another extension to the array literal syntax in order to deal with this. I'll report back after I've had some time to study it. Joe