Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8445=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1a3mei-00006Y-M1
 for pgsql-docs@arkaria.postgresql.org; Tue, 01 Dec 2015 15:15:48 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-docs-owner+M8445=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1a3mei-0002zn-8j
 for pgsql-docs@arkaria.postgresql.org; Tue, 01 Dec 2015 15:15:48 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <quabla@hemio.de>) id 1a3jx4-0002pr-AA
 for pgsql-docs@postgresql.org; Tue, 01 Dec 2015 12:22:34 +0000
Received: from mail.hemio.de ([144.76.93.186])
 by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <quabla@hemio.de>) id 1a3jx1-0003Fv-EA
 for pgsql-docs@postgresql.org; Tue, 01 Dec 2015 12:22:32 +0000
X-Original-To-Masked: <masked>
X-Original-To-Masked: <masked>
X-Original-To-Masked: <masked>
Received: from user.client (localhost [144.76.93.186])
 by mail.hemio.de (Postfix) with ESMTPSA id 9E87570;
 Tue,  1 Dec 2015 13:22:27 +0100 (CET)
Message-ID: <565D9101.40303@hemio.de>
Date: Tue, 01 Dec 2015 13:22:25 +0100
From: Michael Herold <quabla@hemio.de>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:31.0) Gecko/20100101 Icedove/31.8.0
MIME-Version: 1.0
To: Bruce Momjian <bruce@momjian.us>
CC: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-docs@postgresql.org
Subject: Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)
References: <559DC0CE.90900@hemio.de> <32402.1436450457@sss.pgh.pa.us>
 <562DFAB8.9050507@hemio.de> <20151130235919.GC19371@momjian.us>
In-Reply-To: <20151130235919.GC19371@momjian.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -4.2 (----)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On 01/12/15 00:59, Bruce Momjian wrote:
> I would argue that '{}'::int[] is zero dimmensions, so there is no
> documented behavior for this.

Thank you for your reply. Agree, I am writing to pgsql-docs because I 
think this should be fixed with proper documentation.

My actual concern is that it is totally unclear how to (re)set the lower 
bound of an array. At least I waisted an our to figure that out.


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs