PostgreSQL 11 Administration Cookbook

Real-world example – range of time

In many databases, there will be historical data tables with data that has a START_DATE value and an END_DATE value, or something similar. As in the previous example, we can solve this example elegantly with a range type. Actually, this example is even shorter – we don't need to create the range type since the most common cases are already built-in, and, to be precise, include integers, decimal values, dates, and timestamps with and without a time zone.