> ok. As I am sure you realize it would be very useful to be able to > create case-insensitive indexes with: > > create index idx_my_index on my_table(lower(my_column));
How can you be sure which index sqlite will use when there are more indices on a field? > > culley > > On Friday, January 9, 2004, at 05:25 PM, D. Richard Hipp wrote: > > > culley harrelson wrote: > >> 1. Are indexes case sensitive as in postgresql? > > > Yes > > > >> 3. Any plans to allow index creation on functions (aka the date > >> functions)? > > > > Yes. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
