A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx> schrieb: > am 18.02.2006, um 10:03:11 +0100 mailte Pailloncy Jean-Gerard folgendes: > > 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 > > You can write a trigger to check the count of records which overlaps > (start,end): Sorry, there are a problem: the trigger can't see uncommitted inserts from concurrent transactions. Thanks to AndrewSN for this hint. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
