diff options
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.26.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/util/updates/update_2.26.sql b/util/updates/update_2.26.sql index 444666f8..2d5251a6 100644 --- a/util/updates/update_2.26.sql +++ b/util/updates/update_2.26.sql @@ -33,3 +33,14 @@ ALTER TABLE threads_poll_votes ADD CONSTRAINT threads_poll_votes_optid_fke -- Tagalog language ALTER TYPE language ADD VALUE 'ta' BEFORE 'tr'; + + +-- Improved substring search relevance +CREATE OR REPLACE FUNCTION substr_score(str text, pattern text) RETURNS integer AS $$ +SELECT CASE + WHEN str ILIKE pattern THEN 0 + WHEN str ILIKE pattern||'%' THEN 1 + WHEN str ILIKE '%'||pattern||'%' THEN 2 + ELSE 3 +END; +$$ LANGUAGE SQL; |