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 use it as a unary operator.
Well, and how to rewrite query MATCH 'NOT sqlite'? In simple FTS qery syntax is possible to use "-sqlite" but is the equal construction by extended syntax? Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users