[basedb-cvs] basedb/include/drivers pgsql.inc.php,1.11,1.12

[<tr...@us...>]

Update of /cvsroot/basedb/basedb/include/drivers
In directory sc8-pr-cvs1:/tmp/cvs-serv5885

Modified Files:
	pgsql.inc.php 
Log Message:
Attempt to fix problem with division by zero

Index: pgsql.inc.php
===================================================================
RCS file: /cvsroot/basedb/basedb/include/drivers/pgsql.inc.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** pgsql.inc.php	28 Jan 2003 17:22:54 -0000	1.11
--- pgsql.inc.php	18 Feb 2003 07:28:37 -0000	1.12
***************
*** 487,493 ****
  {
  	if($base)
! 		$e = "(LOG(float8($arg))/LOG($base.))";
  	else
! 		$e = "LOG(float8($arg))";
  	return "CASE WHEN $arg > 0. THEN $e ELSE NULL END";
  }
--- 487,496 ----
  {
  	if($base)
! 	{
! 		$e = "(LOG(CASE WHEN $arg > 0. THEN float8($arg) ELSE 1. END)".
! 			"/LOG($base.))";
! 	}
  	else
! 		$e = "LOG(CASE WHEN $arg > 0. THEN float8($arg) ELSE 1. END)";
  	return "CASE WHEN $arg > 0. THEN $e ELSE NULL END";
  }
***************
*** 496,500 ****
  function db_func_div($num, $denom)
  {
! 	return "CASE WHEN $denom = 0. THEN NULL ELSE $num/$denom END";
  }
  
--- 499,504 ----
  function db_func_div($num, $denom)
  {
! 	return "CASE WHEN $denom = 0. THEN NULL ELSE ".
! 		"$num/(CASE WHEN $denom = 0. THEN 1. ELSE $denom END) END";
  }