On Jan 31, 2008 8:49 AM, Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com> wrote:
> I'd create a "previousTime" column and manage it using a trigger.
> Anyway, it depends on the time-dependancy of the table
> Then you can perform "temporal" in a much easier way.
> You could be interested in taking a look at the following link
>
> http://www.cs.arizona.edu/~rts/tdbbook.pdf
+1
That book provides many sane examples for handling temporal data. Recommended.