Simon Riggs <[EMAIL PROTECTED]> writes:
> I had understood the discussion to conclude that indexes that do not
> depend on any column of the table to not be allowed at all.
That was my first reaction too, but the point about unique-index behavior
refutes it. Constraining a table to have at most one row is useful.
regards, tom lane
---------------------------(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
