On 8/19/06, Gerry Snyder <[EMAIL PROTECTED]> wrote:
Jonathan Ellis wrote: > (was the "+" some kind of shorthand I'm unfamiliar with?) > Yes. It tells sqlite not to use those fields as an index.
Ah, I see. When I tried "+f.mtime" it gave a "no such column" error, but that was because f was in the subquery now. So, now I've tried it with various combinations of + but I still can't get the file name index used. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------