Yes i tried that already - and as you said, it works. But i need to have one
column sorted DESC and one ASC. Is there any way this could be done ?
Regards,
Jernej Kos.
On Wednesday 16 of June 2004 08:12, Martijn van Oosterhout wrote:
> 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,
--
Jernej Kos <kostko(at)jweb-network(dot)net>
JWeb-Network