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;