Posted by --CELKO-- on 12/22/05 04:33

Your narative is vague and does not compile; why did you not post DDL
that everyone could use for testing?

The usual way to model events is to have a (start_time, end_time) pair
in the table because time is a continuum. A NULL end_time means the
event is on-going. The druation of the event is trival at that point.


A row is not a record -- a row has to be a complete fact, while a
record does not.

[Back to original message]