diff options
| author |  Jebbs <qjebbs@gmail.com> | 2019-02-12 14:20:07 +0800 |
|---|---|---|
| committer |  fguillot <fred@miniflux.net> | 2019-02-11 22:20:07 -0800 |
| commit | 267b7065444b2904e1172817c661709e0b456b80 (patch) | |
| tree | 1880cef296793738bf862ffd32690815b1b31dd8 /database/sql | |
| parent | ed6ae7e0d277c53ac77b5f17327355ca76275556 (diff) | |
Sort search results by relevance
Diffstat (limited to 'database/sql')
| -rw-r--r-- | database/sql/schema_version_22.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/database/sql/schema_version_22.sql b/database/sql/schema_version_22.sql new file mode 100644 index 0000000..1b51e8a --- /dev/null +++ b/database/sql/schema_version_22.sql @@ -0,0 +1 @@ +update entries set document_vectors = setweight(to_tsvector(substring(coalesce(title, '') for 1000000)), 'A') || setweight(to_tsvector(substring(coalesce(content, '') for 1000000)), 'B');
\ No newline at end of file |