sorting by id is also a nice UI thing, on reflection. Perhaps we should make the index: CREATE INDEX bugtask__date_closed__id__idx ON BugTask (date_closed, id desc nulls first);
which will support ORDER BY date_closed desc, id
sorting by id is also a nice UI thing, on reflection. Perhaps we should make the index: _date_closed_ _id__idx ON BugTask (date_closed, id desc nulls first);
CREATE INDEX bugtask_
which will support ORDER BY date_closed desc, id