How to ORDER BY using the contents of a column in Postgres (opens in new tab)

(knock.app)

6 pointsbrentjanderson3y ago1 comments

1 comments

1 comments · 1 top-level

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

j / k navigate · click thread line to collapse