Postgres Pro
Downloads
Home   >   mailing lists

Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0 - Mailing list pgsql-general

From Tom Lane
Subject Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0
Date
Msg-id 10728.1470680398@sss.pgh.pa.us
Whole thread Raw
In response to select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0  (Alexander Farber <alexander.farber@gmail.com>)
Re: select array_remove(ARRAY[NULL,NULL,NULL],NULL); returns {} instead of {NULL,NULL,NULL}  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view 
Alexander Farber <alexander.farber@gmail.com> writes:
> I wonder, why the following returns NULL and not 0 in 9.5.3?

> # select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1);

Because the result of the array_remove is an empty array, which is
defined to be zero-dimensional in PG.

            regards, tom lane

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0
Next
From: Alexander Farber
Date:
Subject: Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0