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(at)svana(dot)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.