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

1 comment

[ 3.3 ms ] story [ 10.7 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!