SQLite Forum

FTS5 tables, = vs. MATCH, index 0, and "error: no such column"
Login
Acknowledged. I still have two questions:

(1) What's the deal with INDEX 0? Does it mean unindexed operation, or does it mean that there IS an index, but it's just not working for some reason?

(2) I understand that the UNINDEXED option allows me to exclude a column from the FTS5 indexing - but would there be any way to index the column like a normal column in a non-FTS5 table? (Because that would solve a lot of problems!)