Re: Generic way to test input arguments

I will try to reproduce this way on postgresql9.4

Thanks

Le 2016-10-17 à 3:30 PM, Pavel Stehule a écrit :
> Hi
>
> 2016-10-17 21:09 GMT+02:00 Raymond O'Donnell <rod(at)iol(dot)ie
> <mailto:rod(at)iol(dot)ie>>:
>
> On 17/10/16 16:40, said assemlal wrote:
>
> Hello,
>
> I am looking for a way to test generically input arguments to
> raise an
> exception if one is either null or empty.
>
> I was thinking to create a function who takes an array to
> check them but
> not sure if it's really good.
>
>
> It's not clear what you want to do here. Can you explain in more
> detail?
>
> What do you mean by "input arguments"? Are you writing functions
> in the database? If so, which language? Some examples of what
> you've tried so far would help too.
>
> Ray.
>
>
> 9.6 has functions for this purpose - num_nulls and num_nonnulls
>
> Regards
>
> Pavel
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> <http://www.postgresql.org/mailpref/pgsql-general>
>
>