As far as I see your proposal, you want to allow something that is undefined to be reversed. I don't think this is a good idea at all. As mentioned by others, you should have ORDER BY clauses and just add a DESC.
* Okay, now I'm convinced of that. If you were looking for something to optimize in this rough area, then perhaps adding some kind of "Backward WindowAgg" node (by overloading the existing node) to allow queries such as the following to be executed without an additional sort. SELECT a,row_number() over (order by a desc) from t order by a; * David, considering this optimization, allowing for that, do you believe it is plausible to try advancing towards a possible Proof of Concept (PoC) implementation? Maiquel.