Re: [sqlite] FTS3 and negation operator

2009-08-15 Thread cscs-sqlite
Dan, updating to sqlite3.dll version 3.6.17 did fix the problem. Also, I should clarify what I meant by having the query syntax doc on the sqlite web site. It is indeed on the web site, but I spent a lot of time yesterday trying to find a document just like it and couldn't. It just needs to be

Re: [sqlite] FTS3 and negation operator

2009-08-15 Thread cscs-sqlite
Dan, thank you for the additional information, it's most helpful. I'll let you know what I find out. BTW, any reason that doc is not on the SQLite Web site? It would help a lot of people understand the old and new query syntax better. Craig > > > > Did an FTS3 update change how many negation

Re: [sqlite] FTS3 and negation operator

2009-08-14 Thread Dan Kennedy
On Aug 15, 2009, at 9:32 AM, cscs-sql...@usa.net wrote: > > Did an FTS3 update change how many negation operators (dash/-) can > be used in > a > match statement? > > For example, in sqlite3.dll version 3.5.7: > > colname match 'tetons -bend -jackson -oxbow* -parks' works as > expected;

[sqlite] FTS3 and negation operator

2009-08-14 Thread cscs-sqlite
Did an FTS3 update change how many negation operators (dash/-) can be used in a match statement? For example, in sqlite3.dll version 3.5.7: colname match 'tetons -bend -jackson -oxbow* -parks' works as expected; bend, jackson, oxbow* and parks are all removed from the results. but With,