Lines Matching refs:docid

32   integer docid value. For example:
35     INSERT INTO t1(docid, a, b, c) VALUES(1, 'a b c', 'd e f', 'g h i');
37     -- This statement causes an error, as no docid value has been provided:
45   the docid column. The auxiliary function matchinfo() may be used, but
49     SELECT docid FROM t1 WHERE t1 MATCH 'xxx';
50     SELECT docid FROM t1 WHERE a MATCH 'xxx';
54     -- other than docid are required to evaluate them.
57     SELECT docid FROM t1 WHERE a LIKE 'xxx%';
60   Errors related to attempting to retrieve column values other than docid
64   other than docid.
70   docid, FTS4 attempts to retrieve that value from a table (or view, or 
90   docid, FTS attempts to read this value from the corresponding column of
92   docid. Or, if such a row cannot be found in the content table, a NULL
100     INSERT INTO t3(docid, b, c) SELECT id, b, c FROM t2;
106     -- term matches the row with docid=3. It then retrieves the values
114     -- full-text index still indicates that the row with docid=3 matches
145       DELETE FROM t3 WHERE docid=old.rowid;
148       DELETE FROM t3 WHERE docid=old.rowid;
152       INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);
155       INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c);