diff options
Diffstat (limited to 'util/updates/update_2.12.sql')
-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; |