Hi, I'm using the SQLite virtual table mechanism to create an SQL interface for a specialized relational database that doesn't speak SQL natively. Thanks to Jay Kreibich's great "Using SQLite", the implementation has been pretty straightforward so far.
Now I'm working on the xBestIndex/xFilter functions to make use of available indexes for better performance. In xBestIndex, each constraint contains the column on the left-hand side (iColumn) and the operator (op). If I understood correctly, xFilter gets the value on the right-hand side of each constraint you chose to use. But I need to know not only that value in xFilter, but also the column on the left-hand side and the operator. I'm wondering if there is any way to pass that additional information to xFilter besides encoding it into idxNum/idxStr somehow. Thanks for your help. Regards, Sören _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
