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" <nielsene@MIT.EDU> 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