aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2010-06-22 21:19:17 +0000
committernikrou <nikrou@piwigo.org>2010-06-22 21:19:17 +0000
commitc04a906ec455e40a79407ab65477308afebc2ec2 (patch)
treefba97570b185a6378364db3b10668f1dd059b4d2
parent1661af7f3f10bd303d2a1e71054fe9ba57954604 (diff)
Bug 1737 fixed : merge from trunk
Concatenation error with POstgreSQL Simplify same function for SQLite git-svn-id: http://piwigo.org/svn/branches/2.1@6581 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--include/dblayer/functions_pdo-sqlite.inc.php4
-rw-r--r--include/dblayer/functions_pgsql.inc.php6
-rw-r--r--include/dblayer/functions_sqlite.inc.php4
3 files changed, 4 insertions, 10 deletions
diff --git a/include/dblayer/functions_pdo-sqlite.inc.php b/include/dblayer/functions_pdo-sqlite.inc.php
index 2f1727e75..ea47564f0 100644
--- a/include/dblayer/functions_pdo-sqlite.inc.php
+++ b/include/dblayer/functions_pdo-sqlite.inc.php
@@ -413,9 +413,7 @@ function pwg_db_concat($array)
function pwg_db_concat_ws($array, $separator)
{
- $glue = sprintf(' || \'%s\' || ', $separator);
-
- return implode($array, $glue);
+ return implode($array, ' || \''.$separator.'\' || ');
}
function pwg_db_cast_to_text($string)
diff --git a/include/dblayer/functions_pgsql.inc.php b/include/dblayer/functions_pgsql.inc.php
index 8a300b7ad..3c68f7816 100644
--- a/include/dblayer/functions_pgsql.inc.php
+++ b/include/dblayer/functions_pgsql.inc.php
@@ -449,14 +449,12 @@ WHERE tablename like \''.$prefixeTable.'%\'';
function pwg_db_concat($array)
{
- $string = implode($array, ',');
- return 'ARRAY_TO_STRING(ARRAY['.$string.'])';
+ return implode($array, ' || ');
}
function pwg_db_concat_ws($array, $separator)
{
- $string = implode($array, ',');
- return 'ARRAY_TO_STRING(ARRAY['.$string.'],\''.$separator.'\')';
+ return implode($array, ' || \''.$separator.'\' || ');
}
function pwg_db_cast_to_text($string)
diff --git a/include/dblayer/functions_sqlite.inc.php b/include/dblayer/functions_sqlite.inc.php
index 7a33b09a2..7e21e128c 100644
--- a/include/dblayer/functions_sqlite.inc.php
+++ b/include/dblayer/functions_sqlite.inc.php
@@ -425,9 +425,7 @@ function pwg_db_concat($array)
function pwg_db_concat_ws($array, $separator)
{
- $glue = sprintf(' || \'%s\' || ', $separator);
-
- return implode($array, $glue);
+ return implode($array, ' || \''.$separator.'\' || ');
}
function pwg_db_cast_to_text($string)