How to ORDER BY using the contents of a column in Postgres | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		How to ORDER BY using the contents of a column in Postgres (knock.app)
		6 points by brentjanderson on Nov 2, 2022 \| hide \| past \| favorite \| 1 comment

brentjanderson on Nov 2, 2022 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact