SQL

Exclude constraint is a PostgreSQL extension that can implement more advanced and sophisticated database constraints.

Use Distinct On extension clause to quickly find records with maximum/minimum values within groups