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 the length if you really want to duplicate the behavior of varchar(6).) Alternatively, try 7.4 beta. I believe this issue goes away in 7.4, because varchar no longer has separate comparison operators. Of course there's also the option of modifying to_char's result type in pg_proc, but I won't promise that doing so wouldn't break things. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster