On Jan 31, 2008 8:49 AM, Enrico Sirola <enrico.sirola@xxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
