Datatype support in PostgreSQL is second to none in major relational databases. Among other powerful and unique datatypes like arrays, geometric, and UUID, Range types provide developers with the ability to model real-world data while still leveraging the power of indexes, special operators, and more.

Introduced in PostgreSQL 9.2, range types allow developers to define data models that more naturally declare intent without complicated constraints across multiple columns. And, starting with PostgreSQL 14, multirange types added even more useful functionality to this already powerful data type.

In this talk we’ll review the history of range types in PostgreSQL, demonstrate how to create and populate data, briefly discuss indexing strategies, and more. By the end of session, you’ll understand how to use range types for fun and profit in your current or upcoming PostgreSQL projects.