--- On Fri, 10/19/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> > Is it possible to constraint both the LEFT and RIGHT
> > fields of a record to use the same index? I am looking for
> > a way to ensure for all LEFTs and RIGHTs in a table, that is
> > it is impossible for any LEFT or RIGHT to have to same
> > value.
> a check constraint ought to do it
True, but how do I insure that one record's left does not equal another record's right?
Regards,
Richard Broersma Jr.