diff options
author | Yorhel <git@yorhel.nl> | 2010-11-03 10:09:58 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-11-03 10:09:58 +0100 |
commit | bfa5493c5caf1f2fe17344773f6bee6c9f55e24d (patch) | |
tree | 1033b324b2e1ccc9f1904dd1bd372fff969e63a3 /util | |
parent | 64c8ed43810286bfee386745ab0f50328e3589a9 (diff) |
Use newlines to separate VN aliases
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_2.12.sql | 5 |
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; |