Documentation Source Text
Check-in [58746651dd]
Not logged in

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

Overview
SHA1 Hash:58746651dd89fece7ab9a4b534dc3bfdce102286
Date: 2010-02-09 23:25:26
User: dan
Comment:Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in.
Tags And Properties
Changes
hide diffs unified diffs patch

Changes to pages/fts3.in

793 SELECT offsets(mail) FROM mail WHERE mail MATCH &lt;full-text query expression 793 SELECT offsets(mail) FROM mail WHERE mail MATCH &lt;full-text query expression 794 SELECT snippet(mail) FROM mail WHERE mail MATCH &lt;full-text query expression 794 SELECT snippet(mail) FROM mail WHERE mail MATCH &lt;full-text query expression 795 SELECT matchinfo(mail) FROM mail WHERE mail MATCH &lt;full-text query expressi 795 SELECT matchinfo(mail) FROM mail WHERE mail MATCH &lt;full-text query expressi 796 </codeblock> 796 </codeblock> 797 797 798 <p> 798 <p> 799 The three auxillary functions are only useful within a SELECT statement that 799 The three auxillary functions are only useful within a SELECT statement that 800 uses the FTS3 table's full-text index. If used within a SELECT that uses | 800 uses the FTS3 table's full-text index. ^If used within a SELECT that uses 801 the "query by rowid" or "linear scan" strategies, then the snippet and 801 the "query by rowid" or "linear scan" strategies, then the snippet and 802 offsets both return an an empty string, and the matchinfo function returns 802 offsets both return an an empty string, and the matchinfo function returns 803 a blob value zero bytes in size. 803 a blob value zero bytes in size. 804 804 805 <p id=matchable> 805 <p id=matchable> 806 All three auxillary functions extract a set of "matchable phrases" from 806 All three auxillary functions extract a set of "matchable phrases" from 807 the FTS3 query expression to work with. The set of matchable phrases for 807 the FTS3 query expression to work with. The set of matchable phrases for