Re: [sqlite] Adding additional operators to FTS3

2007-09-15 Thread Klemens Friedl
FTS1 and FTS2 don't provide any grouping operator (i.e. parentheses). e.g. 'pumpkin (onions OR cheese)' Are there plans to provide support for it in FTS3 (or FTS4) ? Klemens - To unsubscribe, send email to [EMAIL PROTE

RE: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Linus Upson
ql! Linus -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 14, 2007 1:50 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Adding additional operators to FTS3 "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > The /10 syntax makes sen

Re: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread drh
"Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > The /10 syntax makes sense to programmers but I think users are going to > forget it pretty quickly. Same with "OR" an "NEAR" being required to be all > caps (I didn't know that). Ideally the UI an application exposes would show > the user that OR and

RE: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Samuel R. Neff
area. If interested contact [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 14, 2007 3:45 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Adding additional operators to FTS3 "Scott Hess" <[EMAIL PROTEC

Re: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread drh
"Scott Hess" <[EMAIL PROTECTED]> wrote: > > One thing I'll think on in the background as a how-to-integrate > question is the balance between sophistication for query experts > versus the approachability for non-experts. For some systems, having > things like proximity queries complicates the que

Re: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Scott Hess
sponse, much appreciated. Guess I better go and look > at the query parser. > > Thanks again > > Mike > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 14 September 2007 19:22 > To: sqlite-users@sqlite.org > Subject: Re: [sqlit

RE: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Mike Marshall
Thanks for the quick response, much appreciated. Guess I better go and look at the query parser. Thanks again Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 September 2007 19:22 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Adding additional

Re: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread drh
"Mike Marshall" <[EMAIL PROTECTED]> wrote: > > 1) We need to be able to index items such as AT&T, this seems like > it's a case of replacing the default tokeniser with our own implementation Correct. > > 2) A NEAR query operator so we can do things like 'foo NEAR10 bar' > which wil

[sqlite] Adding additional operators to FTS3

2007-09-14 Thread Mike Marshall
Hi all Currently we use SQLite in several of our products (feel free to add us to the companies page, Lexalytics - www.lexalytics.com) and are now looking at replacing the fulltext engine in one of those projects with FTS. We've done some testing etc (on fts2) and are pretty sure that it can