Re: Unique Keys

"Tony Andrews" <andrewst_at_onetel.com> wrote in message news:<1101475141.683762.192200_at_z14g2000cwz.googlegroups.com>...
> Mikito Harakiri wrote:
> >
> > NATURAL JOIN syntax is so goofy! Isn't your view equivalent to
> >
> > select 0 from reservations r1, reservations r2
> > where r1.hotel_room = r2.hotel_room
> > AND r1.SPAN = r2.SPAN
> > ^^^^^^^^^^^^^^^^^^^^^
> > and OVERLAPS( r2.SPAN , r1.SPAN)
> >
> > which always evaluates to empty set?
>
> Goofy is right. To use NATURAL JOIN that query would have to be
> re-written as:
>
> ... which rather loses the intended elegance, doesn't it?

yeah , yeah, my enthusiasm is slightly evaporating :-(

strider Received on Sun Nov 28 2004 - 15:44:55 CET