This tip was at the end of a message (from Szűcs Gábor).
TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
it looks very important, but I cannot understand it. Sound as a small and easy mistake that can make things go sour...
Can someone explain it please? thanks, Alain ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq