Ok - just to end this thread, I think I understand what I was missing. I'll stop this thread, and just comment on my first thread.
Thank you everyone who helped
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
