Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix an obsolete example in the FTS3 documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
c90c7a10154222aa731d84a01f15ae49 |
User & Date: | drh 2017-01-29 11:39:33.023 |
Context
2017-02-02
| ||
14:48 | Update the wording on the description of the WHEN clause on triggers. (check-in: 09d3dc5c51 user: drh tags: trunk) | |
2017-01-29
| ||
11:39 | Fix an obsolete example in the FTS3 documentation. (check-in: c90c7a1015 user: drh tags: trunk) | |
2017-01-28
| ||
14:45 | Updates to the performance graph spreadsheet. (check-in: 63d1835d75 user: drh tags: trunk) | |
Changes
Changes to pages/fts3.in.
︙ | ︙ | |||
306 307 308 309 310 311 312 | <codeblock> <i>-- The examples in this block assume the following FTS table:</i> CREATE VIRTUAL TABLE mail USING fts3(subject, body); SELECT * FROM mail WHERE rowid = 15; <i>-- Fast. Rowid lookup.</i> SELECT * FROM mail WHERE body MATCH 'sqlite'; <i>-- Fast. Full-text query.</i> SELECT * FROM mail WHERE mail MATCH 'search'; <i>-- Fast. Full-text query.</i> | | | 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 | <codeblock> <i>-- The examples in this block assume the following FTS table:</i> CREATE VIRTUAL TABLE mail USING fts3(subject, body); SELECT * FROM mail WHERE rowid = 15; <i>-- Fast. Rowid lookup.</i> SELECT * FROM mail WHERE body MATCH 'sqlite'; <i>-- Fast. Full-text query.</i> SELECT * FROM mail WHERE mail MATCH 'search'; <i>-- Fast. Full-text query.</i> SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20; <i>-- Fast. Rowid lookup.</i> SELECT * FROM mail WHERE subject = 'database'; <i>-- Slow. Linear scan.</i> SELECT * FROM mail WHERE subject MATCH 'database'; <i>-- Fast. Full-text query.</i> </codeblock> <p> In all of the full-text queries above, the right-hand operand of the MATCH operator is a string consisting of a single term. In this case, the MATCH |
︙ | ︙ |