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

Re: concating numeric with text

From: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
To: denis(at)coralindia(dot)com, PostgreSQL-Novice <pgsql-novice(at)postgreSQL(dot)org>
Subject: Re: concating numeric with text
Date: 2001-12-21 17:20:12
Message-ID: 20011221182012.C513@frithjof (view raw or flat)
Thread:
Lists: pgsql-novice
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
> 

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2001-12-21 19:13:09
Subject: Re: appropriate sort_mem & shared buffers
Previous:From: Markus BertheauDate: 2001-12-21 17:05:31
Subject: appropriate sort_mem & shared buffers

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