There is also a description of an implementation for timetravel at http://www.varlena.com/GeneralBits/122.php
If you would like to discuss this further, please let me know. I've know postgres's and illustra's timetravel implementations. --elein [EMAIL PROTECTED] On Thu, Feb 23, 2006 at 10:52:13PM +0100, Bernhard Weisshuhn wrote: > On Thu, Feb 23, 2006 at 03:34:36PM -0300, Rodrigo Sakai <[EMAIL PROTECTED]> > wrote: > > > > I'm focus on temporal databases (not temporary), and I want to know if > > anyone here is studying this tecnologies too. So, we can exchange > > knowlegment. Specifically, anyone who is trying to implement on postgresql > > the aspect of time (temporal). > > These researches are lead by Richard Snodgrass. So, anyone who have > > something to share, please contact me! > > Not sure if I understand the problem correctly, but the contrib/spi/timetravel > module does something which I think may be what you are talking about. > > > http://developer.postgresql.org/cvsweb.cgi/~checkout~/pgsql/contrib/spi/README.timetravel > > The docs are a bit cryptic but you should be able to grasp if it suits > your needs. Basically you can go back to any point in tabe for a > timetravel table and make date based comparisons. > > Hope this helps, forgive my ignorance if if doesn't. > bkw > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
