Lines Matching refs:text
4 Normally, in order to create a full-text index on a dataset, the FTS4
9 designed to extend FTS4 to support the creation of full-text indexes where:
18 the full-text index, the content option can sometimes be used to achieve
73 to the content table does not affect the full-text index. It is the
75 full-text index are consistent.
103 -- the text values "i j" and "k l".
105 -- The query uses the full-text index to discover that the MATCH
113 -- time containing the text values "xxx" and "yyy". This is because the
114 -- full-text index still indicates that the row with docid=3 matches
130 This is so that FTS4 can update the full-text index entries for each token
139 Instead of writing separately to the full-text index and the content table,
140 some users may wish to use database triggers to keep the full-text index
160 values in order to update the full-text index. And the INSERT trigger must
167 deletes the entire full-text index and rebuilds it based on the current
174 only be useful if the full-text index has somehow become corrupt. It is an
175 error to attempt to rebuild the full-text index maintained by a contentless