PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Jeff Davis
Day Talks - 1 - Thursday - 2012-05-17
Room MRT 212
Start time 14:30
Duration 01:00
ID 439
Track 9.2 Features
Language used for presentation English

Range Types and Temporal: Past, Present, and Future

Range Types didn't exist before, why do we need them now? How do they work? Why is "Temporal" important if we already have timestamps? How do we apply these concepts before deploying PostgreSQL 9.2? What's left to be done, and what solutions are in the works?

I'll be asking the audience these questions, so -- Err... I mean: I will be answering these questions during the talk.

Extensions, changes to core postgresql, and future ideas will be described in the context of solving a simple use case from 2006. These ideas build up to the larger point that powerful types are important, and database systems should do more to support them.