Documentation Source Text

Check-in [d075300786]
Login

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

Overview
Comment:Fix two more typos in examples in fts3.in.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d0753007866c39a051f66230defe801ba860ed86
User & Date: dan 2009-12-01 15:30:00.000
Context
2009-12-01
15:41
Update the amalgamation.html page. (check-in: d8e32e270e user: drh tags: trunk)
15:30
Fix two more typos in examples in fts3.in. (check-in: d075300786 user: dan tags: trunk)
14:27
Fix a couple of bugs in the examples in fts3.in. (check-in: 9bd28d637b user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/fts3.in.
︙︙
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711

  SELECT docid FROM docs WHERE docs MATCH 'library';

  <i>-- Query for the set of documents that contains the term "linux", and at least</i>
  <i>-- one of the phrases "sqlite database" and "sqlite library".</i>
  SELECT docid FROM docs WHERE docs MATCH '("sqlite database" OR "sqlite library") AND linux';

  <i>-- This query is equivalent to the above.</i>
  SELECT docid FROM docs WHERE docs MATCH 'linux';
    INTERSECT
  SELECT docid FROM (
    SELECT docid FROM docs WHERE docs MATCH '"sqlite library"'
      UNION
    SELECT docid FROM docs WHERE docs MATCH '"sqlite database"'
  );
}]








|








697
698
699
700
701
702
703
704
705
706
707
708
709
710
711

  SELECT docid FROM docs WHERE docs MATCH 'library';

  <i>-- Query for the set of documents that contains the term "linux", and at least</i>
  <i>-- one of the phrases "sqlite database" and "sqlite library".</i>
  SELECT docid FROM docs WHERE docs MATCH '("sqlite database" OR "sqlite library") AND linux';

  <i>-- This query is equivalent to the above.</i>
  SELECT docid FROM docs WHERE docs MATCH 'linux'
    INTERSECT
  SELECT docid FROM (
    SELECT docid FROM docs WHERE docs MATCH '"sqlite library"'
      UNION
    SELECT docid FROM docs WHERE docs MATCH '"sqlite database"'
  );
}]
︙︙
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167

  part of the %_content table declaration. For example:

[Code {
  <i>-- Virtual table declaration</i>
  CREATE VIRTUAL TABLE abc USING FTS3(a NUMBER, b TEXT, c);

  <i>-- Corresponding %_content table declaration</i>
  CREATE TABLE abc_content(docid INTEGER PRIMARY KEY, c1a, c2b, c2c);
}]

<p>
  The %_content table contains the unadulterated data inserted by the user 
  into the FTS3 virtual table by the user. If the user does not explicitly
  supply a "docid" value when inserting records, one is selected automatically
  by the system.








|








1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167

  part of the %_content table declaration. For example:

[Code {
  <i>-- Virtual table declaration</i>
  CREATE VIRTUAL TABLE abc USING FTS3(a NUMBER, b TEXT, c);

  <i>-- Corresponding %_content table declaration</i>
  CREATE TABLE abc_content(docid INTEGER PRIMARY KEY, c0a, c1b, c2c);
}]

<p>
  The %_content table contains the unadulterated data inserted by the user 
  into the FTS3 virtual table by the user. If the user does not explicitly
  supply a "docid" value when inserting records, one is selected automatically
  by the system.
︙︙