Date: Tue, 1 Dec 2015 08:23:47 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Michael Herold <quabla@hemio.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-docs@postgresql.org
Subject: Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)
Message-ID: <20151201132347.GG19371@momjian.us>
References: <559DC0CE.90900@hemio.de> <32402.1436450457@sss.pgh.pa.us>
 <562DFAB8.9050507@hemio.de> <20151130235919.GC19371@momjian.us>
 <565D9101.40303@hemio.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <565D9101.40303@hemio.de>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On Tue, Dec  1, 2015 at 01:22:25PM +0100, Michael Herold wrote:
> 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.

Right.  I think the docs just don't explain what happens in the case you
showed.

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

Yes, I am not sure how to do that either.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +


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