Documentation Source Text

Check-in [8f8e1e988f]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix an error in fts5.in.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 8f8e1e988f1fb5a38677b2318d9fdab0a2946853
User & Date: dan 2015-06-19 18:57:23.580
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
Unified Diff Ignore Whitespace Patch
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