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 11132.1470681078@sss.pgh.pa.us
Whole thread Raw
In response to Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
Alexander Farber <alexander.farber@gmail.com> writes:
> Thank you, so should I maybe switch to cardinality then?

Yeah, that should work.

            regards, tom lane

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0
Next
From: "David G. Johnston"
Date:
Subject: Re: Column order in multi column primary key