I've worked around this issue a separate way, but I'd like to understand what went wrong in the first place here. I have an FTS3 table, and if I query with the following:
SELECT * FROM table WHERE keywords MATCH '(blah!)' I get the following error: malformed MATCH expression:_[(blah!)] If I remove either the parenthesis or the exclamation point, or add quotes around the parenthesis, the error disappears. I've read over all of the FTS docs and I don't see any reason why it shouldn't work (though it should ignore it with the default tokenizer -- but if I have a custom tokenizer, it should support the !, in theory). Any ideas? Thanks! -David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
