It'd be nice if we could see a Postgres patch that works exactly like Oracle's Flashback [1]. You can simply do: SELECT * FROM TABLE AS OF '2015-07-01 08:05:04' and it works as expected.

This article is just reinventing Kimball's Slowly Changing Dimensions Type 4 [2].

[1] http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_...

[2] https://en.wikipedia.org/wiki/Slowly_changing_dimension#Type...