Re: [sqlite] FTS3 (Version 2 .6.23) - Is the boolean operator "AND" no more available?

> I wonder if the operator "AND" (in capitals letters) is yet available and > different from the basic term "and" (in lower letters). > > Make sure you compiled the sources with SQLITE_ENABLE_FTS3_PARENTHESIS, since according to docs SQLITE_ENABLE_FTS3_PARENTHESIS This option modifies the

Re: [sqlite] FTS3 (Version 2 .6.23) - Is the boolean operator "AND" no more available?

On Mar 14, 2010, at 5:34 AM, gerard.jouannot wrote: > Hello all SQLlite users. > > I wonder if the operator "AND" (in capitals letters) is yet > available and > different from the basic term "and" (in lower letters). Available only if FTS3 is compiled with this option:

[sqlite] FTS3 (Version 2 .6.23) - Is the boolean operator "AND" no more available?

Hello all SQLlite users. I wonder if the operator "AND" (in capitals letters) is yet available and different from the basic term "and" (in lower letters). Using the "MatchInfo" example of the documentation, I build an FTS3 virtual table like this: -- Create and populate an FTS3 table with four