On 8/2/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > On Wed, 2005-08-03 at 00:05 +0200, Martijn Voncken wrote: > > I'm using pysqlite2,compiled against sqlite 3.2.1 > > I thought that IN uses an index. > > > > Versions 3.2.2 and earlier only use IN in an index if > the column on the left of the IN operator is the > left-most column in the index. This constraint is > relaxed in the latest code in CVS and in the next > release. > > On Tue, 2005-08-02 at 15:41 -0700, Cory Nelson wrote: > > BETWEEN doesn't use an index either. I have yet to get an > > explaination for either of them :( > > > > BETWEEN will use an index in the latest code in > CVS which will appear in the next release.
Sounds great! > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > -- Cory Nelson http://www.int64.org