Lines Matching refs:content
8 As of SQLite version 3.7.9, FTS4 supports a new option - "content" -
15 managed by the user (an "external content" FTS4 table).
18 the full-text index, the content option can sometimes be used to achieve
24 documents at all, the content option should be set to an empty string.
28 CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);
68 An "external content" FTS4 table is similar to a contentless table, except
71 virtual table) nominated by the user (hereafter referred to as the "content
72 table"). The FTS4 module never writes to the content table, and writing
73 to the content table does not affect the full-text index. It is the
74 responsibility of the user to ensure that the content table and the
77 An external content FTS4 table is created by setting the content option
80 not exist, then an external content table behaves in the same way as
84 CREATE VIRTUAL TABLE t3 USING fts4(content="t2", a, c);
91 the row in the content table with a rowid value equal to the current FTS
92 docid. Or, if such a row cannot be found in the content table, a NULL
96 CREATE VIRTUAL TABLE t3 USING fts4(content="t2", b, c);
107 -- of columns b and c from the row with rowid=3 in the content table
115 -- the FTS4 query 'k', even though the documents stored in the content
123 -- a row with rowid=3 within the content table.
128 When a row is deleted from an external content FTS4 table, FTS4 needs to
129 retrieve the column values of the row being deleted from the content table.
132 deleted. If the content table row cannot be found, or if it contains values
139 Instead of writing separately to the full-text index and the content table,
141 up to date with respect to the set of documents stored in the content table.
159 on the content table. This is so that FTS4 can still retrieve the original
164 content table, for the same reasons.
168 set of documents in the content table. Assuming again that "t3" is the
169 name of the external content FTS4 table, the command is: