Time-related range types revisited
PostgreSQL has built in support for a number of range data types, including number, date and timestamp ranges. In this presentation I will focus on the latter two. The need for date and time ranges, or ranges in general has always existed. First intents were done using two table fields for the limits and trigger functions to manage their values. The PostgreSQL implementation of the built in range types is a much more valid and flexible option that simplifies their usage and includes very efficient operators. They can be used in indexes for simple searches or exclusion requirements. So it becomes very simple to implement portions of business logic within the database, profiting from its advantages, such as reliability, efficient queries and, in particular, data integrity.
A special rate for accommodation at Crowne Plaza Airport hotel is was available for all attendees of PG Day’17 Russia.