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

Re: Stupid question: concatenating strings

From: <bmccoy(at)chapelperilous(dot)net>
To: Justin Long <justinlong(at)strategicnetwork(dot)org>
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: Stupid question: concatenating strings
Date: 2000-10-18 17:17:48
Message-ID: Pine.LNX.4.10.10010181316290.8716-100000@chapelperilous.net (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 18 Oct 2000, Justin Long wrote:

> I want to do the following
> 
> UPDATE newlink SET newfrom = substr(oldfrom,0,1) + '-' + substr(oldfrom,1)

The concatenation operator is '||' (two pipe symbols).

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
My haircut is totally traditional!


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2000-10-18 17:21:48
Subject: Re: Stupid question: concatenating strings
Previous:From: Justin LongDate: 2000-10-18 16:07:51
Subject: Stupid question: concatenating strings

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