--- "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.
George
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
