Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix an error in fts5.in. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
8f8e1e988f1fb5a38677b2318d9fdab0 |
| User & Date: | dan 2015-06-19 18:57:23 |
Context
|
2015-06-20
| ||
| 14:29 | Update description of AFL testing. check-in: 73745849d3 user: drh tags: trunk | |
|
2015-06-19
| ||
| 18:57 | Fix an error in fts5.in. check-in: 8f8e1e988f user: dan tags: trunk | |
|
2015-06-17
| ||
| 16:05 | Further tweaks to the matchinfo() documentation. check-in: d0b390051e user: drh tags: trunk | |
Changes
Changes to pages/fts5.in.
806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 |
selected so as to maximize the number of queried terms it contains.
</ul>
<h3 tags="FTS5 bm25">The bm25() function</h3>
<p> The built-in auxiliary function bm25() returns a real value indicating
how well the current row matches the full-text query. The better the match,
the larger the value returned. A query such as the following may be used
to return matches in order from best to worst match:
<codeblock>
SELECT * FROM fts WHERE fts MATCH ? ORDER BY bm25(fts)
</codeblock>
<p> In order to calculate a documents score, the full-text query is separated
into its component phrases. The bm25 score for document <i>D</i> and
|
| | |
806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 |
selected so as to maximize the number of queried terms it contains.
</ul>
<h3 tags="FTS5 bm25">The bm25() function</h3>
<p> The built-in auxiliary function bm25() returns a real value indicating
how well the current row matches the full-text query. The better the match,
the numerically smaller the value returned. A query such as the following may
be used to return matches in order from best to worst match:
<codeblock>
SELECT * FROM fts WHERE fts MATCH ? ORDER BY bm25(fts)
</codeblock>
<p> In order to calculate a documents score, the full-text query is separated
into its component phrases. The bm25 score for document <i>D</i> and
|