How to ORDER BY using the contents of a column in Postgres (knock.app)

1 comment

[ 1.6 ms ] story [ 15.1 ms ] thread

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