Rhaoni,
I could .. but this way I wont be used because Oracle doesn't accept such
sintax ! I changed gsames00.ano_mes from varchar to text ! But it still not
fast enough to take Oracle's place !!!
I still trying to do so ...
Well, your basic problem is that performance tuning for *any*
I solve this problem doing this:
create function date_to_mm( timestamp ) returns gsames00.ano_mes%type as
'select to_char($1, ''MM'');
' language sql immutable strict;
And changing the SQL where clause:
... gsames00.ano_mes = to_char(ftnfco00.data_emissao,'MM') AND ...
to:
Rhaoni Chiu Pereira [EMAIL PROTECTED] writes:
I need to know if there is a way to set the to_char output to varchar instead of
text !
Why don't you change the datatype of ano_mes to text, instead? It's
unlikely your application would notice the difference. (You could set
a CHECK constraint on