Skip site navigation (1) Skip section navigation (2)

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$ (view raw, whole thread or download thread mbox)
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


In response to


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group