title: Help with Nagios check_postgres.pl custom query
body: <p>I have a postgres function that returns two columns</p>
  
  <p>result, data
  (int), (text)</p>
  
  <p>If I run this command from postgres it returns the proper values and if I run it from the linux command line like this:</p>
  
  <p>/usr/local/nagios/libexec/check_postgres.pl -H $HOSTADDRESS$ -u postgres -db monitordb --action=custom_query --critical=1 --query="SELECT * from ops_get_status();"</p>
  
  <p>It also return the proper values - at least it seems to and I don't get any errors.</p>
  
  <p>But when I insert it in the commands.cfg and watch this through the Nagios frontend 
  it return (null).</p>
  
  <p>The log file doesn't contain any detailed information for debugging this.  So, what can I do to get to the bottom of this issue - any help greatly appreciated</p>
  
  <p>result</p>