On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> 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
check (field1<>field2)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
