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 Alexander Farber
Subject Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0
Date
Msg-id CAADeyWgFxfeegvADs4=jR4Rm=VG00=4J2WL37H12mUc4E_DyuQ@mail.gmail.com
Whole thread Raw
In response to Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: select array_length(array_remove(ARRAY[NULL,NULL,NULL],NULL), 1); returns NULL instead of 0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Thank you, so should I maybe switch to cardinality then?


pgsql-general by date:

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