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