[dak/master] dak/dakdb/update79.py: Use || operator instead of CONCAT to make postgresql 9.0 happy
---
dak/dakdb/update79.py | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/dak/dakdb/update79.py b/dak/dakdb/update79.py
index 67ad01a..954f393 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,
--
1.7.2.5
Reply to: