concating numeric with text

Hi all,

I am using postgres 6.5 on Linux.

I want to concat text column with numeric column. In postgres 7.0, to_char
function is given. But it is not working with 6.5

I want to use the following select statement

"select text_col||number_col||date_col from my_table"

Any idea ?

Thanks in advance

Denis