View Single Post

   
  #1 (permalink)  
Old 04-09-2008, 08:26 AM
Pailloncy Jean-Gerard
 
Posts: n/a
Default Non-Overlaping date interval index

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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote