May 2018
Intermediate to advanced
576 pages
30h 25m
English
In many databases, there will be historical data tables with data that has a START_DATE 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 precisely—integers, decimal values, dates, and timestamps with and without a time zone.