Re: Stupid question: concatenating strings

This does not work either:
select 'a' + 'b';
ERROR:  Unable to identify an operator '+' for types
'unknown' and 'unknown'
        You will have to retype this query using an explicit
cast

But this does:
select 'a' || 'b';
 ?column? 
----------
 ab
(1 row)

Look at the Postgres manual section on String concatenation.

Bill
Justin Long wrote:
> 
> I can't figure out how to do this.
> 
> I want to do the following
> 
> UPDATE newlink SET newfrom = substr(oldfrom,0,1) + '-' + substr(oldfrom,1)
> 
> ... I want to do this:
> 
> take the following variables
> 
> CAFG
> CBTN
> CNPL
> CUSA
> 
> and transform it to this:
> 
> C-AFG
> C-BTN
> C-NPL
> C-USA
> 
> Someone please help me! I've been through the user manual & I can't find out
> how to do it. Pgsql just tells me:
> 
> Unable to identify an operator '+' for types 'text' and 'unknown'
> You will have to retype this query using an explicit cast
> 
> _________________________________________________________________
> Justin Long                             Network for Strategic Missions
> 1732 South Park Court           Never retreat. Never surrender.
> Chesapeake, VA 23320, USA       Never cut a deal with a dragon.
> 757-213-2055, ICQ 83384482      http://www.strategicnetwork.org
> Monday Morning Reality Check:   reality-check-subscribe@egroups.com