Re: [sqlite] FTS problem with 'NOT term' queries

On 02/04/2013 12:18 AM, Alexey Pechnikov wrote: Hello! And as result it's impossible to search docs in some situations: SELECT * FROM docs WHERE docs MATCH 'NOT sqlite'; Error: malformed MATCH expression: [NOT sqlite] As far as I can tell, in MATCH syntax NOT is a binary operator,

Re: [sqlite] FTS problem with 'NOT term' queries

Hello! > >> And as result it's impossible to search docs in some situations: >> SELECT * FROM docs WHERE docs MATCH 'NOT sqlite'; >> Error: malformed MATCH expression: [NOT sqlite] >> > > As far as I can tell, in MATCH syntax NOT is a binary operator, denoting > set difference. You are trying to

Re: [sqlite] FTS problem with 'NOT term' queries

The explanation right above that table of examples contains these important (I believe) phrases: ...BINARY SET operators... ...TWO operands to an operator... (emphasis mine) On Tue, Jan 29, 2013 at 11:30 PM, Alexey Pechnikov wrote: > SELECT * FROM docs WHERE docs MATCH

Re: [sqlite] FTS problem with 'NOT term' queries

On 1/29/2013 11:30 PM, Alexey Pechnikov wrote: From http://www.sqlite.org/fts3.html#section_3_1 we can see the query SELECT * FROM docs WHERE docs MATCH 'database NOT sqlite'; But the equal query doesn't works: SELECT * FROM docs WHERE docs MATCH 'NOT sqlite AND database'; Error: malformed