Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix one more typo in fts5.in. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1bbbec6248382b311dc2d829180e0728 |
| User & Date: | dan 2015-10-09 12:10:28 |
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
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. <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 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:
|