Horton

Re: Stupid question: concatenating strings

Brett W. McCoy <bmccoy@chapelperilous.net>

View thread View on postgr.es
From: <bmccoy@chapelperilous.net>
To: Justin Long <justinlong@strategicnetwork.org>
Cc: pgsql-novice@hub.org
Date: 2000-10-18T17:17:48Z
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!