Documentation Source Text

Check-in [58746651dd]
Login

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

Overview
Comment:Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 58746651dd89fece7ab9a4b534dc3bfdce102286
User & Date: dan 2010-02-09 23:25:26.000
Context
2010-02-11
15:55
Fix typo in the datatype3.html document. (check-in: d9afa1a3d7 user: drh tags: trunk)
2010-02-09
23:25
Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in. (check-in: 58746651dd user: dan tags: trunk)
2010-02-01
16:19
Updates to the matrix generator and to the custombuild.html document. (check-in: 801e11b806 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/fts3.in.
︙︙
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807

  SELECT offsets(mail) FROM mail WHERE mail MATCH <full-text query expression>;
  SELECT snippet(mail) FROM mail WHERE mail MATCH <full-text query expression>;
  SELECT matchinfo(mail) FROM mail WHERE mail MATCH <full-text query expression>;
</codeblock>

<p>
  The three auxillary functions are only useful within a SELECT statement that
  uses the FTS3 table's full-text index. If used within a SELECT that uses
  the "query by rowid" or "linear scan" strategies, then the snippet and
  offsets both return an an empty string, and the matchinfo function returns
  a blob value zero bytes in size.

<p id=matchable>
  All three auxillary functions extract a set of "matchable phrases" from
  the FTS3 query expression to work with. The set of matchable phrases for








|








793
794
795
796
797
798
799
800
801
802
803
804
805
806
807

  SELECT offsets(mail) FROM mail WHERE mail MATCH &lt;full-text query expression&gt;;
  SELECT snippet(mail) FROM mail WHERE mail MATCH &lt;full-text query expression&gt;;
  SELECT matchinfo(mail) FROM mail WHERE mail MATCH &lt;full-text query expression&gt;;
</codeblock>

<p>
  The three auxillary functions are only useful within a SELECT statement that
  uses the FTS3 table's full-text index. ^If used within a SELECT that uses
  the "query by rowid" or "linear scan" strategies, then the snippet and
  offsets both return an an empty string, and the matchinfo function returns
  a blob value zero bytes in size.

<p id=matchable>
  All three auxillary functions extract a set of "matchable phrases" from
  the FTS3 query expression to work with. The set of matchable phrases for
︙︙