Postgres Pro
Downloads
Home   >   mailing lists

Re: Stupid question: concatenating strings - Mailing list pgsql-novice

From
Subject Re: Stupid question: concatenating strings
Date
Msg-id Pine.LNX.4.10.10010181316290.8716-100000@chapelperilous.net
Whole thread Raw
In response to Stupid question: concatenating strings  ("Justin Long" <justinlong@strategicnetwork.org>)
List pgsql-novice
Tree view 
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!

pgsql-novice by date:

Previous
From: "Justin Long"
Date:
Subject: Stupid question: concatenating strings
Next
From: Lionel Bargeot
Date:
Subject: problem to compile 7.0.2