Re: Generic way to test input arguments

oyoun <oyoun@xxxxxxx> · Tue, 18 Oct 2016 11:01:27 -0400



    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@xxxxxx>:

              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@xxxxxxxxxxxxxx)

                    To make changes to your subscription:

                    http://www.postgresql.org/mailpref/pgsql-general