Lines Matching refs:docid
56 set r [db eval {SELECT docid FROM t1 WHERE words MATCH $q ORDER BY docid}]
65 SELECT docid FROM t1 EXCEPT SELECT docid FROM t1_docsize
70 SELECT docid FROM t1_docsize EXCEPT SELECT docid FROM t1
84 SELECT docid, mit(matchinfo(t1, 'pcxnal')) FROM t1 WHERE t1 MATCH 'melchizedek';
89 SELECT docid, mit(matchinfo(t1, 'pcxnal')) FROM t1
91 ORDER BY docid;
96 SELECT docid, mit(matchinfo(t1, 'pcxnal')) FROM t1
98 ORDER BY docid;
104 DELETE FROM t1 WHERE docid!=1050026;
112 SELECT docid FROM t1 EXCEPT SELECT docid FROM t1_docsize
117 SELECT docid FROM t1_docsize EXCEPT SELECT docid FROM t1
124 SELECT docid, mit(matchinfo(t1, 'pcxnal')) FROM t1
126 ORDER BY docid;
145 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
166 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
190 db eval {SELECT docid FROM t1 WHERE words MATCH $::q ORDER BY docid}
202 UPDATE t1_docsize SET size=x'88' WHERE docid=1;