aboutsummaryrefslogtreecommitdiffhomepage
path: root/database/sql/schema_version_20.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database/sql/schema_version_20.sql')
-rw-r--r--database/sql/schema_version_20.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sql/schema_version_20.sql b/database/sql/schema_version_20.sql
index 228e162..18461b8 100644
--- a/database/sql/schema_version_20.sql
+++ b/database/sql/schema_version_20.sql
@@ -1,3 +1,3 @@
alter table entries add column document_vectors tsvector;
-update entries set document_vectors = to_tsvector(title || ' ' || coalesce(content, ''));
+update entries set document_vectors = to_tsvector(substring(title || ' ' || coalesce(content, '') for 1000000));
create index document_vectors_idx on entries using gin(document_vectors); \ No newline at end of file