Re: Unique Keys
From: Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net>
Date: Wed, 24 Nov 2004 23:46:47 -0500
Message-ID: <nm4g72-cr6.ln1_at_pluto.downsfam.net>
>
> select 0 from Interval i1, Interval i2
> where i2.x between i1.x and i1.y
> or i2.y between i1.x and i1.y =
> ={}
Date: Wed, 24 Nov 2004 23:46:47 -0500
Message-ID: <nm4g72-cr6.ln1_at_pluto.downsfam.net>
Mikito Harakiri wrote:
> "Kenneth Downs" <firstinit.lastname_at_lastnameplusfam.net> wrote in message
> news:j8vf72-eg5.ln1_at_pluto.downsfam.net...
>> which requires a constraint that no two reservations can overlap.
>
> select 0 from Interval i1, Interval i2
> where i2.x between i1.x and i1.y
> or i2.y between i1.x and i1.y =
> ={}
yes, but that is not a unique constraint. Is there anyway at all to imagine it as a declarative unique constraint? If we were "thinking outside of the box" as it were?
-- Kenneth Downs <?php $sig_block="Variable scope? What's that?";?>Received on Thu Nov 25 2004 - 05:46:47 CET