> I'm not sure if I understood the fts table declaration format and > posibilieties but is it possible to make SQLite index only a single text > column in a table containing multiple text columns?
No. All tables in FTS3 are indexed text, regardless of how you declare them. If you don't want your other columns to be indexed, you can split them into a separate table (keeping the FTS3 table only for indexed text) and join them using the implicit docid column of your FTS3 table. Alex. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
