I'll be speaking on this use case next week at Postgres Open ( http://postgresopen.org ) as part of a larger demo of temporal databases in postgresql.

Jonathan S. Katz will also be presenting on Range Types.