When 8.0 is released, TIP 9 should change from
TIP 9: the planner will ignore your desire to choose an index scan if
your joining column's datatypes do not match
to
TIP 9: the planner will ignore your desire to choose an index scan if
your joining column's datatypes do not match (upgrade to 8.0!)
We could change this now...
...and add another TIP to encourage people to upgrade...?
--
Best Regards, Simon Riggs