Postgres Pro
Downloads
Home   >   mailing lists

Re: unique index for periods - Mailing list pgsql-general

From Harald Fuchs
Subject Re: unique index for periods
Date
Msg-id pufxbmpvjg.fsf@srv.protecting.net
Whole thread Raw
In response to unique index for periods  (Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>)
Responses Re: unique index for periods  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Tree view 
In article <20090820065819.GA2598@gheift.kawo1.rwth-aachen.de>,
Gerhard Heift <ml-postgresql-20081012-3518@gheift.de> writes:

> Hello,
> I try to create an unique index for a (time)period, and my goal is to
> prevent two overlapping periods in a row.

> ...

> Is there another solution to solve my problem?

Have a look at http://pgfoundry.org/projects/temporal

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: R: Field's position in Table
Next
From: Ivan Sergio Borgonovo
Date:
Subject: "ownership" of sequences, pseudo random unique id