Thanks Richard. In the case of using a index modifying tokenizer like
Porter, is there a way to know which of the MATCH terms it actually matched
on or is that lost information?
On Wed, Sep 19, 2012 at 3:44 AM, Richard Hipp wrote:
> On Wed, Sep 19, 2012 at 2:42 AM, E. Timothy Uy wrote:
>
> > Le
On Wed, Sep 19, 2012 at 2:42 AM, E. Timothy Uy wrote:
> Let's say I have a table Data_content(term TEXT UNIQUE) which has an
> indexed column 'term'. I then create an FTS4 table using
>
> CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term);
>
> If I later search using SELECT * FRO
Let's say I have a table Data_content(term TEXT UNIQUE) which has an
indexed column 'term'. I then create an FTS4 table using
CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term);
If I later search using SELECT * FROM Data WHERE term IN (...), does it use
the indexes generated in D
3 matches
Mail list logo