diff options
author | Yorhel <git@yorhel.nl> | 2015-10-01 19:19:20 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-10-01 19:19:20 +0200 |
commit | 423a37af953817b59879f2d3013a44a54006ec3b (patch) | |
tree | 27c246b66a60eb1dde5ef36d9217ab556c46526b /util/updates | |
parent | b5c3aa020836541ef2e94812ab83e73de364abe4 (diff) |
VN search: Add some more quote characters + & to normalization
As suggested by https://vndb.org/t2520.168
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.25.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/update_2.25.sql b/util/updates/update_2.25.sql index 138ec7a0..07275ae7 100644 --- a/util/updates/update_2.25.sql +++ b/util/updates/update_2.25.sql @@ -63,3 +63,7 @@ CREATE OR REPLACE FUNCTION strip_spoilers(t text) RETURNS text AS $$ -- The website doesn't require the [spoiler] tag to be closed, the outer replace catches that case. SELECT regexp_replace(regexp_replace(t, '\[spoiler\].*?\[/spoiler\]', ' ', 'ig'), '\[spoiler\].*', ' ', 'i'); $$ LANGUAGE sql IMMUTABLE; + + +-- Changes to search normalization +UPDATE vn SET c_search = NULL; |