RE: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Linus Upson
-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 sense to prog

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

RE: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Samuel R. Neff
ested 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 PROTECTED]&

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

Re: [sqlite] Adding additional operators to FTS3

2007-09-14 Thread Scott Hess
t; > 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 operators to FTS3 > > "Mike Marshall" <[EMAIL PROTECTED]> wr

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, 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 will