Re: Generic way to test input arguments

Hi

2016-10-17 21:09 GMT+02:00 Raymond O'Donnell <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)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>