Documentation Source Text

Check-in [1bbbec6248]
Login

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

Overview
Comment:Fix one more typo in fts5.in.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 1bbbec6248382b311dc2d829180e07280a0e45a9
User & Date: dan 2015-10-09 12:10:28.979
Context
2015-10-09
14:00
Update the documentation for the version numbering change. (check-in: 4fc9d7ce50 user: drh tags: trunk)
12:10
Fix one more typo in fts5.in. (check-in: 1bbbec6248 user: dan tags: trunk)
12:09
Fix typos in fts5.in. (check-in: cc68da99a4 user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/fts5.in.
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
if the "content_rowid" option is set within the CREATE VIRTUAL TABLE statement,
by the value of that option. <cols> is replaced by a comma-separated list
of the FTS5 table column names. For example:

<codeblock>
  <i>-- If the database schema is: </i>
  CREATE TABLE tbl (a, b, c, d INTEGER PRIMARY KEY);
  CREATE TABLE VIRTUAL fts USING fts5(a, c, content=tbl, content_rowid=d);

  <i>-- Fts5 may issue queries such as:</i>
  SELECT d, a, c FROM tbl WHERE d = ?;
</codeblock>

<p> The content table may also be queried as follows:








|







626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
if the "content_rowid" option is set within the CREATE VIRTUAL TABLE statement,
by the value of that option. &lt;cols&gt; is replaced by a comma-separated list
of the FTS5 table column names. For example:

<codeblock>
  <i>-- If the database schema is: </i>
  CREATE TABLE tbl (a, b, c, d INTEGER PRIMARY KEY);
  CREATE VIRTUAL TABLE fts USING fts5(a, c, content=tbl, content_rowid=d);

  <i>-- Fts5 may issue queries such as:</i>
  SELECT d, a, c FROM tbl WHERE d = ?;
</codeblock>

<p> The content table may also be queried as follows: