Check the CREATE TABLE statement. Possibly you use VARCHAR type and your data has trailling spaces. Try to TRIM all the data in your database or remove trailling spaces using text editor.
---------------------------(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