--- On Fri, 10/19/07, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/