Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Michael Herold <quabla(at)hemio(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-docs(at)postgresql(dot)org
Subject: Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)
Date: 2015-12-01 13:23:47
Message-ID: 20151201132347.GG19371@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)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 +

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Petr Jelinek 2015-12-03 16:19:53 Re: [DOCS] max_worker_processes on the standby
Previous Message Michael Herold 2015-12-01 12:22:25 Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL)