This is great! The main reason we decided not to use FTS in our project was lack of prefix searching. With this new functionality we'll probably switch to using FTS in a future update.
One suggestion though, instead of (or in addition to) using '*' as the prefix operator perhaps '%' would be more appropriate in order to be closer to the LIKE operator. Best regards, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Scott Hess [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 01, 2007 2:36 PM To: sqlite-users@sqlite.org Subject: [sqlite] Prefix searching for fts2. I just finished ( http://www.sqlite.org/cvstrac/chngview?cn=3893 ) checking in a string of changes to fts2.c to provide prefix search. This works like: ... -scott ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------