When I work with other relational databases I am reminded about how I can't use my favorite PostgreSQL hacks in them.
I call these hacks PostgreSQLisms. A PostgreSQLism is a pattern of SQL unique to PostgreSQL or descendants of PostgreSQL.
In this post I'm going to cover some of my favorite ones.