From 1faa56010afa2f91f1c9ccb0a49789d3d3b811c7 Mon Sep 17 00:00:00 2001 From: Joerg Jaspert Date: Sun, 12 Aug 2012 19:01:13 +0200 Subject: [PATCH 1/1] remove concat function Signed-off-by: Joerg Jaspert --- config/debian/dinstall.functions | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/config/debian/dinstall.functions b/config/debian/dinstall.functions index abc5bd97..a2db8328 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 -- 2.39.2