summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-11-03 10:09:58 +0100
committerYorhel <git@yorhel.nl>2010-11-03 10:09:58 +0100
commitbfa5493c5caf1f2fe17344773f6bee6c9f55e24d (patch)
tree1033b324b2e1ccc9f1904dd1bd372fff969e63a3 /util
parent64c8ed43810286bfee386745ab0f50328e3589a9 (diff)
Use newlines to separate VN aliases
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.12.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_2.12.sql b/util/updates/update_2.12.sql
index 288d1c33..eea0ac5c 100644
--- a/util/updates/update_2.12.sql
+++ b/util/updates/update_2.12.sql
@@ -1,4 +1,9 @@
+-- use newlines to separate aliases
+-- (note: this will go wrong with titles that contain a comma. Those have to be fixed manually)
+UPDATE vn_rev SET alias = trim(both ' ' from regexp_replace(alias, ' *, *', E'\n', 'g'));
+
+
-- cache for search
ALTER TABLE vn ADD COLUMN c_search text;