Re: query not using index for descending records? - Mailing list pgsql-sql

Hi,

| You probably don't want to do that. The DESC only applies to the
| one expression it follows. What you want is probably:
| explain select datetime,id from trafficlogs order by
| datetime desc,id desc limit 20;

This is exactly what I was after - worked a treat!

Thanks.

Darren