Hello,

Is there a function which returns number of not null arguments?

SELECT notnull_count(1, 1, NULL, NULL)
 notnull_count
---------------
             2

SELECT notnull_count(ARRAY[1,2,3], ARRAY[10,20,30], NULL, ARRAY[NULL])
 notnull_count
---------------
             3

Thanks

--
Murat Kabilov

Reply via email to