I'm using sqlite 3.6.23.1. I have a FTS3 table created using:
CREATE VIRTUAL TABLE EntryHeaders USING FTS3( Paragraph, Title, tokenize=porter ); The following individual queries work and return rows: SELECT rowid FROM EntryHeaders eh WHERE ( eh.Paragraph MATCH '91' ) SELECT rowid FROM EntryHeaders eh WHERE ( eh.Title MATCH 'civil' ) But I'm not getting any results when I combine these using OR: SELECT rowid FROM EntryHeaders eh WHERE ( eh.Paragraph MATCH '91' ) OR ( eh.Title MATCH 'civil' ) in the sqlite3 command-line program I get an error "Error: unable to use function MATCH in the requested context". Any pointers, please? Nick Hodapp _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users