Non-Overlaping date interval index - Mailing list pgsql-general

From Pailloncy Jean-Gerard
Subject Non-Overlaping date interval index
Date
Msg-id CA960DE3-2851-4AA4-8995-FDF6071C5398@rilk.com
Whole thread Raw
Responses Re: Non-Overlaping date interval index  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Non-Overlaping date interval index  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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


pgsql-general by date:

Previous
From: "Jan Cruz"
Date:
Subject: Re: PostgreSQL Functions / PL-Language
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Non-Overlaping date interval index