I generate queries like this in a paging library I wrote at work, I did not use the tuple comparison because sometimes the sorting order is different between fi

I generate queries like this in a paging library I wrote at work, I did not use the tuple comparison because sometimes the sorting order is different between fields, each field in the tuple comparison would need a different operator, such as WHERE Posts.CreateAt > ?1 OR (Posts.CreateAt = ?1 AND Posts.Id < ?2) ORDER BY Posts.CreateAt ASC, Posts.Id DESC I now wonder if it might be possible to use a negation operator to invert the sorting order, like: (Posts.Id, -Posts.CreateAt) < (?1, ?2) ORDER BY Posts.CreateAt ASC, Posts.ID DESC and keep the performance improvement.