George,
I'd like to thank you for the link as well. It looks really interesting after reading the front matter.
On Oct 16, 2004, at 10:07 AM, George Essig wrote:
--- "Eric D. Nielsen" <[EMAIL PROTECTED]> wrote:
Thanks for the Snodgrass reference, it is rather similar and pre-dates
the book I was looking at. (Same notion of valid/transaction times,
but Date's non-SQL approach) From a quick skim it doesn't address the
distinction Date et al draw between historic and current temporal data;
however it looks very useful for mapping their concepts to SQL.
Eric
You might want to look at Section 7.5 Temporal Partitioning. One table is used to store current
data and another table is used to store historic data.
I am very interested in hearing what you've done in PostgreSQL related to this. I probably should read through the text (isn't PDF wonderful?) before you go into detail, but a brief overview would be great.
Thanks again for your time.
Cheers,
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
