Re: [sqlite] a few questions about indexes

[Culley Harrelson]

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));

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]