On Mon, 2008-05-26 at 10:59 -0700, Jeff Davis wrote:
> On Mon, 2008-05-26 at 06:49 -0400, Andrew Dunstan wrote:
> > > * temporal foreign keys
> > > * temporal joins
> > >
> >
> > Maybe I'm being dense, but how does inclusion in core help you do these
> > things? Or, more precisely, how does non-inclusion in core prevent them.
>
> Temporal FK's can be implemented with triggers, but can't be
> implemented with the current FK syntax and mechanism. Any extensions to
> the FK syntax to support this would need to be done in postgres.
>
> Temporal joins can be implemented by joining with the "overlaps"
> operator and selecting the intersection of the two period columns.
> Anything added would be syntactic sugar.
Either overlaps or contains seem valid join operators
Will there be UNIQUE (non-overlapping) indexes for period ?
--------------
Hannu
