On Mon, Apr 03, 2006 at 12:48:22PM -0400, Jim Nasby wrote: > I believe he's talking about something like > > CREATE INDEX books__id_title ON books(id_book, title DESC); > > which of course we don't support. But you can define a custom set of > operators that work backwards and use those to define the index, and > then use them in the ORDER BY. > > BTW, is there a TODO for this? Second request for it I've seen in a > week...
Well, if COLLATE support ever gets done, it'll fix this too and be SQL compliant to boot. Unfortunatly I havn't had much time to work on this recently and there hasn't been much interest externally. Last time I was bogged down by keeping up with the number of commits to the sort code which is ofcourse intimately related to this. One day... -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
signature.asc
Description: Digital signature
