Re: concating numeric with text

Can't you use something like

select 1::text || 'a';
?column?
----------
1a
(1 row)

? BTW, 6.5 is ancient.

On Fri, Dec 21, 2001 at 11:35:33AM +0530, denis(at)coralindia(dot)com wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>