Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL) - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)
Date
Msg-id 20151201132347.GG19371@momjian.us
Whole thread Raw
In response to ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)  (Michael Herold <quabla@hemio.de>)
List pgsql-docs
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                             +


pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)
Next
From: Michael Herold
Date:
Subject: Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)