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
But this does:
select 'a' || 'b';
Look at the Postgres manual section on String concatenation.
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
> and transform it to this:
> 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(at)egroups(dot)com
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2000-10-18 17:34:00|
|Subject: Re: problem to compile 7.0.2 |
|Previous:||From: Justin Long||Date: 2000-10-18 17:28:55|
|Subject: Thanks for all the answers!|