Changeset 6510 for trunk/include/dblayer/functions_pgsql.inc.php

Timestamp:

Jun 9, 2010, 10:25:03 PM (14 years ago)

Author:

nikrou

Message:

Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clause
or agregate function
Fix issue for lambda function (incorrect number of params)

File:

• trunk/include/dblayer/functions_pgsql.inc.php (modified) (4 diffs)

trunk/include/dblayer/functions_pgsql.inc.php

@@ -315 +315 @@
       }
     } // foreach update
-  } // if mysql_ver or count<X
+  } 
   else
   {
@@ -327 +327 @@
     mass_inserts($temporary_tablename, $all_fields, $datas);
     if ( $flags & MASS_UPDATES_SKIP_EMPTY )
-      $func_set = create_function('$s, $t', 'return "$s = IFNULL(t2.$s, '.$tablename.'.$s)";');
+      $func_set = create_function('$s', 'return "$s = NULLIF(t2.$s, '.$tablename.'.$s)";');
     else
       $func_set = create_function('$s', 'return "$s = t2.$s";');
@@ -344 +344 @@
         "\n    AND ",
         array_map(
-          create_function('$s, $t', 'return "'.$tablename.'.$s = t2.$s";'),
+          create_function('$s', 'return "'.$tablename.'.$s = t2.$s";'),
           $dbfields['primary']
           )
@@ -586 +586 @@
 
 // my_error returns (or send to standard output) the message concerning the
-// error occured for the last mysql query.
+// error occured for the last pgsql query.
 function my_error($header, $die)
 {