On Jul 2, 2008, at 2:53 AM, Alexey Pechnikov wrote: > В сообщении от Tuesday 01 July 2008 23:47:50 > [EMAIL PROTECTED] написал(а): >> On Tue, 1 Jul 2008, Alexey Pechnikov wrote: >>> Is any difference between "CREATE INDEX ev_idx ON events(type,eid)" >>> and "CREATE INDEX ev_idx ON events(type,eid desc)"? What is "desc" >>> keyword for index? >> >> The DESC keyword creates the index in descending collation order, >> rather >> than ascending order (default). I believe this sort order may not be >> observed in older versions, but more recent ones do so. > > I'm using SQLite 3.5.9 and there are no differents in my tests > between DESC > and default indeces. I try create index with keywork DESC for > optimize DESC > sorting but it don't work for me. My tests you can see above.
Have you seen the notes on file-format and "pragma legacy_file_format" in the documentation for CREATE INDEX? http://www.sqlite.org/lang_createindex.html Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users