Non-Overlaping date interval index

From: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
To: Postgres list general mailing <pgsql-general(at)postgresql(dot)org>
Subject: Non-Overlaping date interval index
Date: 2006-02-18 09:03:11
Message-ID: CA960DE3-2851-4AA4-8995-FDF6071C5398@rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I wonder how to have a sort of "uniq" index on date interval, such
that there is no date interval overlaping in the table.

exemple:
create table test (start timestamp, end timestamp);
with the constraint: end > start

Cordialement,
Jean-Gérard Pailloncy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-02-18 09:18:23 Re: Non-Overlaping date interval index
Previous Message Jan Cruz 2006-02-18 08:48:55 Re: PostgreSQL Functions / PL-Language