Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0

From:	Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0
Date:	2016-08-08 18:24:25
Message-ID:	CAADeyWgFxfeegvADs4=jR4Rm=VG00=4J2WL37H12mUc4E_DyuQ@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2016-08-08 18:12:47 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>  2016-08-08 18:19:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2016-08-08 18:24:25 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>    2016-08-08 18:31:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2016-08-08 21:51:44 from Alban Hertroys <haramrae(at)gmail(dot)com>    2016-08-08 22:14:26 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>     2016-08-08 23:18:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-general

In response to

• Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0 at 2016-08-08 18:19:58 from Tom Lane

Responses

• Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0 at 2016-08-08 18:31:18 from Tom Lane

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2016-08-08 18:31:18	Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0
Previous Message	Tom Lane	2016-08-08 18:19:58	Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0