PostgreSQL custom SQL collations

I had used this feature before and forgotten about it, but it's really cool. In Postgres you can use expressions in order-by clauses. ┬áThis is incredibly powerful because it allows you to have your own custom collation or sort sequence for "order by" clauses. For example, I have a simple table of people and tshirt … Continue reading PostgreSQL custom SQL collations