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 <r...@iol.ie <mailto:r...@iol.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@postgresql.org
    <mailto:pgsql-general@postgresql.org>)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-general
    <http://www.postgresql.org/mailpref/pgsql-general>



Reply via email to