Re: Generic way to test input arguments - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Generic way to test input arguments
Date
Msg-id CAFj8pRDWDu_R=FOb3F9RmPwveV6+Yj44EOTxKY-QLiB1fk_1VQ@mail.gmail.com
Whole thread Raw
In response to Re: Generic way to test input arguments  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Generic way to test input arguments  (oyoun <oyoun@gmx.com>)
List pgsql-general
Hi

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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Generic way to test input arguments
Next
From: Bastien Bodart
Date:
Subject: truncate table restart identity for non-owner