We needed a way to selectively order ASC or DESC in a Postgres window function. It turns out you can with CASE statements!