concating numeric with text

From: denis(at)coralindia(dot)com
To: <pgsql-novice(at)postgresql(dot)org>
Subject: concating numeric with text
Date: 2001-12-21 06:05:33
Message-ID: 000b01c189e5$81021d00$0232a8c0@coralindia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Vijay Deval 2001-12-21 09:01:32 Re: Import DB from DOS- dbase4
Previous Message Tom Lane 2001-12-20 23:33:35 Re: Using a tablename as a parameter to a function.