From b02d077cedb6089764004f1409eebdd89f2283de Mon Sep 17 00:00:00 2001
From: Ansgar Burchardt <ansgar@debian.org>
Date: Sun, 12 Aug 2012 14:49:01 +0200
Subject: [PATCH 1/1] dak/dakdb/update79.py: Use || operator instead of CONCAT
 to make postgresql 9.0 happy

---
 dak/dakdb/update79.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/dak/dakdb/update79.py b/dak/dakdb/update79.py
index 67ad01a6..954f393d 100644
--- a/dak/dakdb/update79.py
+++ b/dak/dakdb/update79.py
@@ -47,7 +47,7 @@ def do_update(self):
             CREATE OR REPLACE VIEW world."files-1" AS
               SELECT
                 files.id AS id,
-                CONCAT(component.name, '/', files.filename) AS filename,
+                component.name || '/' || files.filename AS filename,
                 files.size AS size,
                 files.md5sum AS md5sum,
                 files.sha1sum AS sha1sum,
-- 
2.39.2