Re: [sqlite] Indexing on multiple columns

2007-01-26 Thread Ben Supnik
Hi, Fascinating, thanks!! :-) Indeed this query does use the optimizer. :-) If I understand, by rewriting the query to have an AND statement at the top level and getting a simple comparison over to the left we can utilize the index. *cheers* Ben [EMAIL PROTECTED] wrote: SELECT name

[sqlite] Indexing on multiple columns

2007-01-26 Thread Ben Supnik
Hi Y'all, Is there a compact way (or is it even possible) to use multiple columns (that I have in my order-by clause) for an operator like > or >=? I have a database of airports, something like this: create table airports( id integer primary key, name varchar not null); create index