Re: Multicolumn indexes and ORDER BY

On Wed, Jun 16, 2004 at 07:12:26AM +0200, Jernej Kos wrote:
> I have a multicolumn index on two columns. If i use the columns in ORDER BY
> like this:
>   ORDER BY col1, col2;
>
> The index is used. But, if one column is sorted DESC it is not used:
>   ORDER BY col1 DESC, col2;
>
> How can i make this work ?

Try:

ORDER BY col1 DESC, col2 desc;

Hope this helps,
--
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.