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'

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_flashback.htm http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_... [2] https://en.wikipedia.org/wiki/Slowly_changing_dimension#Type_4 https://en.wikipedia.org/wiki/Slowly_changing_dimension#Type...