Re: [sqlite] Stemming Query

[Mike King]

Thanks for a quick answer.

On Tuesday, 12 February 2013, Richard Hipp wrote:

> On Tue, Feb 12, 2013 at 5:50 PM, Mike King 
> >
> wrote:
>
> > Is there any way to turn stemming on/off for a FTS3 table? I create my
> FTS3
> > table as follows:
> >
> > CREATE VIRTUAL TABLE FreeText USING fts3(Content TEXT NOT NULL,
> > tokenize=porter)
> >
> > I'd like to be able to offer the option of whether to use stemming when
> > searching (much like some other freetext databases do) as stemming is
> great
> > for words and text but not so good for invoice or reference numbers etc.
> >
> > The only way I could think of doing it is by having two freetext tables -
> > one with stemming and one without but this is less than ideal because of
> > duplication,
> >
> > Anyone got any ideas?
> >
>
> The index is over the stemmed words.  So if you change the stemmer (or turn
> if off completely) then you have to recreate the index.
>
> So, yes, the only way to do this is to have two tables, one with stemming
> and the other without.
>
> --
> D. Richard Hipp
> d...@sqlite.org 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Stemming Query

[Richard Hipp]

On Tue, Feb 12, 2013 at 5:50 PM, Mike King  wrote:

> Is there any way to turn stemming on/off for a FTS3 table? I create my FTS3
> table as follows:
>
> CREATE VIRTUAL TABLE FreeText USING fts3(Content TEXT NOT NULL,
> tokenize=porter)
>
> I'd like to be able to offer the option of whether to use stemming when
> searching (much like some other freetext databases do) as stemming is great
> for words and text but not so good for invoice or reference numbers etc.
>
> The only way I could think of doing it is by having two freetext tables -
> one with stemming and one without but this is less than ideal because of
> duplication,
>
> Anyone got any ideas?
>

The index is over the stemmed words.  So if you change the stemmer (or turn
if off completely) then you have to recreate the index.

So, yes, the only way to do this is to have two tables, one with stemming
and the other without.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Stemming Query

[Mike King]

Is there any way to turn stemming on/off for a FTS3 table? I create my FTS3
table as follows:

CREATE VIRTUAL TABLE FreeText USING fts3(Content TEXT NOT NULL,
tokenize=porter)

I'd like to be able to offer the option of whether to use stemming when
searching (much like some other freetext databases do) as stemming is great
for words and text but not so good for invoice or reference numbers etc.

The only way I could think of doing it is by having two freetext tables -
one with stemming and one without but this is less than ideal because of
duplication,

Anyone got any ideas?

Cheers,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users