Dear Friends As Subject How to resolve, since i use with out problem on postgresql 7.3 Regards Luiz ---------------------------(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