As an aside, I just jumped around and read a few articles. This entire blog looks excellent. I’m going to have to spend some time reading it. I didn’t know about Postgres’s range types.

Range types are a godsend when you need to calculate things like overlapping or intersecting time/date ranges.