Postgres Pro
Downloads
Home   >   mailing lists

number of not null arguments - Mailing list pgsql-general

From Murat Kabilov
Subject number of not null arguments
Date
Msg-id AANLkTim6Smk5BtOBSNK=s6AWiADxbzrYrqon79MC2cof@mail.gmail.com
Whole thread Raw
Responses Re: number of not null arguments
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: plpyhton
Next
From: Leif Jensen
Date:
Subject: Help on explain analyze