Kurt Welgehausen wrote:
1) create an index in descending order ?
No. See <http://www.sqlite.org/lang.html#createindex>.
Read the paragraph after the syntax description.
True. But ascending indices can be traversed in reverse
order (if you put the DESC keyword on an ORDER BY). So
why would anybody want a descending index in the first
place? What doe a descending index give you that you
don't have with an ascending index?
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]