Rhaoni, > ... gsames00.ano_mes = to_char(ftnfco00.data_emissao,'YYYYMM') AND ...
> Then it uses the gsames00 index instead of a SeqScan 'cuz it is > camparing same data type, but .. I don't want to create this function 'cuz > this aplication is used with Oracle too. You should have said that earlier .... > I need to know if there is a way to set the to_char output to varchar > instead of text ! Did you try: ... gsames00.ano_mes = (to_char(ftnfco00.data_emissao,'YYYYMM')::VARCHAR) AND ... -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])