[dak/master] remove concat function
Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
config/debian/dinstall.functions | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/config/debian/dinstall.functions b/config/debian/dinstall.functions
index abc5bd9..a2db832 100644
--- a/config/debian/dinstall.functions
+++ b/config/debian/dinstall.functions
@@ -232,7 +232,7 @@ function mkfilesindices() {
log "Querying postgres"
local query="
- SELECT CONCAT('./pool/', c.name, '/', f.filename) AS path, a.arch_string AS arch_string
+ SELECT './pool/' || c.name || '/' || f.filename AS path, a.arch_string AS arch_string
FROM files f
JOIN files_archive_map af ON f.id = af.file_id
JOIN component c ON af.component_id = c.id
@@ -280,7 +280,7 @@ function mkfilesindices() {
local suite_id="$(printf %d $1)"
local query
query="
- SELECT DISTINCT CONCAT('./pool/', c.name, '/', f.filename)
+ SELECT DISTINCT './pool/' || c.name || '/' || f.filename
FROM
(SELECT sa.source AS source
FROM src_associations sa
@@ -304,7 +304,7 @@ function mkfilesindices() {
psql -F' ' -A -t -c "$query"
query="
- SELECT CONCAT('./pool/', c.name, '/', f.filename)
+ SELECT './pool/' || c.name || '/' || f.filename)
FROM bin_associations ba
JOIN binaries b ON ba.bin = b.id
JOIN files f ON b.file = f.id
--
1.7.2.5
Reply to: